ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,710 rows where county = "Delaware" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 1
- Delaware · 4,710 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635 | 635 | 2020-03-06 | Delaware | Pennsylvania | 42045 | 1 | 0 |
726 | 726 | 2020-03-07 | Delaware | Pennsylvania | 42045 | 1 | 0 |
835 | 835 | 2020-03-08 | Delaware | Pennsylvania | 42045 | 1 | 0 |
963 | 963 | 2020-03-09 | Delaware | Pennsylvania | 42045 | 1 | 0 |
1115 | 1115 | 2020-03-10 | Delaware | Pennsylvania | 42045 | 1 | 0 |
1309 | 1309 | 2020-03-11 | Delaware | Pennsylvania | 42045 | 1 | 0 |
1517 | 1517 | 2020-03-12 | Delaware | New York | 36025 | 1 | 0 |
1553 | 1553 | 2020-03-12 | Delaware | Pennsylvania | 42045 | 1 | 0 |
1810 | 1810 | 2020-03-13 | Delaware | New York | 36025 | 1 | 0 |
1851 | 1851 | 2020-03-13 | Delaware | Pennsylvania | 42045 | 6 | 0 |
2159 | 2159 | 2020-03-14 | Delaware | New York | 36025 | 1 | 0 |
2213 | 2213 | 2020-03-14 | Delaware | Pennsylvania | 42045 | 6 | 0 |
2567 | 2567 | 2020-03-15 | Delaware | New York | 36025 | 1 | 0 |
2633 | 2633 | 2020-03-15 | Delaware | Pennsylvania | 42045 | 7 | 0 |
3026 | 3026 | 2020-03-16 | Delaware | New York | 36025 | 1 | 0 |
3098 | 3098 | 2020-03-16 | Delaware | Pennsylvania | 42045 | 7 | 0 |
3542 | 3542 | 2020-03-17 | Delaware | New York | 36025 | 1 | 0 |
3628 | 3628 | 2020-03-17 | Delaware | Pennsylvania | 42045 | 9 | 0 |
4139 | 4139 | 2020-03-18 | Delaware | New York | 36025 | 1 | 0 |
4202 | 4202 | 2020-03-18 | Delaware | Ohio | 39041 | 1 | 0 |
4245 | 4245 | 2020-03-18 | Delaware | Pennsylvania | 42045 | 14 | 0 |
4868 | 4868 | 2020-03-19 | Delaware | New York | 36025 | 1 | 0 |
4933 | 4933 | 2020-03-19 | Delaware | Ohio | 39041 | 2 | 0 |
4984 | 4984 | 2020-03-19 | Delaware | Pennsylvania | 42045 | 14 | 0 |
5715 | 5715 | 2020-03-20 | Delaware | New York | 36025 | 1 | 0 |
5796 | 5796 | 2020-03-20 | Delaware | Ohio | 39041 | 2 | 0 |
5854 | 5854 | 2020-03-20 | Delaware | Pennsylvania | 42045 | 23 | 0 |
6366 | 6366 | 2020-03-21 | Delaware | Indiana | 18035 | 1 | 1 |
6709 | 6709 | 2020-03-21 | Delaware | New York | 36025 | 1 | 0 |
6795 | 6795 | 2020-03-21 | Delaware | Ohio | 39041 | 4 | 0 |
6857 | 6857 | 2020-03-21 | Delaware | Pennsylvania | 42045 | 33 | 0 |
7420 | 7420 | 2020-03-22 | Delaware | Indiana | 18035 | 2 | 1 |
7803 | 7803 | 2020-03-22 | Delaware | New York | 36025 | 3 | 0 |
7903 | 7903 | 2020-03-22 | Delaware | Ohio | 39041 | 6 | 0 |
7974 | 7974 | 2020-03-22 | Delaware | Pennsylvania | 42045 | 43 | 0 |
8577 | 8577 | 2020-03-23 | Delaware | Indiana | 18035 | 3 | 1 |
9001 | 9001 | 2020-03-23 | Delaware | New York | 36025 | 3 | 0 |
9106 | 9106 | 2020-03-23 | Delaware | Ohio | 39041 | 7 | 0 |
9185 | 9185 | 2020-03-23 | Delaware | Pennsylvania | 42045 | 54 | 0 |
9844 | 9844 | 2020-03-24 | Delaware | Indiana | 18035 | 4 | 1 |
10308 | 10308 | 2020-03-24 | Delaware | New York | 36025 | 3 | 0 |
10420 | 10420 | 2020-03-24 | Delaware | Ohio | 39041 | 11 | 0 |
10508 | 10508 | 2020-03-24 | Delaware | Pennsylvania | 42045 | 84 | 0 |
11238 | 11238 | 2020-03-25 | Delaware | Indiana | 18035 | 7 | 1 |
11743 | 11743 | 2020-03-25 | Delaware | New York | 36025 | 5 | 0 |
11867 | 11867 | 2020-03-25 | Delaware | Ohio | 39041 | 12 | 0 |
11914 | 11914 | 2020-03-25 | Delaware | Oklahoma | 40041 | 1 | 0 |
11970 | 11970 | 2020-03-25 | Delaware | Pennsylvania | 42045 | 101 | 0 |
12794 | 12794 | 2020-03-26 | Delaware | Indiana | 18035 | 7 | 1 |
13346 | 13346 | 2020-03-26 | Delaware | New York | 36025 | 7 | 0 |
13474 | 13474 | 2020-03-26 | Delaware | Ohio | 39041 | 15 | 0 |
13526 | 13526 | 2020-03-26 | Delaware | Oklahoma | 40041 | 1 | 0 |
13590 | 13590 | 2020-03-26 | Delaware | Pennsylvania | 42045 | 156 | 1 |
14474 | 14474 | 2020-03-27 | Delaware | Indiana | 18035 | 8 | 1 |
15080 | 15080 | 2020-03-27 | Delaware | New York | 36025 | 8 | 0 |
15211 | 15211 | 2020-03-27 | Delaware | Ohio | 39041 | 22 | 0 |
15268 | 15268 | 2020-03-27 | Delaware | Oklahoma | 40041 | 2 | 0 |
15336 | 15336 | 2020-03-27 | Delaware | Pennsylvania | 42045 | 185 | 3 |
16272 | 16272 | 2020-03-28 | Delaware | Indiana | 18035 | 8 | 1 |
16910 | 16910 | 2020-03-28 | Delaware | New York | 36025 | 8 | 0 |
17053 | 17053 | 2020-03-28 | Delaware | Ohio | 39041 | 26 | 0 |
17113 | 17113 | 2020-03-28 | Delaware | Oklahoma | 40041 | 4 | 0 |
17185 | 17185 | 2020-03-28 | Delaware | Pennsylvania | 42045 | 226 | 4 |
18174 | 18174 | 2020-03-29 | Delaware | Indiana | 18035 | 14 | 1 |
18834 | 18834 | 2020-03-29 | Delaware | New York | 36025 | 8 | 0 |
18987 | 18987 | 2020-03-29 | Delaware | Ohio | 39041 | 31 | 0 |
19047 | 19047 | 2020-03-29 | Delaware | Oklahoma | 40041 | 4 | 0 |
19123 | 19123 | 2020-03-29 | Delaware | Pennsylvania | 42045 | 276 | 4 |
20180 | 20180 | 2020-03-30 | Delaware | Indiana | 18035 | 15 | 1 |
20873 | 20873 | 2020-03-30 | Delaware | New York | 36025 | 11 | 0 |
21031 | 21031 | 2020-03-30 | Delaware | Ohio | 39041 | 38 | 1 |
21096 | 21096 | 2020-03-30 | Delaware | Oklahoma | 40041 | 7 | 0 |
21173 | 21173 | 2020-03-30 | Delaware | Pennsylvania | 42045 | 303 | 4 |
22274 | 22274 | 2020-03-31 | Delaware | Indiana | 18035 | 18 | 1 |
22996 | 22996 | 2020-03-31 | Delaware | New York | 36025 | 16 | 0 |
23163 | 23163 | 2020-03-31 | Delaware | Ohio | 39041 | 40 | 1 |
23229 | 23229 | 2020-03-31 | Delaware | Oklahoma | 40041 | 7 | 0 |
23309 | 23309 | 2020-03-31 | Delaware | Pennsylvania | 42045 | 338 | 6 |
24444 | 24444 | 2020-04-01 | Delaware | Indiana | 18035 | 22 | 1 |
25190 | 25190 | 2020-04-01 | Delaware | New York | 36025 | 20 | 0 |
25358 | 25358 | 2020-04-01 | Delaware | Ohio | 39041 | 47 | 1 |
25425 | 25425 | 2020-04-01 | Delaware | Oklahoma | 40041 | 8 | 0 |
25507 | 25507 | 2020-04-01 | Delaware | Pennsylvania | 42045 | 390 | 7 |
26683 | 26683 | 2020-04-02 | Delaware | Indiana | 18035 | 25 | 1 |
27450 | 27450 | 2020-04-02 | Delaware | New York | 36025 | 23 | 1 |
27624 | 27624 | 2020-04-02 | Delaware | Ohio | 39041 | 50 | 1 |
27695 | 27695 | 2020-04-02 | Delaware | Oklahoma | 40041 | 10 | 0 |
27779 | 27779 | 2020-04-02 | Delaware | Pennsylvania | 42045 | 470 | 8 |
28993 | 28993 | 2020-04-03 | Delaware | Indiana | 18035 | 30 | 1 |
29774 | 29774 | 2020-04-03 | Delaware | New York | 36025 | 23 | 1 |
29953 | 29953 | 2020-04-03 | Delaware | Ohio | 39041 | 61 | 1 |
30024 | 30024 | 2020-04-03 | Delaware | Oklahoma | 40041 | 11 | 0 |
30113 | 30113 | 2020-04-03 | Delaware | Pennsylvania | 42045 | 542 | 10 |
31359 | 31359 | 2020-04-04 | Delaware | Indiana | 18035 | 33 | 1 |
32160 | 32160 | 2020-04-04 | Delaware | New York | 36025 | 30 | 1 |
32342 | 32342 | 2020-04-04 | Delaware | Ohio | 39041 | 69 | 1 |
32413 | 32413 | 2020-04-04 | Delaware | Oklahoma | 40041 | 11 | 0 |
32503 | 32503 | 2020-04-04 | Delaware | Pennsylvania | 42045 | 616 | 13 |
33770 | 33770 | 2020-04-05 | Delaware | Indiana | 18035 | 37 | 1 |
34591 | 34591 | 2020-04-05 | Delaware | New York | 36025 | 30 | 1 |
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);