ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where county = "Broomfield", deaths = 74, fips = 8014 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
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);