ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where county = "Fulton" and deaths = 18 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Fulton · 67 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1928132 | 1928132 | 2021-11-18 | Fulton | Kentucky | 21075 | 798 | 18 |
1675954 | 1675954 | 2021-09-01 | Fulton | Pennsylvania | 42057 | 1513 | 18 |
1672707 | 1672707 | 2021-08-31 | Fulton | Pennsylvania | 42057 | 1498 | 18 |
1669459 | 1669459 | 2021-08-30 | Fulton | Pennsylvania | 42057 | 1478 | 18 |
1666212 | 1666212 | 2021-08-29 | Fulton | Pennsylvania | 42057 | 1472 | 18 |
1662964 | 1662964 | 2021-08-28 | Fulton | Pennsylvania | 42057 | 1467 | 18 |
1659716 | 1659716 | 2021-08-27 | Fulton | Pennsylvania | 42057 | 1460 | 18 |
1656467 | 1656467 | 2021-08-26 | Fulton | Pennsylvania | 42057 | 1454 | 18 |
836196 | 836196 | 2020-12-17 | Fulton | Arkansas | 5049 | 715 | 18 |
832950 | 832950 | 2020-12-16 | Fulton | Arkansas | 5049 | 683 | 18 |
829703 | 829703 | 2020-12-15 | Fulton | Arkansas | 5049 | 658 | 18 |
826457 | 826457 | 2020-12-14 | Fulton | Arkansas | 5049 | 639 | 18 |
765388 | 765388 | 2020-11-25 | Fulton | Indiana | 18049 | 847 | 18 |
762143 | 762143 | 2020-11-24 | Fulton | Indiana | 18049 | 837 | 18 |
734289 | 734289 | 2020-11-15 | Fulton | Ohio | 39051 | 976 | 18 |
731043 | 731043 | 2020-11-14 | Fulton | Ohio | 39051 | 949 | 18 |
727799 | 727799 | 2020-11-13 | Fulton | Ohio | 39051 | 919 | 18 |
724555 | 724555 | 2020-11-12 | Fulton | Ohio | 39051 | 875 | 18 |
721312 | 721312 | 2020-11-11 | Fulton | Ohio | 39051 | 868 | 18 |
718069 | 718069 | 2020-11-10 | Fulton | Ohio | 39051 | 841 | 18 |
714826 | 714826 | 2020-11-09 | Fulton | Ohio | 39051 | 803 | 18 |
711582 | 711582 | 2020-11-08 | Fulton | Ohio | 39051 | 776 | 18 |
708338 | 708338 | 2020-11-07 | Fulton | Ohio | 39051 | 762 | 18 |
705095 | 705095 | 2020-11-06 | Fulton | Ohio | 39051 | 744 | 18 |
701852 | 701852 | 2020-11-05 | Fulton | Ohio | 39051 | 732 | 18 |
698608 | 698608 | 2020-11-04 | Fulton | Ohio | 39051 | 708 | 18 |
695365 | 695365 | 2020-11-03 | Fulton | Ohio | 39051 | 691 | 18 |
355662 | 355662 | 2020-07-21 | Fulton | New York | 36035 | 267 | 18 |
352459 | 352459 | 2020-07-20 | Fulton | New York | 36035 | 267 | 18 |
349256 | 349256 | 2020-07-19 | Fulton | New York | 36035 | 267 | 18 |
346055 | 346055 | 2020-07-18 | Fulton | New York | 36035 | 266 | 18 |
342856 | 342856 | 2020-07-17 | Fulton | New York | 36035 | 266 | 18 |
339658 | 339658 | 2020-07-16 | Fulton | New York | 36035 | 266 | 18 |
336462 | 336462 | 2020-07-15 | Fulton | New York | 36035 | 266 | 18 |
333268 | 333268 | 2020-07-14 | Fulton | New York | 36035 | 266 | 18 |
330078 | 330078 | 2020-07-13 | Fulton | New York | 36035 | 265 | 18 |
326891 | 326891 | 2020-07-12 | Fulton | New York | 36035 | 265 | 18 |
323707 | 323707 | 2020-07-11 | Fulton | New York | 36035 | 265 | 18 |
320527 | 320527 | 2020-07-10 | Fulton | New York | 36035 | 264 | 18 |
317350 | 317350 | 2020-07-09 | Fulton | New York | 36035 | 263 | 18 |
314176 | 314176 | 2020-07-08 | Fulton | New York | 36035 | 262 | 18 |
311005 | 311005 | 2020-07-07 | Fulton | New York | 36035 | 262 | 18 |
307837 | 307837 | 2020-07-06 | Fulton | New York | 36035 | 262 | 18 |
304670 | 304670 | 2020-07-05 | Fulton | New York | 36035 | 261 | 18 |
301507 | 301507 | 2020-07-04 | Fulton | New York | 36035 | 261 | 18 |
298344 | 298344 | 2020-07-03 | Fulton | New York | 36035 | 261 | 18 |
295184 | 295184 | 2020-07-02 | Fulton | New York | 36035 | 260 | 18 |
292029 | 292029 | 2020-07-01 | Fulton | New York | 36035 | 257 | 18 |
288877 | 288877 | 2020-06-30 | Fulton | New York | 36035 | 256 | 18 |
285727 | 285727 | 2020-06-29 | Fulton | New York | 36035 | 256 | 18 |
282582 | 282582 | 2020-06-28 | Fulton | New York | 36035 | 255 | 18 |
279436 | 279436 | 2020-06-27 | Fulton | New York | 36035 | 249 | 18 |
276288 | 276288 | 2020-06-26 | Fulton | New York | 36035 | 248 | 18 |
273142 | 273142 | 2020-06-25 | Fulton | New York | 36035 | 244 | 18 |
270003 | 270003 | 2020-06-24 | Fulton | New York | 36035 | 244 | 18 |
266869 | 266869 | 2020-06-23 | Fulton | New York | 36035 | 244 | 18 |
263741 | 263741 | 2020-06-22 | Fulton | New York | 36035 | 244 | 18 |
260613 | 260613 | 2020-06-21 | Fulton | New York | 36035 | 243 | 18 |
257486 | 257486 | 2020-06-20 | Fulton | New York | 36035 | 243 | 18 |
254363 | 254363 | 2020-06-19 | Fulton | New York | 36035 | 237 | 18 |
251248 | 251248 | 2020-06-18 | Fulton | New York | 36035 | 236 | 18 |
248133 | 248133 | 2020-06-17 | Fulton | New York | 36035 | 236 | 18 |
245020 | 245020 | 2020-06-16 | Fulton | New York | 36035 | 236 | 18 |
241908 | 241908 | 2020-06-15 | Fulton | New York | 36035 | 235 | 18 |
238799 | 238799 | 2020-06-14 | Fulton | New York | 36035 | 234 | 18 |
235691 | 235691 | 2020-06-13 | Fulton | New York | 36035 | 232 | 18 |
22085 | 22085 | 2020-03-31 | Fulton | Georgia | 13121 | 599 | 18 |
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);