ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where county = "Jasper" and deaths = 70 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2369804 | 2369804 | 2022-04-03 | Jasper | Georgia | 13159 | 3127 | 70 |
2366551 | 2366551 | 2022-04-02 | Jasper | Georgia | 13159 | 3127 | 70 |
2363298 | 2363298 | 2022-04-01 | Jasper | Georgia | 13159 | 3127 | 70 |
2360044 | 2360044 | 2022-03-31 | Jasper | Georgia | 13159 | 3127 | 70 |
2356790 | 2356790 | 2022-03-30 | Jasper | Georgia | 13159 | 3125 | 70 |
2353537 | 2353537 | 2022-03-29 | Jasper | Georgia | 13159 | 3121 | 70 |
2350285 | 2350285 | 2022-03-28 | Jasper | Georgia | 13159 | 3120 | 70 |
2347032 | 2347032 | 2022-03-27 | Jasper | Georgia | 13159 | 3120 | 70 |
2343779 | 2343779 | 2022-03-26 | Jasper | Georgia | 13159 | 3120 | 70 |
2340526 | 2340526 | 2022-03-25 | Jasper | Georgia | 13159 | 3120 | 70 |
2240684 | 2240684 | 2022-02-22 | Jasper | Mississippi | 28061 | 4762 | 70 |
2237433 | 2237433 | 2022-02-21 | Jasper | Mississippi | 28061 | 4750 | 70 |
2234182 | 2234182 | 2022-02-20 | Jasper | Mississippi | 28061 | 4750 | 70 |
2230931 | 2230931 | 2022-02-19 | Jasper | Mississippi | 28061 | 4750 | 70 |
2227680 | 2227680 | 2022-02-18 | Jasper | Mississippi | 28061 | 4750 | 70 |
2224429 | 2224429 | 2022-02-17 | Jasper | Mississippi | 28061 | 4745 | 70 |
2221178 | 2221178 | 2022-02-16 | Jasper | Mississippi | 28061 | 4744 | 70 |
2217927 | 2217927 | 2022-02-15 | Jasper | Mississippi | 28061 | 4733 | 70 |
2214676 | 2214676 | 2022-02-14 | Jasper | Mississippi | 28061 | 4731 | 70 |
1288128 | 1288128 | 2021-05-05 | Jasper | Iowa | 19099 | 4130 | 70 |
1284882 | 1284882 | 2021-05-04 | Jasper | Iowa | 19099 | 4127 | 70 |
1281635 | 1281635 | 2021-05-03 | Jasper | Iowa | 19099 | 4122 | 70 |
1278388 | 1278388 | 2021-05-02 | Jasper | Iowa | 19099 | 4121 | 70 |
1275141 | 1275141 | 2021-05-01 | Jasper | Iowa | 19099 | 4120 | 70 |
1271894 | 1271894 | 2021-04-30 | Jasper | Iowa | 19099 | 4119 | 70 |
1268647 | 1268647 | 2021-04-29 | Jasper | Iowa | 19099 | 4119 | 70 |
1265400 | 1265400 | 2021-04-28 | Jasper | Iowa | 19099 | 4114 | 70 |
1262153 | 1262153 | 2021-04-27 | Jasper | Iowa | 19099 | 4103 | 70 |
1258906 | 1258906 | 2021-04-26 | Jasper | Iowa | 19099 | 4103 | 70 |
1255659 | 1255659 | 2021-04-25 | Jasper | Iowa | 19099 | 4101 | 70 |
1252412 | 1252412 | 2021-04-24 | Jasper | Iowa | 19099 | 4099 | 70 |
1249165 | 1249165 | 2021-04-23 | Jasper | Iowa | 19099 | 4090 | 70 |
1245918 | 1245918 | 2021-04-22 | Jasper | Iowa | 19099 | 4086 | 70 |
1242671 | 1242671 | 2021-04-21 | Jasper | Iowa | 19099 | 4083 | 70 |
1239424 | 1239424 | 2021-04-20 | Jasper | Iowa | 19099 | 4078 | 70 |
1236177 | 1236177 | 2021-04-19 | Jasper | Iowa | 19099 | 4078 | 70 |
1232930 | 1232930 | 2021-04-18 | Jasper | Iowa | 19099 | 4076 | 70 |
1229681 | 1229681 | 2021-04-17 | Jasper | Iowa | 19099 | 4076 | 70 |
1226433 | 1226433 | 2021-04-16 | Jasper | Iowa | 19099 | 4076 | 70 |
1223186 | 1223186 | 2021-04-15 | Jasper | Iowa | 19099 | 4075 | 70 |
1219938 | 1219938 | 2021-04-14 | Jasper | Iowa | 19099 | 4073 | 70 |
1216690 | 1216690 | 2021-04-13 | Jasper | Iowa | 19099 | 4069 | 70 |
1213443 | 1213443 | 2021-04-12 | Jasper | Iowa | 19099 | 4066 | 70 |
1210195 | 1210195 | 2021-04-11 | Jasper | Iowa | 19099 | 4063 | 70 |
1206946 | 1206946 | 2021-04-10 | Jasper | Iowa | 19099 | 4062 | 70 |
1203698 | 1203698 | 2021-04-09 | Jasper | Iowa | 19099 | 4060 | 70 |
1200450 | 1200450 | 2021-04-08 | Jasper | Iowa | 19099 | 4057 | 70 |
1056248 | 1056248 | 2021-02-22 | Jasper | Texas | 48241 | 2264 | 70 |
1053002 | 1053002 | 2021-02-21 | Jasper | Texas | 48241 | 2264 | 70 |
1049755 | 1049755 | 2021-02-20 | Jasper | Texas | 48241 | 2264 | 70 |
1046508 | 1046508 | 2021-02-19 | Jasper | Texas | 48241 | 2268 | 70 |
795412 | 795412 | 2020-12-04 | Jasper | Missouri | 29097 | 5162 | 70 |
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);