ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where county = "Gloucester", deaths = 49 and fips = 51073 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1488263 | 1488263 | 2021-07-05 | Gloucester | Virginia | 51073 | 2279 | 49 |
1485016 | 1485016 | 2021-07-04 | Gloucester | Virginia | 51073 | 2279 | 49 |
1481770 | 1481770 | 2021-07-03 | Gloucester | Virginia | 51073 | 2278 | 49 |
1478523 | 1478523 | 2021-07-02 | Gloucester | Virginia | 51073 | 2278 | 49 |
1475277 | 1475277 | 2021-07-01 | Gloucester | Virginia | 51073 | 2278 | 49 |
1472031 | 1472031 | 2021-06-30 | Gloucester | Virginia | 51073 | 2278 | 49 |
1468786 | 1468786 | 2021-06-29 | Gloucester | Virginia | 51073 | 2277 | 49 |
1465541 | 1465541 | 2021-06-28 | Gloucester | Virginia | 51073 | 2277 | 49 |
1462296 | 1462296 | 2021-06-27 | Gloucester | Virginia | 51073 | 2274 | 49 |
1459051 | 1459051 | 2021-06-26 | Gloucester | Virginia | 51073 | 2273 | 49 |
1455806 | 1455806 | 2021-06-25 | Gloucester | Virginia | 51073 | 2273 | 49 |
1452561 | 1452561 | 2021-06-24 | Gloucester | Virginia | 51073 | 2272 | 49 |
1449315 | 1449315 | 2021-06-23 | Gloucester | Virginia | 51073 | 2272 | 49 |
1446070 | 1446070 | 2021-06-22 | Gloucester | Virginia | 51073 | 2270 | 49 |
1442825 | 1442825 | 2021-06-21 | Gloucester | Virginia | 51073 | 2270 | 49 |
1439580 | 1439580 | 2021-06-20 | Gloucester | Virginia | 51073 | 2267 | 49 |
1436333 | 1436333 | 2021-06-19 | Gloucester | Virginia | 51073 | 2267 | 49 |
1433086 | 1433086 | 2021-06-18 | Gloucester | Virginia | 51073 | 2267 | 49 |
1429840 | 1429840 | 2021-06-17 | Gloucester | Virginia | 51073 | 2266 | 49 |
1426595 | 1426595 | 2021-06-16 | Gloucester | Virginia | 51073 | 2266 | 49 |
1423349 | 1423349 | 2021-06-15 | Gloucester | Virginia | 51073 | 2263 | 49 |
1420102 | 1420102 | 2021-06-14 | Gloucester | Virginia | 51073 | 2260 | 49 |
1416857 | 1416857 | 2021-06-13 | Gloucester | Virginia | 51073 | 2260 | 49 |
1413611 | 1413611 | 2021-06-12 | Gloucester | Virginia | 51073 | 2261 | 49 |
1410366 | 1410366 | 2021-06-11 | Gloucester | Virginia | 51073 | 2261 | 49 |
1407121 | 1407121 | 2021-06-10 | Gloucester | Virginia | 51073 | 2260 | 49 |
1403875 | 1403875 | 2021-06-09 | Gloucester | Virginia | 51073 | 2260 | 49 |
1400630 | 1400630 | 2021-06-08 | Gloucester | Virginia | 51073 | 2259 | 49 |
1397385 | 1397385 | 2021-06-07 | Gloucester | Virginia | 51073 | 2256 | 49 |
1394138 | 1394138 | 2021-06-06 | Gloucester | Virginia | 51073 | 2257 | 49 |
1390893 | 1390893 | 2021-06-05 | Gloucester | Virginia | 51073 | 2257 | 49 |
1387648 | 1387648 | 2021-06-04 | Gloucester | Virginia | 51073 | 2253 | 49 |
1384403 | 1384403 | 2021-06-03 | Gloucester | Virginia | 51073 | 2252 | 49 |
1381157 | 1381157 | 2021-06-02 | Gloucester | Virginia | 51073 | 2253 | 49 |
1377912 | 1377912 | 2021-06-01 | Gloucester | Virginia | 51073 | 2249 | 49 |
1374666 | 1374666 | 2021-05-31 | Gloucester | Virginia | 51073 | 2249 | 49 |
1371421 | 1371421 | 2021-05-30 | Gloucester | Virginia | 51073 | 2248 | 49 |
1368175 | 1368175 | 2021-05-29 | Gloucester | Virginia | 51073 | 2247 | 49 |
1364929 | 1364929 | 2021-05-28 | Gloucester | Virginia | 51073 | 2245 | 49 |
1361683 | 1361683 | 2021-05-27 | Gloucester | Virginia | 51073 | 2248 | 49 |
1358437 | 1358437 | 2021-05-26 | Gloucester | Virginia | 51073 | 2248 | 49 |
1355191 | 1355191 | 2021-05-25 | Gloucester | Virginia | 51073 | 2243 | 49 |
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);