ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,547 rows where county = "Jones" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 6
- Mississippi 786
- Georgia 780
- Iowa 775
- Texas 766
- North Carolina 765
- South Dakota 675
county 1
- Jones · 4,547 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
4790 | 4790 | 2020-03-19 | Jones | Mississippi | 28067 | 1 | 0 |
5615 | 5615 | 2020-03-20 | Jones | Mississippi | 28067 | 1 | 0 |
6594 | 6594 | 2020-03-21 | Jones | Mississippi | 28067 | 1 | 0 |
7677 | 7677 | 2020-03-22 | Jones | Mississippi | 28067 | 1 | 0 |
8857 | 8857 | 2020-03-23 | Jones | Mississippi | 28067 | 1 | 0 |
10153 | 10153 | 2020-03-24 | Jones | Mississippi | 28067 | 1 | 0 |
11124 | 11124 | 2020-03-25 | Jones | Georgia | 13169 | 1 | 0 |
11573 | 11573 | 2020-03-25 | Jones | Mississippi | 28067 | 1 | 0 |
12675 | 12675 | 2020-03-26 | Jones | Georgia | 13169 | 1 | 0 |
13165 | 13165 | 2020-03-26 | Jones | Mississippi | 28067 | 1 | 0 |
14882 | 14882 | 2020-03-27 | Jones | Mississippi | 28067 | 1 | 0 |
20275 | 20275 | 2020-03-30 | Jones | Iowa | 19105 | 1 | 0 |
42799 | 42799 | 2020-04-08 | Jones | Texas | 48253 | 1 | 0 |
45389 | 45389 | 2020-04-09 | Jones | Texas | 48253 | 1 | 0 |
314803 | 314803 | 2020-07-08 | Jones | South Dakota | 46075 | 1 | 0 |
317976 | 317976 | 2020-07-09 | Jones | South Dakota | 46075 | 1 | 0 |
321154 | 321154 | 2020-07-10 | Jones | South Dakota | 46075 | 1 | 0 |
324334 | 324334 | 2020-07-11 | Jones | South Dakota | 46075 | 1 | 0 |
327519 | 327519 | 2020-07-12 | Jones | South Dakota | 46075 | 1 | 0 |
330705 | 330705 | 2020-07-13 | Jones | South Dakota | 46075 | 1 | 0 |
333897 | 333897 | 2020-07-14 | Jones | South Dakota | 46075 | 1 | 0 |
337091 | 337091 | 2020-07-15 | Jones | South Dakota | 46075 | 1 | 0 |
340288 | 340288 | 2020-07-16 | Jones | South Dakota | 46075 | 1 | 0 |
343486 | 343486 | 2020-07-17 | Jones | South Dakota | 46075 | 1 | 0 |
346686 | 346686 | 2020-07-18 | Jones | South Dakota | 46075 | 1 | 0 |
349886 | 349886 | 2020-07-19 | Jones | South Dakota | 46075 | 1 | 0 |
353089 | 353089 | 2020-07-20 | Jones | South Dakota | 46075 | 1 | 0 |
356292 | 356292 | 2020-07-21 | Jones | South Dakota | 46075 | 1 | 0 |
359496 | 359496 | 2020-07-22 | Jones | South Dakota | 46075 | 1 | 0 |
362702 | 362702 | 2020-07-23 | Jones | South Dakota | 46075 | 1 | 0 |
365908 | 365908 | 2020-07-24 | Jones | South Dakota | 46075 | 1 | 0 |
369117 | 369117 | 2020-07-25 | Jones | South Dakota | 46075 | 1 | 0 |
372329 | 372329 | 2020-07-26 | Jones | South Dakota | 46075 | 1 | 0 |
375542 | 375542 | 2020-07-27 | Jones | South Dakota | 46075 | 1 | 0 |
378758 | 378758 | 2020-07-28 | Jones | South Dakota | 46075 | 1 | 0 |
381975 | 381975 | 2020-07-29 | Jones | South Dakota | 46075 | 1 | 0 |
385193 | 385193 | 2020-07-30 | Jones | South Dakota | 46075 | 1 | 0 |
14349 | 14349 | 2020-03-27 | Jones | Georgia | 13169 | 2 | 0 |
16136 | 16136 | 2020-03-28 | Jones | Georgia | 13169 | 2 | 0 |
18033 | 18033 | 2020-03-29 | Jones | Georgia | 13169 | 2 | 0 |
20025 | 20025 | 2020-03-30 | Jones | Georgia | 13169 | 2 | 0 |
48010 | 48010 | 2020-04-10 | Jones | Texas | 48253 | 2 | 0 |
50668 | 50668 | 2020-04-11 | Jones | Texas | 48253 | 2 | 0 |
53343 | 53343 | 2020-04-12 | Jones | Texas | 48253 | 2 | 0 |
56031 | 56031 | 2020-04-13 | Jones | Texas | 48253 | 2 | 0 |
58736 | 58736 | 2020-04-14 | Jones | Texas | 48253 | 2 | 0 |
61454 | 61454 | 2020-04-15 | Jones | Texas | 48253 | 2 | 0 |
388410 | 388410 | 2020-07-31 | Jones | South Dakota | 46075 | 2 | 0 |
391627 | 391627 | 2020-08-01 | Jones | South Dakota | 46075 | 2 | 0 |
394843 | 394843 | 2020-08-02 | Jones | South Dakota | 46075 | 2 | 0 |
398060 | 398060 | 2020-08-03 | Jones | South Dakota | 46075 | 2 | 0 |
401275 | 401275 | 2020-08-04 | Jones | South Dakota | 46075 | 2 | 0 |
404493 | 404493 | 2020-08-05 | Jones | South Dakota | 46075 | 2 | 0 |
407713 | 407713 | 2020-08-06 | Jones | South Dakota | 46075 | 2 | 0 |
410932 | 410932 | 2020-08-07 | Jones | South Dakota | 46075 | 2 | 0 |
414152 | 414152 | 2020-08-08 | Jones | South Dakota | 46075 | 2 | 0 |
417373 | 417373 | 2020-08-09 | Jones | South Dakota | 46075 | 2 | 0 |
420594 | 420594 | 2020-08-10 | Jones | South Dakota | 46075 | 2 | 0 |
423816 | 423816 | 2020-08-11 | Jones | South Dakota | 46075 | 2 | 0 |
427039 | 427039 | 2020-08-12 | Jones | South Dakota | 46075 | 2 | 0 |
430266 | 430266 | 2020-08-13 | Jones | South Dakota | 46075 | 2 | 0 |
433491 | 433491 | 2020-08-14 | Jones | South Dakota | 46075 | 2 | 0 |
436718 | 436718 | 2020-08-15 | Jones | South Dakota | 46075 | 2 | 0 |
439943 | 439943 | 2020-08-16 | Jones | South Dakota | 46075 | 2 | 0 |
443170 | 443170 | 2020-08-17 | Jones | South Dakota | 46075 | 2 | 0 |
446396 | 446396 | 2020-08-18 | Jones | South Dakota | 46075 | 2 | 0 |
449624 | 449624 | 2020-08-19 | Jones | South Dakota | 46075 | 2 | 0 |
452852 | 452852 | 2020-08-20 | Jones | South Dakota | 46075 | 2 | 0 |
456080 | 456080 | 2020-08-21 | Jones | South Dakota | 46075 | 2 | 0 |
16706 | 16706 | 2020-03-28 | Jones | Mississippi | 28067 | 3 | 0 |
22106 | 22106 | 2020-03-31 | Jones | Georgia | 13169 | 3 | 0 |
44809 | 44809 | 2020-04-09 | Jones | North Carolina | 37103 | 3 | 0 |
47422 | 47422 | 2020-04-10 | Jones | North Carolina | 37103 | 3 | 0 |
64181 | 64181 | 2020-04-16 | Jones | Texas | 48253 | 3 | 0 |
66928 | 66928 | 2020-04-17 | Jones | Texas | 48253 | 3 | 0 |
69688 | 69688 | 2020-04-18 | Jones | Texas | 48253 | 3 | 0 |
72457 | 72457 | 2020-04-19 | Jones | Texas | 48253 | 3 | 0 |
75233 | 75233 | 2020-04-20 | Jones | Texas | 48253 | 3 | 0 |
78015 | 78015 | 2020-04-21 | Jones | Texas | 48253 | 3 | 0 |
80806 | 80806 | 2020-04-22 | Jones | Texas | 48253 | 3 | 0 |
459308 | 459308 | 2020-08-22 | Jones | South Dakota | 46075 | 3 | 0 |
462536 | 462536 | 2020-08-23 | Jones | South Dakota | 46075 | 3 | 0 |
465765 | 465765 | 2020-08-24 | Jones | South Dakota | 46075 | 3 | 0 |
468993 | 468993 | 2020-08-25 | Jones | South Dakota | 46075 | 3 | 0 |
472225 | 472225 | 2020-08-26 | Jones | South Dakota | 46075 | 3 | 0 |
475459 | 475459 | 2020-08-27 | Jones | South Dakota | 46075 | 3 | 0 |
478692 | 478692 | 2020-08-28 | Jones | South Dakota | 46075 | 3 | 0 |
481926 | 481926 | 2020-08-29 | Jones | South Dakota | 46075 | 3 | 0 |
485161 | 485161 | 2020-08-30 | Jones | South Dakota | 46075 | 3 | 0 |
488394 | 488394 | 2020-08-31 | Jones | South Dakota | 46075 | 3 | 0 |
491627 | 491627 | 2020-09-01 | Jones | South Dakota | 46075 | 3 | 0 |
22371 | 22371 | 2020-03-31 | Jones | Iowa | 19105 | 4 | 0 |
24269 | 24269 | 2020-04-01 | Jones | Georgia | 13169 | 4 | 0 |
24543 | 24543 | 2020-04-01 | Jones | Iowa | 19105 | 4 | 0 |
83607 | 83607 | 2020-04-23 | Jones | Texas | 48253 | 4 | 0 |
18628 | 18628 | 2020-03-29 | Jones | Mississippi | 28067 | 5 | 0 |
26500 | 26500 | 2020-04-02 | Jones | Georgia | 13169 | 5 | 0 |
26785 | 26785 | 2020-04-02 | Jones | Iowa | 19105 | 5 | 0 |
29096 | 29096 | 2020-04-03 | Jones | Iowa | 19105 | 5 | 0 |
31466 | 31466 | 2020-04-04 | Jones | Iowa | 19105 | 5 | 0 |
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);