Policies without entry_type "new_entry" #19
Description
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 PolicyThe 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"