ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where county = "Fulton" and deaths = 48 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Fulton · 36 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1693886 | 1693886 | 2021-09-07 | Fulton | Indiana | 18049 | 2503 | 48 |
1690637 | 1690637 | 2021-09-06 | Fulton | Indiana | 18049 | 2445 | 48 |
1687387 | 1687387 | 2021-09-05 | Fulton | Indiana | 18049 | 2445 | 48 |
1684137 | 1684137 | 2021-09-04 | Fulton | Indiana | 18049 | 2445 | 48 |
1680886 | 1680886 | 2021-09-03 | Fulton | Indiana | 18049 | 2445 | 48 |
1677638 | 1677638 | 2021-09-02 | Fulton | Indiana | 18049 | 2415 | 48 |
1674391 | 1674391 | 2021-09-01 | Fulton | Indiana | 18049 | 2389 | 48 |
1671142 | 1671142 | 2021-08-31 | Fulton | Indiana | 18049 | 2373 | 48 |
1667895 | 1667895 | 2021-08-30 | Fulton | Indiana | 18049 | 2359 | 48 |
1664648 | 1664648 | 2021-08-29 | Fulton | Indiana | 18049 | 2318 | 48 |
1661400 | 1661400 | 2021-08-28 | Fulton | Indiana | 18049 | 2318 | 48 |
1658152 | 1658152 | 2021-08-27 | Fulton | Indiana | 18049 | 2318 | 48 |
1654904 | 1654904 | 2021-08-26 | Fulton | Indiana | 18049 | 2302 | 48 |
1651657 | 1651657 | 2021-08-25 | Fulton | Indiana | 18049 | 2293 | 48 |
1648408 | 1648408 | 2021-08-24 | Fulton | Indiana | 18049 | 2273 | 48 |
1645160 | 1645160 | 2021-08-23 | Fulton | Indiana | 18049 | 2269 | 48 |
1569848 | 1569848 | 2021-07-31 | Fulton | Arkansas | 5049 | 1337 | 48 |
1566600 | 1566600 | 2021-07-30 | Fulton | Arkansas | 5049 | 1336 | 48 |
1563352 | 1563352 | 2021-07-29 | Fulton | Arkansas | 5049 | 1332 | 48 |
1560104 | 1560104 | 2021-07-28 | Fulton | Arkansas | 5049 | 1314 | 48 |
1556857 | 1556857 | 2021-07-27 | Fulton | Arkansas | 5049 | 1306 | 48 |
1553610 | 1553610 | 2021-07-26 | Fulton | Arkansas | 5049 | 1301 | 48 |
1550363 | 1550363 | 2021-07-25 | Fulton | Arkansas | 5049 | 1299 | 48 |
1547116 | 1547116 | 2021-07-24 | Fulton | Arkansas | 5049 | 1293 | 48 |
1543869 | 1543869 | 2021-07-23 | Fulton | Arkansas | 5049 | 1283 | 48 |
1540621 | 1540621 | 2021-07-22 | Fulton | Arkansas | 5049 | 1269 | 48 |
1537374 | 1537374 | 2021-07-21 | Fulton | Arkansas | 5049 | 1260 | 48 |
1016643 | 1016643 | 2021-02-10 | Fulton | Ohio | 39051 | 3640 | 48 |
1013398 | 1013398 | 2021-02-09 | Fulton | Ohio | 39051 | 3622 | 48 |
1010153 | 1010153 | 2021-02-08 | Fulton | Ohio | 39051 | 3604 | 48 |
1006907 | 1006907 | 2021-02-07 | Fulton | Ohio | 39051 | 3597 | 48 |
1003661 | 1003661 | 2021-02-06 | Fulton | Ohio | 39051 | 3589 | 48 |
938525 | 938525 | 2021-01-17 | Fulton | New York | 36035 | 2039 | 48 |
930802 | 930802 | 2021-01-15 | Fulton | Illinois | 17057 | 2530 | 48 |
927557 | 927557 | 2021-01-14 | Fulton | Illinois | 17057 | 2512 | 48 |
43609 | 43609 | 2020-04-09 | Fulton | Georgia | 13121 | 1336 | 48 |
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);