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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-04-25 20
- 2020-04-26 20
- 2020-04-27 20
- 2020-04-28 20
- 2020-04-29 20
- 2020-04-30 20
- 2020-05-01 20
- 2020-05-02 20
- 2020-05-03 20
- 2020-05-04 20
- 2020-05-05 20
- 2020-05-06 20
- 2020-05-07 20
- 2020-05-08 20
- 2020-05-09 20
- 2020-05-10 20
- 2020-05-11 20
- 2020-05-12 20
- 2020-05-13 20
- 2020-05-14 20
- 2020-05-15 20
- 2020-05-16 20
- 2020-05-17 20
- 2020-05-18 20
- 2020-05-19 20
- 2020-05-20 20
- 2020-05-21 20
- 2020-05-22 20
- 2020-05-23 20
- 2020-05-24 20
- …
state 20
fips 20
county 1
- Madison · 15,570 ✖
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 |
4408 | 4408 | 2020-03-19 | Madison | Alabama | 1089 | 5 | 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 |
5178 | 5178 | 2020-03-20 | Madison | Alabama | 1089 | 7 | 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 |
5620 | 5620 | 2020-03-20 | Madison | Mississippi | 28089 | 3 | 0 |
5653 | 5653 | 2020-03-20 | Madison | Montana | 30057 | 1 | 0 |
6094 | 6094 | 2020-03-21 | Madison | Alabama | 1089 | 9 | 0 |
6333 | 6333 | 2020-03-21 | Madison | Idaho | 16065 | 2 | 0 |
6349 | 6349 | 2020-03-21 | Madison | Illinois | 17119 | 2 | 0 |
6381 | 6381 | 2020-03-21 | Madison | Indiana | 18095 | 1 | 0 |
6437 | 6437 | 2020-03-21 | Madison | Kentucky | 21151 | 1 | 0 |
6602 | 6602 | 2020-03-21 | Madison | Mississippi | 28089 | 7 | 0 |
6644 | 6644 | 2020-03-21 | Madison | Montana | 30057 | 1 | 0 |
7128 | 7128 | 2020-03-22 | Madison | Alabama | 1089 | 16 | 0 |
7381 | 7381 | 2020-03-22 | Madison | Idaho | 16065 | 2 | 0 |
7401 | 7401 | 2020-03-22 | Madison | Illinois | 17119 | 2 | 0 |
7510 | 7510 | 2020-03-22 | Madison | Kentucky | 21151 | 2 | 0 |
7685 | 7685 | 2020-03-22 | Madison | Mississippi | 28089 | 9 | 0 |
7733 | 7733 | 2020-03-22 | Madison | Montana | 30057 | 1 | 0 |
7814 | 7814 | 2020-03-22 | Madison | New York | 36053 | 1 | 0 |
8268 | 8268 | 2020-03-23 | Madison | Alabama | 1089 | 21 | 0 |
8498 | 8498 | 2020-03-23 | Madison | Georgia | 13195 | 1 | 0 |
8536 | 8536 | 2020-03-23 | Madison | Idaho | 16065 | 2 | 0 |
8556 | 8556 | 2020-03-23 | Madison | Illinois | 17119 | 3 | 0 |
8673 | 8673 | 2020-03-23 | Madison | Kentucky | 21151 | 2 | 0 |
8866 | 8866 | 2020-03-23 | Madison | Mississippi | 28089 | 11 | 0 |
8926 | 8926 | 2020-03-23 | Madison | Montana | 30057 | 1 | 0 |
8940 | 8940 | 2020-03-23 | Madison | Nebraska | 31119 | 1 | 0 |
9012 | 9012 | 2020-03-23 | Madison | New York | 36053 | 4 | 0 |
9121 | 9121 | 2020-03-23 | Madison | Ohio | 39097 | 1 | 0 |
9495 | 9495 | 2020-03-24 | Madison | Alabama | 1089 | 21 | 0 |
9754 | 9754 | 2020-03-24 | Madison | Georgia | 13195 | 1 | 0 |
9799 | 9799 | 2020-03-24 | Madison | Idaho | 16065 | 2 | 0 |
9820 | 9820 | 2020-03-24 | Madison | Illinois | 17119 | 3 | 0 |
9956 | 9956 | 2020-03-24 | Madison | Kentucky | 21151 | 2 | 0 |
10162 | 10162 | 2020-03-24 | Madison | Mississippi | 28089 | 14 | 0 |
10229 | 10229 | 2020-03-24 | Madison | Montana | 30057 | 1 | 0 |
10243 | 10243 | 2020-03-24 | Madison | Nebraska | 31119 | 1 | 0 |
10319 | 10319 | 2020-03-24 | Madison | New York | 36053 | 5 | 0 |
10437 | 10437 | 2020-03-24 | Madison | Ohio | 39097 | 1 | 0 |
10609 | 10609 | 2020-03-24 | Madison | Tennessee | 47113 | 1 | 0 |
10860 | 10860 | 2020-03-25 | Madison | Alabama | 1089 | 35 | 0 |
11134 | 11134 | 2020-03-25 | Madison | Georgia | 13195 | 2 | 0 |
11187 | 11187 | 2020-03-25 | Madison | Idaho | 16065 | 2 | 0 |
11211 | 11211 | 2020-03-25 | Madison | Illinois | 17119 | 3 | 0 |
11358 | 11358 | 2020-03-25 | Madison | Kentucky | 21151 | 3 | 0 |
11582 | 11582 | 2020-03-25 | Madison | Mississippi | 28089 | 17 | 0 |
11659 | 11659 | 2020-03-25 | Madison | Montana | 30057 | 2 | 0 |
11674 | 11674 | 2020-03-25 | Madison | Nebraska | 31119 | 1 | 0 |
11755 | 11755 | 2020-03-25 | Madison | New York | 36053 | 7 | 0 |
11886 | 11886 | 2020-03-25 | Madison | Ohio | 39097 | 2 | 0 |
12088 | 12088 | 2020-03-25 | Madison | Tennessee | 47113 | 2 | 0 |
12251 | 12251 | 2020-03-25 | Madison | Virginia | 51113 | 1 | 0 |
12685 | 12685 | 2020-03-26 | Madison | Georgia | 13195 | 3 | 0 |
12741 | 12741 | 2020-03-26 | Madison | Idaho | 16065 | 2 | 0 |
12767 | 12767 | 2020-03-26 | Madison | Illinois | 17119 | 6 | 0 |
12929 | 12929 | 2020-03-26 | Madison | Kentucky | 21151 | 5 | 0 |
12976 | 12976 | 2020-03-26 | Madison | Louisiana | 22065 | 1 | 0 |
13175 | 13175 | 2020-03-26 | Madison | Mississippi | 28089 | 21 | 0 |
13258 | 13258 | 2020-03-26 | Madison | Montana | 30057 | 2 | 0 |
13277 | 13277 | 2020-03-26 | Madison | Nebraska | 31119 | 1 | 0 |
13358 | 13358 | 2020-03-26 | Madison | New York | 36053 | 9 | 0 |
13494 | 13494 | 2020-03-26 | Madison | Ohio | 39097 | 3 | 0 |
13713 | 13713 | 2020-03-26 | Madison | Tennessee | 47113 | 2 | 0 |
13893 | 13893 | 2020-03-26 | Madison | Virginia | 51113 | 2 | 0 |
14359 | 14359 | 2020-03-27 | Madison | Georgia | 13195 | 3 | 0 |
14417 | 14417 | 2020-03-27 | Madison | Idaho | 16065 | 2 | 0 |
14445 | 14445 | 2020-03-27 | Madison | Illinois | 17119 | 8 | 0 |
14635 | 14635 | 2020-03-27 | Madison | Kentucky | 21151 | 5 | 0 |
14683 | 14683 | 2020-03-27 | Madison | Louisiana | 22065 | 1 | 0 |
14893 | 14893 | 2020-03-27 | Madison | Mississippi | 28089 | 25 | 0 |
14989 | 14989 | 2020-03-27 | Madison | Montana | 30057 | 3 | 0 |
15009 | 15009 | 2020-03-27 | Madison | Nebraska | 31119 | 1 | 0 |
15092 | 15092 | 2020-03-27 | Madison | New York | 36053 | 17 | 0 |
15232 | 15232 | 2020-03-27 | Madison | Ohio | 39097 | 4 | 0 |
15465 | 15465 | 2020-03-27 | Madison | Tennessee | 47113 | 3 | 0 |
15661 | 15661 | 2020-03-27 | Madison | Virginia | 51113 | 2 | 0 |
16146 | 16146 | 2020-03-28 | Madison | Georgia | 13195 | 3 | 0 |
16210 | 16210 | 2020-03-28 | Madison | Idaho | 16065 | 2 | 0 |
16241 | 16241 | 2020-03-28 | Madison | Illinois | 17119 | 10 | 0 |
16450 | 16450 | 2020-03-28 | Madison | Kentucky | 21151 | 7 | 0 |
16503 | 16503 | 2020-03-28 | Madison | Louisiana | 22065 | 1 | 0 |
16717 | 16717 | 2020-03-28 | Madison | Mississippi | 28089 | 29 | 0 |
16815 | 16815 | 2020-03-28 | Madison | Montana | 30057 | 3 | 0 |
16836 | 16836 | 2020-03-28 | Madison | Nebraska | 31119 | 2 | 0 |
16922 | 16922 | 2020-03-28 | Madison | New York | 36053 | 19 | 0 |
17074 | 17074 | 2020-03-28 | Madison | Ohio | 39097 | 4 | 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);