ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 8014 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277795 | 1277795 | 2021-05-02 | Broomfield | Colorado | 8014 | 4690 | 75 |
1274548 | 1274548 | 2021-05-01 | Broomfield | Colorado | 8014 | 4687 | 75 |
1271301 | 1271301 | 2021-04-30 | Broomfield | Colorado | 8014 | 4665 | 75 |
1268054 | 1268054 | 2021-04-29 | Broomfield | Colorado | 8014 | 4648 | 75 |
1264807 | 1264807 | 2021-04-28 | Broomfield | Colorado | 8014 | 4628 | 75 |
1261560 | 1261560 | 2021-04-27 | Broomfield | Colorado | 8014 | 4621 | 75 |
1258313 | 1258313 | 2021-04-26 | Broomfield | Colorado | 8014 | 4586 | 75 |
1255066 | 1255066 | 2021-04-25 | Broomfield | Colorado | 8014 | 4586 | 75 |
1251819 | 1251819 | 2021-04-24 | Broomfield | Colorado | 8014 | 4569 | 75 |
1248572 | 1248572 | 2021-04-23 | Broomfield | Colorado | 8014 | 4547 | 75 |
1245325 | 1245325 | 2021-04-22 | Broomfield | Colorado | 8014 | 4528 | 75 |
1242078 | 1242078 | 2021-04-21 | Broomfield | Colorado | 8014 | 4501 | 75 |
1238831 | 1238831 | 2021-04-20 | Broomfield | Colorado | 8014 | 4499 | 75 |
1235584 | 1235584 | 2021-04-19 | Broomfield | Colorado | 8014 | 4469 | 75 |
1232337 | 1232337 | 2021-04-18 | Broomfield | Colorado | 8014 | 4464 | 75 |
1229088 | 1229088 | 2021-04-17 | Broomfield | Colorado | 8014 | 4452 | 75 |
1225840 | 1225840 | 2021-04-16 | Broomfield | Colorado | 8014 | 4439 | 75 |
1222593 | 1222593 | 2021-04-15 | Broomfield | Colorado | 8014 | 4401 | 75 |
1219345 | 1219345 | 2021-04-14 | Broomfield | Colorado | 8014 | 4390 | 75 |
1216097 | 1216097 | 2021-04-13 | Broomfield | Colorado | 8014 | 4376 | 75 |
1212850 | 1212850 | 2021-04-12 | Broomfield | Colorado | 8014 | 4358 | 75 |
1209602 | 1209602 | 2021-04-11 | Broomfield | Colorado | 8014 | 4341 | 75 |
1206353 | 1206353 | 2021-04-10 | Broomfield | Colorado | 8014 | 4335 | 75 |
1203105 | 1203105 | 2021-04-09 | Broomfield | Colorado | 8014 | 4328 | 74 |
1199857 | 1199857 | 2021-04-08 | Broomfield | Colorado | 8014 | 4312 | 74 |
1196608 | 1196608 | 2021-04-07 | Broomfield | Colorado | 8014 | 4275 | 74 |
1193360 | 1193360 | 2021-04-06 | Broomfield | Colorado | 8014 | 4275 | 74 |
1190110 | 1190110 | 2021-04-05 | Broomfield | Colorado | 8014 | 4258 | 74 |
1186863 | 1186863 | 2021-04-04 | Broomfield | Colorado | 8014 | 4246 | 74 |
1183616 | 1183616 | 2021-04-03 | Broomfield | Colorado | 8014 | 4231 | 74 |
1180369 | 1180369 | 2021-04-02 | Broomfield | Colorado | 8014 | 4215 | 74 |
1177122 | 1177122 | 2021-04-01 | Broomfield | Colorado | 8014 | 4203 | 74 |
1173875 | 1173875 | 2021-03-31 | Broomfield | Colorado | 8014 | 4187 | 74 |
1170628 | 1170628 | 2021-03-30 | Broomfield | Colorado | 8014 | 4173 | 74 |
1167380 | 1167380 | 2021-03-29 | Broomfield | Colorado | 8014 | 4161 | 74 |
1164132 | 1164132 | 2021-03-28 | Broomfield | Colorado | 8014 | 4152 | 74 |
1160884 | 1160884 | 2021-03-27 | Broomfield | Colorado | 8014 | 4144 | 74 |
1157636 | 1157636 | 2021-03-26 | Broomfield | Colorado | 8014 | 4124 | 74 |
1154389 | 1154389 | 2021-03-25 | Broomfield | Colorado | 8014 | 4111 | 74 |
1151142 | 1151142 | 2021-03-24 | Broomfield | Colorado | 8014 | 4095 | 74 |
1147895 | 1147895 | 2021-03-23 | Broomfield | Colorado | 8014 | 4082 | 74 |
1144648 | 1144648 | 2021-03-22 | Broomfield | Colorado | 8014 | 4069 | 74 |
1141401 | 1141401 | 2021-03-21 | Broomfield | Colorado | 8014 | 4064 | 74 |
1138155 | 1138155 | 2021-03-20 | Broomfield | Colorado | 8014 | 4052 | 74 |
1134909 | 1134909 | 2021-03-19 | Broomfield | Colorado | 8014 | 4036 | 74 |
1131662 | 1131662 | 2021-03-18 | Broomfield | Colorado | 8014 | 4017 | 74 |
1128414 | 1128414 | 2021-03-17 | Broomfield | Colorado | 8014 | 3986 | 74 |
1125168 | 1125168 | 2021-03-16 | Broomfield | Colorado | 8014 | 3981 | 74 |
1121922 | 1121922 | 2021-03-15 | Broomfield | Colorado | 8014 | 3982 | 74 |
1118675 | 1118675 | 2021-03-14 | Broomfield | Colorado | 8014 | 3978 | 74 |
1115428 | 1115428 | 2021-03-13 | Broomfield | Colorado | 8014 | 3960 | 74 |
1112182 | 1112182 | 2021-03-12 | Broomfield | Colorado | 8014 | 3941 | 74 |
1108936 | 1108936 | 2021-03-11 | Broomfield | Colorado | 8014 | 3921 | 74 |
1105690 | 1105690 | 2021-03-10 | Broomfield | Colorado | 8014 | 3910 | 74 |
1102444 | 1102444 | 2021-03-09 | Broomfield | Colorado | 8014 | 3903 | 74 |
1099198 | 1099198 | 2021-03-08 | Broomfield | Colorado | 8014 | 3879 | 74 |
1095950 | 1095950 | 2021-03-07 | Broomfield | Colorado | 8014 | 3852 | 74 |
1092704 | 1092704 | 2021-03-06 | Broomfield | Colorado | 8014 | 3852 | 74 |
1089458 | 1089458 | 2021-03-05 | Broomfield | Colorado | 8014 | 3839 | 74 |
1086213 | 1086213 | 2021-03-04 | Broomfield | Colorado | 8014 | 3811 | 74 |
1082967 | 1082967 | 2021-03-03 | Broomfield | Colorado | 8014 | 3789 | 74 |
1079721 | 1079721 | 2021-03-02 | Broomfield | Colorado | 8014 | 3772 | 74 |
1076476 | 1076476 | 2021-03-01 | Broomfield | Colorado | 8014 | 3759 | 74 |
1073230 | 1073230 | 2021-02-28 | Broomfield | Colorado | 8014 | 3737 | 74 |
1069984 | 1069984 | 2021-02-27 | Broomfield | Colorado | 8014 | 3721 | 74 |
1066739 | 1066739 | 2021-02-26 | Broomfield | Colorado | 8014 | 3693 | 74 |
1063494 | 1063494 | 2021-02-25 | Broomfield | Colorado | 8014 | 3693 | 74 |
1060249 | 1060249 | 2021-02-24 | Broomfield | Colorado | 8014 | 3682 | 74 |
1057003 | 1057003 | 2021-02-23 | Broomfield | Colorado | 8014 | 3669 | 74 |
1053757 | 1053757 | 2021-02-22 | Broomfield | Colorado | 8014 | 3665 | 74 |
1050510 | 1050510 | 2021-02-21 | Broomfield | Colorado | 8014 | 3654 | 74 |
1047263 | 1047263 | 2021-02-20 | Broomfield | Colorado | 8014 | 3646 | 74 |
1044018 | 1044018 | 2021-02-19 | Broomfield | Colorado | 8014 | 3636 | 74 |
1040773 | 1040773 | 2021-02-18 | Broomfield | Colorado | 8014 | 3623 | 73 |
1037528 | 1037528 | 2021-02-17 | Broomfield | Colorado | 8014 | 3612 | 73 |
1034283 | 1034283 | 2021-02-16 | Broomfield | Colorado | 8014 | 3599 | 73 |
1031037 | 1031037 | 2021-02-15 | Broomfield | Colorado | 8014 | 3598 | 73 |
1027790 | 1027790 | 2021-02-14 | Broomfield | Colorado | 8014 | 3596 | 73 |
1024545 | 1024545 | 2021-02-13 | Broomfield | Colorado | 8014 | 3587 | 73 |
1021300 | 1021300 | 2021-02-12 | Broomfield | Colorado | 8014 | 3580 | 73 |
1018055 | 1018055 | 2021-02-11 | Broomfield | Colorado | 8014 | 3566 | 73 |
1014810 | 1014810 | 2021-02-10 | Broomfield | Colorado | 8014 | 3554 | 72 |
1011565 | 1011565 | 2021-02-09 | Broomfield | Colorado | 8014 | 3553 | 72 |
1008319 | 1008319 | 2021-02-08 | Broomfield | Colorado | 8014 | 3539 | 72 |
1005073 | 1005073 | 2021-02-07 | Broomfield | Colorado | 8014 | 3533 | 72 |
1001827 | 1001827 | 2021-02-06 | Broomfield | Colorado | 8014 | 3514 | 72 |
998581 | 998581 | 2021-02-05 | Broomfield | Colorado | 8014 | 3497 | 72 |
995335 | 995335 | 2021-02-04 | Broomfield | Colorado | 8014 | 3466 | 71 |
992089 | 992089 | 2021-02-03 | Broomfield | Colorado | 8014 | 3446 | 71 |
988843 | 988843 | 2021-02-02 | Broomfield | Colorado | 8014 | 3435 | 70 |
985596 | 985596 | 2021-02-01 | Broomfield | Colorado | 8014 | 3426 | 70 |
982349 | 982349 | 2021-01-31 | Broomfield | Colorado | 8014 | 3391 | 69 |
979103 | 979103 | 2021-01-30 | Broomfield | Colorado | 8014 | 3391 | 69 |
975858 | 975858 | 2021-01-29 | Broomfield | Colorado | 8014 | 3391 | 69 |
972613 | 972613 | 2021-01-28 | Broomfield | Colorado | 8014 | 3373 | 69 |
969368 | 969368 | 2021-01-27 | Broomfield | Colorado | 8014 | 3353 | 69 |
966124 | 966124 | 2021-01-26 | Broomfield | Colorado | 8014 | 3332 | 69 |
962879 | 962879 | 2021-01-25 | Broomfield | Colorado | 8014 | 3313 | 69 |
959634 | 959634 | 2021-01-24 | Broomfield | Colorado | 8014 | 3313 | 69 |
956388 | 956388 | 2021-01-23 | Broomfield | Colorado | 8014 | 3290 | 69 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);