Skip to content

Policies without entry_type "new_entry" #19

Description

@ingonader

In the dataset downloaded on 29 Jun 2020, there are 1282 policies that are missing one ore more "new_entry" entry_type.

A quick summary shows that most (but not all) of these have only one record per type / type_sub_cat:

> dat_measures_coronanet_core_raw %>%
+     group_by(policy_id) %>%
+     summarize(
+         n_records = n(),
+         n_type = length(unique(type)),
+         n_type_sub_cat = length(unique(type_sub_cat)),
+         n_new_entry = sum(tolower(entry_type) == "new_entry"),
+         n_update = sum(tolower(entry_type) == "update")
+     ) %>%
+     filter(n_new_entry < n_type_sub_cat)# %>%
# A tibble: 1,282 x 6
   policy_id n_records n_type n_type_sub_cat n_new_entry n_update
   <chr>         <int>  <int>          <int>       <int>    <int>
 1 1000509           3      1              3           0        3
 2 1011788           9      1              3           0        9
 3 1025414           1      1              1           0        1
 4 1052186           1      1              1           0        1
 5 1064737           2      1              2           0        2
 6 1068927           1      1              1           0        1
 7 10796             1      1              1           0        1
 8 1084001           1      1              1           0        1
 9 1100210           1      1              1           0        1
10 1101567           1      1              1           0        1
# … with 1,272 more rows```

An example with more than one record:

```r
> dat_measures_coronanet_core_raw %>%
+     filter(policy_id == "1011788") %>%
+     arrange(country, type, type_sub_cat, date_announced) %>% 
+     select(record_id, policy_id, country, date_announced, date_start, date_end, type, type_sub_cat, entry_type, update_type)
# A tibble: 9 x 10
  record_id policy_id country   date_announced date_start date_end   type                             
  <chr>     <chr>     <chr>     <date>         <date>     <date>     <chr>                            
1 7498682Dp 1011788   Indonesia 2020-03-25     2020-03-30 2020-04-11 Closure and Regulation of Schools
2 1558545Dp 1011788   Indonesia 2020-04-08     2020-04-13 2020-04-28 Closure and Regulation of Schools
3 1011788Dp 1011788   Indonesia 2020-05-30     2020-05-30 2020-06-18 Closure and Regulation of Schools
4 7498682Dq 1011788   Indonesia 2020-03-25     2020-03-30 2020-04-11 Closure and Regulation of Schools
5 1558545Dq 1011788   Indonesia 2020-04-08     2020-04-13 2020-04-28 Closure and Regulation of Schools
6 1011788Dq 1011788   Indonesia 2020-05-30     2020-05-30 2020-06-18 Closure and Regulation of Schools
7 7498682El 1011788   Indonesia 2020-03-25     2020-03-30 2020-04-11 Closure and Regulation of Schools
8 1558545El 1011788   Indonesia 2020-04-08     2020-04-13 2020-04-28 Closure and Regulation of Schools
9 1011788El 1011788   Indonesia 2020-05-30     2020-05-30 2020-06-18 Closure and Regulation of Schools
  type_sub_cat                                                                entry_type update_type     
  <chr>                                                                       <chr>      <chr>           
1 Preschool or childcare facilities (generally for children ages 5 and below) update     NA              
2 Preschool or childcare facilities (generally for children ages 5 and below) update     NA              
3 Preschool or childcare facilities (generally for children ages 5 and below) update     Change of Policy
4 Primary Schools (generally for children ages 10 and below)                  update     NA              
5 Primary Schools (generally for children ages 10 and below)                  update     NA              
6 Primary Schools (generally for children ages 10 and below)                  update     Change of Policy
7 Secondary Schools (generally for children ages 10 to 18)                    update     NA              
8 Secondary Schools (generally for children ages 10 to 18)                    update     NA              
9 Secondary Schools (generally for children ages 10 to 18)                    update     Change of Policy

The record_ids of these are:

"1000509", "1011788", "1025414", "1052186", "1064737", "1068927", "10796", "1084001", "1100210", "1101567", "1120861", "1131276", "1133827", "1135464", "1140145", "1153902", "1155798", "1158301", "1163020", "117164", "1176872", "1180576", "1181795", "1213131", "1222760", "1225891", "1230354", "1231418", "1236078", "1251261", "1253869", "1257213", "1257936", "1267266", "1267527", "1270943", "1274736", "128880", "1291080", "1307388", "1328313", "1337909", "1342691", "1356452", "1362319", "1371367", "1375594", "1376049", "1392693", "1401604", "1410115", "1410537", "1415469", "142214", "1443320", "146165", "1463670", "1484325", "1484350", "1493329", "1504183", "1517540", "1551660", "1564016", "1569199", "1599366", "1603220", "1613957", "1617564", "1620688", "1622588", "1625716", "1629600", "1632827", "1639410", "165775", "1660511", "1660589", "1667070", "1668717", "1690945", "1692701", "1705983", "1708119", "1708769", "1711014", "1748374", "1768997", "1772974", "1775505", "1796780", "1798720", "1817472", "1820457", "1824507", "1828264", "1849318", "1868262", "1868570", "1872909", "187490", "1878887", "1887391", "1888784", "1889974", "1890157", "1891588", "189203", "1895410", "1908225", "1912607", "1926832", "1930973", "1932163", "1940449", "19543", "1957848", "1958851", "1965091", "1982993", "1983575", "1988987", "2000466", "2025589", "2035180", "2036036", "2057867", "2059245", "2061122", "2103227", "2103960", "2110937", "2112253", "2118703", "2132860", "2136978", "2142027", "2145363", "2149548", "2150579", "2171370", "2179158", "2203320", "2205274", "221452", "2219137", "2227511", "2236901", "2242308", "2243570", "2244128", "2247631", "2248568", "2250810", "2259485", "2292730", "2295892", "2316122", "2331945", "2333417", "2369701", "2374367", "2384103", "2387161", "2398210", "2403222", "2409269", "2411090", "241285", "2422565", "2431564", "2437952", "244428", "2444522", "2451882", "2461172", "246640", "2471329", "2492779", "2496144", "2501722", "250577", "2530139", "2535253", "254433", "2548987", "2554913", "2565082", "2566635", "257116", "2575122", "2576082", "2580000", "25809", "2581133", "2582965", "2589", "2602893", "2614936", "2615401", "2619354", "2619690", "2622295", "2627803", "2646780", "2649989", "2651383", "2663437", "2664087", "2672863", "2675008", "2677119", "2679041", "2679210", "2679720", "2682341", "2690257", "2696257", "2712544", "2713134", "2713527", "2719777", "2719780", "272409", "2728737", "2733987", "2734670", "2755124", "2764326", "2769886", "2798707", "2806779", "2813029", "2823777", "2837392", "2859099", "286117", "2874945", "2881751", "2888707", "2891041", "2899826", "2907452", "2909273", "2910298", "2940435", "2942930", "2944563", "2967727", "2971652", "2982795", "2988396", "3009975", "3012605", "301596", "3018096", "3020861", "302214", "3035427", "3038803", "3051871", "3058103", "3063190", "30685", "3074414", "3084184", "3085520", "3087098", "3088979", "3093940", "3101600", "3106372", "3118128", "3136749", "3141038", "3141805", "3149249", "3152379", "3158639", "3214686", "322430", "3234458", "3241625", "3244893", "3247113", "3262259", "3266252", "3277540", "3282432", "329573", "330495", "3307192", "3327340", "3330789", "3342740", "3342983", "3345019", "334726", "3348584", "3348884", "335751", "3359857", "3360208", "336216", "3374965", "337827", "3379229", "3379486", "3404630", "3409944", "3414774", "3419804", "3423910", "342540", "3430840", "3431550", "3440320", "3449504", "3456009", "3473145", "3477865", "3484453", "3486848", "3500715", "3510330", "3514992", "3515942", "3519568", "3520976", "3522781", "3534019", "3553701", "3569451", "3582618", "3586315", "3590883", "3594028", "3596346", "359651", "3600847", "3617003", "3631740", "3641793", "3669312", "3671876", "367284", "3678439", "3678851", "3684024", "3705276", "3706748", "3712107", "3717986", "3724404", "3758927", "3763985", "3781371", "3788904", "3794175", "3808497", "3820364", "3843766", "3844715", "3850509", "3853878", "3873126", "3876243", "3884365", "3895484", "3910926", "39165", "3930124", "3941010", "394264", "3980584", "3981999", "3983381", "3990939", "3993448", "4043291", "4068919", "4069160", "4069660", "4071734", "4074180", "4077063", "4079044", "4095318", "4100633", "4109190", "4110709", "411172", "4125809", "4125848", "4127309", "4139124", "4153702", "4159559", "4162848", "4162862", "4168293", "4183520", "4192820", "4193101", "4195947", "4196457", "4197916", "4198579", "4200749", "4202962", "4203962", "4206569", "4220642", "4223201", "4228776", "4236598", "4263112", "4263215", "4264849", "4273962", "4280347", "428424", "429430", "4306357", "4310790", "4314120", "4317219", "4326634", "4346004", "4358605", "4360869", "4374835", "437861", "437973", "4390325", "4393915", "4396616", "4397236", "4402935", "4404814", "4408441", "4418813", "4427196", "4429495", "4437396", "4459722", "4460316", "4466589", "4473129", "4476091", "4477158", "4481316", "4500145", "4518758", "4522100", "4527866", "4552640", "4553145", "4555476", "4556417", "4559103", "4568095", "4580921", "4586988", "4603365", "4603802", "4604559", "4605378", "460890", "4610550", "4616719", "4617748", "4618264", "4620779", "4648981", "4654378", "4657203", "4657525", "465758", "4668120", "4668155", "4668893", "4679009", "4682534", "4726997", "4737398", "47515", "4756766", "4765254", "4774538", "4777177", "4791609", "4804570", "4808272", "4813652", "482348", "48502", "4860882", "4868526", "4872492", "4884033", "4886584", "4889211", "4901796", "49131", "4920105", "4925418", "4925730", "4933702", "4937427", "4951252", "4954302", "4955724", "497542", "4980158", "4984978", "4985683", "4993843", "4999159", "5002578", "5009147", "5016266", "5017679", "5028505", "5034885", "5042128", "5051034", "5068629", "507041", "5074081", "5098458", "5111241", "5119429", "5119848", "5123250", "5124287", "5124851", "5126100", "5129642", "514200", "5150512", "5150861", "5160018", "5166697", "5169626", "5176269", "517680", "5178031", "5182443", "5191563", "5194790", "5198253", "5206331", "5209203", "5209509", "5216531", "5225034", "5228195", "5228437", "5236233", "5249707", "5252173", "5253093", "5254735", "52933", "5297874", "530147", "533354", "5339331", "534289", "5343206", "5343355", "5359654", "5368553", "536998", "5370802", "5392205", "5402909", "5403664", "5425003", "5441699", "5443319", "5449397", "5449479", "5465013", "546652", "5485670", "5485680", "5487032", "5501189", "5508395", "5513277", "5513283", "5531975", "5539511", "5539780", "5555361", "5567813", "5575261", "5578470", "5585751", "5604036", "5604670", "5609222", "5613561", "561676", "5618", "5628607", "5630917", "5639742", "5649582", "5652013", "5657026", "5661498", "5663589", "5668352", "5678952", "5679334", "5683923", "5701562", "5701885", "5705424", "5707431", "5718812", "5731809", "5733066", "5746657", "5751313", "5753046", "5753663", "5761477", "5764262", "5768778", "5774249", "5792465", "5794247", "5800017", "5800588", "5808477", "5819052", "5825292", "5830890", "584021", "5844527", "5844897", "5846320", "5853444", "5858373", "588946", "589101", "5896500", "5897155", "5908696", "5914518", "5917552", "5939795", "5963303", "5970797", "5977", "5979720", "598337", "5988407", "6003706", "6006156", "6008865", "6011868", "6011898", "6014032", "6044975", "6048137", "6063948", "6066505", "6067397", "6078963", "6087751", "6089111", "6092567", "6098490", "610414", "6106675", "6110599", "6125807", "6133578", "6135473", "6137704", "614845", "6148524", "6150088", "6150569", "6155066", "6158396", "6167634", "6172816", "6173377", "6174681", "6210428", "621783", "6218847", "6222392", "6223240", "6227030", "6231701", "6232455", "6236336", "624369", "6250803", "6251248", "6252067", "62580727799101", "6280509", "6288233", "6291240", "6308963", "6310734", "6322726", "6331824", "6339986", "6350505", "6375804", "6387390", "6391041", "6391670", "6404212", "6406597", "6437718", "644117", "6447609", "6448938", "6458240", "6472262", "6476851", "6481230", "6487377", "6496191", "6502025", "6503135", "6508205", "6511463", "6518241", "652508", "6525151", "6549805", "6563808", "6566525", "6571264", "6572275", "6585418", "658999", "6599679", "6602530", "6604689", "6624935", "6644718", "6650513", "6657674", "6664938", "6674031", "6685757", "6690088", "6690325", "6696040", "6696481", "671208", "671617", "6718613", "6724989", "6725232", "674331", "6751916", "677305", "6779662", "6787937", "6792710", "6798665", "6801359", "681359", "6819582", "6826884", "6838014", "6839431", "6842461", "6844074", "6848661", "6867853", "687263", "6880049", "6890353", "6895429", "6896333", "6896471", "6904075", "6905382", "690602", "6919766", "6923418", "692385", "6926485", "6936707", "6967960", "696820", "6976330", "6979951", "6985001", "6989374", "6992192", "6994667", "7002749", "7010659", "7014767", "7020456", "7020750", "7024666", "7031997", "7035507", "7036378", "7039403", "7042929", "7051525", "7063832", "7070819", "7076136", "7078163", "7080317", "7086492", "7087510", "7092891", "714186", "7142823", "7143083", "7155938", "7169024", "7170189", "7192773", "7217280", "7217769", "7222749", "7245943", "7259953", "7264708", "727106", "7272572", "7282510", "7285509", "7287631", "7289824", "7292785", "7311901", "7322786", "7328138", "7336156", "7337144", "7340325", "7348607", "7356347", "7356509", "7362635", "737153", "7379540", "7393999", "7404764", "7410779", "7412189", "7415880", "7423269", "7424442", "7427283", "7430670", "7441289", "7442502", "7442966", "7445996", "7447433", "7463826", "7466369", "7470925", "7471026", "7494478", "7503940", "750557", "7507039", "7507872", "7530978", "7531063", "7537257", "7556284", "7569111", "7571030", "7571455", "7580975", "758189", "7582396", "7591633", "7592405", "7593930", "7605119", "7634674", "7636521", "7639867", "7651922", "7658293", "7665768", "7668299", "7669553", "7676940", "7683189", "7701912", "7712369", "7718545", "772424", "7728790", "7734644", "7738945", "7742279", "7751659", "7765780", "7773525", "7774456", "7776503", "7806322", "7807956", "7808610", "7818482", "7825202", "7833473", "7834222", "7835211", "7835388", "7836420", "7843549", "7854533", "7855895", "7855955", "7857409", "7860415", "788233", "7887800", "7898159", "7906521", "7910018", "7917233", "7917366", "791816", "792064", "7925660", "7925869", "7935899", "7936874", "7944984", "7949026", "797241", "7977385", "7981197", "7988092", "7995227", "8003900", "8013188", "8017962", "8026681", "8033951", "8061229", "8073440", "8079547", "8080986", "8097838", "8100308", "8101002", "8105480", "8113309", "8125217", "8130156", "8133206", "8153835", "8154545", "8156351", "8156666", "8164626", "8166424", "8169336", "8176000", "8183419", "819048", "820849", "8218781", "8222127", "8223063", "8226389", "8226886", "8236110", "8237506", "8237828", "824466", "8253355", "8257999", "8263642", "8272129", "8279624", "8279625", "8280241", "8282215", "8288816", "830001", "8300784", "8301094", "8308425", "8310953", "8311690", "831502", "8323628", "8331222", "8333077", "8335068", "8336376", "8336844", "8339409", "8340859", "835082", "8358575", "8363371", "8379520", "8383585", "8385209", "8387766", "8395220", "8398739", "840631", "841046", "8417806", "8422362", "8441068", "8465244", "8469814", "8469915", "8469964", "8472621", "8484794", "8493502", "8499383", "8509864", "8527604", "8533922", "8540857", "8546355", "8548925", "8553404", "8560672", "8571533", "8574036", "8575832", "8582540", "8585171", "8587218", "858790", "8588990", "8591774", "861811", "8619614", "8626491", "8628804", "8640730", "8641797", "8650624", "8651394", "865669", "8657457", "866250", "8669402", "8673823", "867794", "867907", "8684834", "8694079", "8695126", "8711251", "871519", "8716244", "8721210", "8727012", "8729320", "8729801", "8736099", "8737227", "8738688", "8745937", "8751896", "8764722", "8765411", "8771925", "8772657", "8780204", "8780903", "8782298", "878464", "8785444", "8786645", "8793386", "8801408", "8809582", "8822455", "8830604", "8832913", "8834849", "8836496", "8839017", "8842552", "8843623", "8847609", "8853009", "8861328", "8861833", "8868387", "8870529", "8873050", "8874959", "8899260", "8900427", "8908778", "8911219", "8911866", "8927964", "8932464", "8948588", "8955358", "8957839", "8961163", "8965137", "8969930", "8971301", "8980469", "8984372", "899090", "8992509", "8997376", "9005265", "900558", "9009722", "9010893", "902057", "9027183", "9034114", "9034637", "904046", "9041813", "9043174", "9044740", "9048579", "9050021", "9053899", "9058904", "9060696", "9061138", "9067144", "9076700", "9081634", "9084048", "9086431", "9096290", "9097213", "9100133", "9104062", "911567", "9130617", "9134785", "9138051", "9145215", "9161616", "9164452", "9166539", "9184664", "919332", "9193815", "919654", "9198844", "921390", "9213970", "9216695", "9221265", "9230870", "9237205", "9241261", "9248052", "9259570", "92619", "9269797", "9273962", "9274801", "9275870", "9276769", "9278478", "9285693", "928893", "9309055", "9312664", "934835", "9353886", "9355700", "9380144", "9392912", "9401359", "9416758", "9429563", "9431475", "9441744", "9446377", "9447252", "9467149", "9471602", "9484206", "9488378", "9495684", "9521409", "9531766", "9557836", "9561180", "9574548", "958534", "9587631", "9590203", "9592021", "9596498", "9604909", "9626323", "9629709", "9633833", "9637060", "9640263", "9643209", "9673916", "9677996", "9697451", "9698470", "9699354", "970254", "9706203", "9714529", "9716056", "9719701", "9731199", "9736918", "9737206", "9741851", "9742041", "9750478", "9752260", "976157", "9762757", "9766149", "9766514", "979117", "9791309", "9797031", "9808966", "9816356", "981700", "9821050", "9826146", "9826447", "9835701", "9839426", "9850870", "985255", "9854171", "9857234", "9862393", "9865639", "9871156", "9877594", "9883285", "9889486", "9893574", "9894310", "9897728", "9905112", "990744", "9913417", "9917637", "9931248", "9954484", "9955812", "9969534", "9971099", "998045", "9990951"

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions