ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
15,570 rows where county = "Madison" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
3220 | 3220 | 2020-03-17 | Madison | Alabama | 1089 | 1 | 0 |
3358 | 3358 | 2020-03-17 | Madison | Idaho | 16065 | 1 | 0 |
3767 | 3767 | 2020-03-18 | Madison | Alabama | 1089 | 1 | 0 |
3920 | 3920 | 2020-03-18 | Madison | Idaho | 16065 | 1 | 0 |
3933 | 3933 | 2020-03-18 | Madison | Illinois | 17119 | 1 | 0 |
3958 | 3958 | 2020-03-18 | Madison | Indiana | 18095 | 1 | 0 |
4078 | 4078 | 2020-03-18 | Madison | Mississippi | 28089 | 1 | 0 |
4596 | 4596 | 2020-03-19 | Madison | Idaho | 16065 | 1 | 0 |
4609 | 4609 | 2020-03-19 | Madison | Illinois | 17119 | 1 | 0 |
4634 | 4634 | 2020-03-19 | Madison | Indiana | 18095 | 1 | 0 |
4792 | 4792 | 2020-03-19 | Madison | Mississippi | 28089 | 1 | 0 |
4814 | 4814 | 2020-03-19 | Madison | Montana | 30057 | 1 | 0 |
5399 | 5399 | 2020-03-20 | Madison | Idaho | 16065 | 1 | 0 |
5414 | 5414 | 2020-03-20 | Madison | Illinois | 17119 | 1 | 0 |
5442 | 5442 | 2020-03-20 | Madison | Indiana | 18095 | 1 | 0 |
5653 | 5653 | 2020-03-20 | Madison | Montana | 30057 | 1 | 0 |
6381 | 6381 | 2020-03-21 | Madison | Indiana | 18095 | 1 | 0 |
6437 | 6437 | 2020-03-21 | Madison | Kentucky | 21151 | 1 | 0 |
6644 | 6644 | 2020-03-21 | Madison | Montana | 30057 | 1 | 0 |
7733 | 7733 | 2020-03-22 | Madison | Montana | 30057 | 1 | 0 |
7814 | 7814 | 2020-03-22 | Madison | New York | 36053 | 1 | 0 |
8498 | 8498 | 2020-03-23 | Madison | Georgia | 13195 | 1 | 0 |
8926 | 8926 | 2020-03-23 | Madison | Montana | 30057 | 1 | 0 |
8940 | 8940 | 2020-03-23 | Madison | Nebraska | 31119 | 1 | 0 |
9121 | 9121 | 2020-03-23 | Madison | Ohio | 39097 | 1 | 0 |
9754 | 9754 | 2020-03-24 | Madison | Georgia | 13195 | 1 | 0 |
10229 | 10229 | 2020-03-24 | Madison | Montana | 30057 | 1 | 0 |
10243 | 10243 | 2020-03-24 | Madison | Nebraska | 31119 | 1 | 0 |
10437 | 10437 | 2020-03-24 | Madison | Ohio | 39097 | 1 | 0 |
10609 | 10609 | 2020-03-24 | Madison | Tennessee | 47113 | 1 | 0 |
11674 | 11674 | 2020-03-25 | Madison | Nebraska | 31119 | 1 | 0 |
12251 | 12251 | 2020-03-25 | Madison | Virginia | 51113 | 1 | 0 |
12976 | 12976 | 2020-03-26 | Madison | Louisiana | 22065 | 1 | 0 |
13277 | 13277 | 2020-03-26 | Madison | Nebraska | 31119 | 1 | 0 |
14683 | 14683 | 2020-03-27 | Madison | Louisiana | 22065 | 1 | 0 |
15009 | 15009 | 2020-03-27 | Madison | Nebraska | 31119 | 1 | 0 |
16503 | 16503 | 2020-03-28 | Madison | Louisiana | 22065 | 1 | 0 |
18415 | 18415 | 2020-03-29 | Madison | Louisiana | 22065 | 1 | 0 |
20431 | 20431 | 2020-03-30 | Madison | Louisiana | 22065 | 1 | 0 |
22539 | 22539 | 2020-03-31 | Madison | Louisiana | 22065 | 1 | 0 |
24547 | 24547 | 2020-04-01 | Madison | Iowa | 19121 | 1 | 0 |
24715 | 24715 | 2020-04-01 | Madison | Louisiana | 22065 | 1 | 0 |
26789 | 26789 | 2020-04-02 | Madison | Iowa | 19121 | 1 | 0 |
26966 | 26966 | 2020-04-02 | Madison | Louisiana | 22065 | 1 | 0 |
29102 | 29102 | 2020-04-03 | Madison | Iowa | 19121 | 1 | 0 |
29283 | 29283 | 2020-04-03 | Madison | Louisiana | 22065 | 1 | 0 |
31473 | 31473 | 2020-04-04 | Madison | Iowa | 19121 | 1 | 0 |
31661 | 31661 | 2020-04-04 | Madison | Louisiana | 22065 | 1 | 0 |
33886 | 33886 | 2020-04-05 | Madison | Iowa | 19121 | 1 | 0 |
34086 | 34086 | 2020-04-05 | Madison | Louisiana | 22065 | 1 | 0 |
36341 | 36341 | 2020-04-06 | Madison | Iowa | 19121 | 1 | 0 |
36544 | 36544 | 2020-04-06 | Madison | Louisiana | 22065 | 1 | 0 |
36888 | 36888 | 2020-04-06 | Madison | Missouri | 29123 | 1 | 0 |
38842 | 38842 | 2020-04-07 | Madison | Iowa | 19121 | 1 | 0 |
39401 | 39401 | 2020-04-07 | Madison | Missouri | 29123 | 1 | 0 |
40758 | 40758 | 2020-04-08 | Madison | Arkansas | 5087 | 1 | 0 |
41388 | 41388 | 2020-04-08 | Madison | Iowa | 19121 | 1 | 0 |
41955 | 41955 | 2020-04-08 | Madison | Missouri | 29123 | 1 | 0 |
43330 | 43330 | 2020-04-09 | Madison | Arkansas | 5087 | 1 | 0 |
43964 | 43964 | 2020-04-09 | Madison | Iowa | 19121 | 1 | 0 |
44532 | 44532 | 2020-04-09 | Madison | Missouri | 29123 | 1 | 0 |
45408 | 45408 | 2020-04-09 | Madison | Texas | 48313 | 1 | 0 |
45929 | 45929 | 2020-04-10 | Madison | Arkansas | 5087 | 1 | 0 |
46569 | 46569 | 2020-04-10 | Madison | Iowa | 19121 | 1 | 0 |
47141 | 47141 | 2020-04-10 | Madison | Missouri | 29123 | 1 | 0 |
48029 | 48029 | 2020-04-10 | Madison | Texas | 48313 | 1 | 0 |
48559 | 48559 | 2020-04-11 | Madison | Arkansas | 5087 | 1 | 0 |
49789 | 49789 | 2020-04-11 | Madison | Missouri | 29123 | 1 | 0 |
50687 | 50687 | 2020-04-11 | Madison | Texas | 48313 | 1 | 0 |
51221 | 51221 | 2020-04-12 | Madison | Arkansas | 5087 | 1 | 0 |
52462 | 52462 | 2020-04-12 | Madison | Missouri | 29123 | 1 | 0 |
53362 | 53362 | 2020-04-12 | Madison | Texas | 48313 | 1 | 0 |
53900 | 53900 | 2020-04-13 | Madison | Arkansas | 5087 | 1 | 0 |
55144 | 55144 | 2020-04-13 | Madison | Missouri | 29123 | 1 | 0 |
56050 | 56050 | 2020-04-13 | Madison | Texas | 48313 | 1 | 0 |
56592 | 56592 | 2020-04-14 | Madison | Arkansas | 5087 | 1 | 0 |
57842 | 57842 | 2020-04-14 | Madison | Missouri | 29123 | 1 | 0 |
58755 | 58755 | 2020-04-14 | Madison | Texas | 48313 | 1 | 0 |
59300 | 59300 | 2020-04-15 | Madison | Arkansas | 5087 | 1 | 0 |
60555 | 60555 | 2020-04-15 | Madison | Missouri | 29123 | 1 | 0 |
61473 | 61473 | 2020-04-15 | Madison | Texas | 48313 | 1 | 0 |
62019 | 62019 | 2020-04-16 | Madison | Arkansas | 5087 | 1 | 0 |
63277 | 63277 | 2020-04-16 | Madison | Missouri | 29123 | 1 | 0 |
64201 | 64201 | 2020-04-16 | Madison | Texas | 48313 | 1 | 0 |
64752 | 64752 | 2020-04-17 | Madison | Arkansas | 5087 | 1 | 0 |
66017 | 66017 | 2020-04-17 | Madison | Missouri | 29123 | 1 | 0 |
66948 | 66948 | 2020-04-17 | Madison | Texas | 48313 | 1 | 0 |
67500 | 67500 | 2020-04-18 | Madison | Arkansas | 5087 | 1 | 0 |
68770 | 68770 | 2020-04-18 | Madison | Missouri | 29123 | 1 | 0 |
70262 | 70262 | 2020-04-19 | Madison | Arkansas | 5087 | 1 | 0 |
71537 | 71537 | 2020-04-19 | Madison | Missouri | 29123 | 1 | 0 |
73031 | 73031 | 2020-04-20 | Madison | Arkansas | 5087 | 1 | 0 |
74310 | 74310 | 2020-04-20 | Madison | Missouri | 29123 | 1 | 0 |
75807 | 75807 | 2020-04-21 | Madison | Arkansas | 5087 | 1 | 0 |
77091 | 77091 | 2020-04-21 | Madison | Missouri | 29123 | 1 | 0 |
78591 | 78591 | 2020-04-22 | Madison | Arkansas | 5087 | 1 | 0 |
79877 | 79877 | 2020-04-22 | Madison | Missouri | 29123 | 1 | 0 |
81385 | 81385 | 2020-04-23 | Madison | Arkansas | 5087 | 1 | 0 |
82673 | 82673 | 2020-04-23 | Madison | Missouri | 29123 | 1 | 0 |
84185 | 84185 | 2020-04-24 | Madison | Arkansas | 5087 | 1 | 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);