Open ingonader opened 4 years ago
In the dataset downloaded on 29 Jun 2020, there are 1282 policies that are missing one ore more "new_entry" entry_type.
"new_entry"
entry_type
A quick summary shows that most (but not all) of these have only one record per type / type_sub_cat:
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:
record_id
"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"
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:The
record_ids of these are: