ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Madison" and state = "Montana" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4814 | 4814 | 2020-03-19 | Madison | Montana | 30057 | 1 | 0 |
5653 | 5653 | 2020-03-20 | Madison | Montana | 30057 | 1 | 0 |
6644 | 6644 | 2020-03-21 | Madison | Montana | 30057 | 1 | 0 |
7733 | 7733 | 2020-03-22 | Madison | Montana | 30057 | 1 | 0 |
8926 | 8926 | 2020-03-23 | Madison | Montana | 30057 | 1 | 0 |
10229 | 10229 | 2020-03-24 | Madison | Montana | 30057 | 1 | 0 |
11659 | 11659 | 2020-03-25 | Madison | Montana | 30057 | 2 | 0 |
13258 | 13258 | 2020-03-26 | Madison | Montana | 30057 | 2 | 0 |
14989 | 14989 | 2020-03-27 | Madison | Montana | 30057 | 3 | 0 |
16815 | 16815 | 2020-03-28 | Madison | Montana | 30057 | 3 | 0 |
18738 | 18738 | 2020-03-29 | Madison | Montana | 30057 | 4 | 0 |
20773 | 20773 | 2020-03-30 | Madison | Montana | 30057 | 4 | 1 |
22894 | 22894 | 2020-03-31 | Madison | Montana | 30057 | 6 | 1 |
25083 | 25083 | 2020-04-01 | Madison | Montana | 30057 | 6 | 1 |
27340 | 27340 | 2020-04-02 | Madison | Montana | 30057 | 6 | 1 |
29663 | 29663 | 2020-04-03 | Madison | Montana | 30057 | 6 | 1 |
32045 | 32045 | 2020-04-04 | Madison | Montana | 30057 | 6 | 1 |
34473 | 34473 | 2020-04-05 | Madison | Montana | 30057 | 9 | 1 |
36940 | 36940 | 2020-04-06 | Madison | Montana | 30057 | 9 | 1 |
39456 | 39456 | 2020-04-07 | Madison | Montana | 30057 | 9 | 1 |
42011 | 42011 | 2020-04-08 | Madison | Montana | 30057 | 9 | 1 |
44590 | 44590 | 2020-04-09 | Madison | Montana | 30057 | 8 | 1 |
47200 | 47200 | 2020-04-10 | Madison | Montana | 30057 | 8 | 1 |
49849 | 49849 | 2020-04-11 | Madison | Montana | 30057 | 8 | 1 |
52522 | 52522 | 2020-04-12 | Madison | Montana | 30057 | 8 | 1 |
55203 | 55203 | 2020-04-13 | Madison | Montana | 30057 | 8 | 1 |
57902 | 57902 | 2020-04-14 | Madison | Montana | 30057 | 8 | 1 |
60615 | 60615 | 2020-04-15 | Madison | Montana | 30057 | 8 | 1 |
63338 | 63338 | 2020-04-16 | Madison | Montana | 30057 | 8 | 1 |
66078 | 66078 | 2020-04-17 | Madison | Montana | 30057 | 8 | 1 |
68832 | 68832 | 2020-04-18 | Madison | Montana | 30057 | 8 | 1 |
71599 | 71599 | 2020-04-19 | Madison | Montana | 30057 | 8 | 1 |
74372 | 74372 | 2020-04-20 | Madison | Montana | 30057 | 8 | 1 |
77152 | 77152 | 2020-04-21 | Madison | Montana | 30057 | 8 | 1 |
79940 | 79940 | 2020-04-22 | Madison | Montana | 30057 | 8 | 1 |
82736 | 82736 | 2020-04-23 | Madison | Montana | 30057 | 8 | 1 |
85540 | 85540 | 2020-04-24 | Madison | Montana | 30057 | 8 | 1 |
88350 | 88350 | 2020-04-25 | Madison | Montana | 30057 | 8 | 1 |
91165 | 91165 | 2020-04-26 | Madison | Montana | 30057 | 8 | 1 |
93986 | 93986 | 2020-04-27 | Madison | Montana | 30057 | 8 | 1 |
96822 | 96822 | 2020-04-28 | Madison | Montana | 30057 | 8 | 1 |
99668 | 99668 | 2020-04-29 | Madison | Montana | 30057 | 8 | 1 |
102520 | 102520 | 2020-04-30 | Madison | Montana | 30057 | 8 | 1 |
105381 | 105381 | 2020-05-01 | Madison | Montana | 30057 | 8 | 1 |
108247 | 108247 | 2020-05-02 | Madison | Montana | 30057 | 8 | 1 |
111119 | 111119 | 2020-05-03 | Madison | Montana | 30057 | 8 | 1 |
113998 | 113998 | 2020-05-04 | Madison | Montana | 30057 | 8 | 1 |
116880 | 116880 | 2020-05-05 | Madison | Montana | 30057 | 8 | 1 |
119840 | 119840 | 2020-05-06 | Madison | Montana | 30057 | 8 | 1 |
122814 | 122814 | 2020-05-07 | Madison | Montana | 30057 | 8 | 1 |
125796 | 125796 | 2020-05-08 | Madison | Montana | 30057 | 8 | 1 |
128784 | 128784 | 2020-05-09 | Madison | Montana | 30057 | 8 | 1 |
131774 | 131774 | 2020-05-10 | Madison | Montana | 30057 | 8 | 1 |
134765 | 134765 | 2020-05-11 | Madison | Montana | 30057 | 8 | 1 |
137755 | 137755 | 2020-05-12 | Madison | Montana | 30057 | 8 | 1 |
140749 | 140749 | 2020-05-13 | Madison | Montana | 30057 | 8 | 1 |
143744 | 143744 | 2020-05-14 | Madison | Montana | 30057 | 8 | 1 |
146745 | 146745 | 2020-05-15 | Madison | Montana | 30057 | 8 | 1 |
149751 | 149751 | 2020-05-16 | Madison | Montana | 30057 | 8 | 1 |
152762 | 152762 | 2020-05-17 | Madison | Montana | 30057 | 8 | 1 |
155776 | 155776 | 2020-05-18 | Madison | Montana | 30057 | 8 | 1 |
158794 | 158794 | 2020-05-19 | Madison | Montana | 30057 | 8 | 1 |
161820 | 161820 | 2020-05-20 | Madison | Montana | 30057 | 8 | 1 |
164849 | 164849 | 2020-05-21 | Madison | Montana | 30057 | 8 | 1 |
167885 | 167885 | 2020-05-22 | Madison | Montana | 30057 | 8 | 1 |
170924 | 170924 | 2020-05-23 | Madison | Montana | 30057 | 8 | 1 |
173966 | 173966 | 2020-05-24 | Madison | Montana | 30057 | 8 | 1 |
177009 | 177009 | 2020-05-25 | Madison | Montana | 30057 | 8 | 1 |
180053 | 180053 | 2020-05-26 | Madison | Montana | 30057 | 8 | 1 |
183101 | 183101 | 2020-05-27 | Madison | Montana | 30057 | 8 | 1 |
186157 | 186157 | 2020-05-28 | Madison | Montana | 30057 | 8 | 1 |
189216 | 189216 | 2020-05-29 | Madison | Montana | 30057 | 8 | 1 |
192280 | 192280 | 2020-05-30 | Madison | Montana | 30057 | 8 | 1 |
195350 | 195350 | 2020-05-31 | Madison | Montana | 30057 | 8 | 1 |
198421 | 198421 | 2020-06-01 | Madison | Montana | 30057 | 8 | 1 |
201494 | 201494 | 2020-06-02 | Madison | Montana | 30057 | 8 | 1 |
204571 | 204571 | 2020-06-03 | Madison | Montana | 30057 | 8 | 1 |
207652 | 207652 | 2020-06-04 | Madison | Montana | 30057 | 8 | 1 |
210733 | 210733 | 2020-06-05 | Madison | Montana | 30057 | 8 | 1 |
213817 | 213817 | 2020-06-06 | Madison | Montana | 30057 | 8 | 1 |
216906 | 216906 | 2020-06-07 | Madison | Montana | 30057 | 8 | 1 |
219998 | 219998 | 2020-06-08 | Madison | Montana | 30057 | 8 | 1 |
223093 | 223093 | 2020-06-09 | Madison | Montana | 30057 | 8 | 1 |
226192 | 226192 | 2020-06-10 | Madison | Montana | 30057 | 8 | 1 |
229295 | 229295 | 2020-06-11 | Madison | Montana | 30057 | 8 | 1 |
232400 | 232400 | 2020-06-12 | Madison | Montana | 30057 | 8 | 1 |
235506 | 235506 | 2020-06-13 | Madison | Montana | 30057 | 8 | 1 |
238613 | 238613 | 2020-06-14 | Madison | Montana | 30057 | 8 | 1 |
241723 | 241723 | 2020-06-15 | Madison | Montana | 30057 | 8 | 1 |
244834 | 244834 | 2020-06-16 | Madison | Montana | 30057 | 8 | 1 |
247947 | 247947 | 2020-06-17 | Madison | Montana | 30057 | 8 | 1 |
251061 | 251061 | 2020-06-18 | Madison | Montana | 30057 | 8 | 1 |
254176 | 254176 | 2020-06-19 | Madison | Montana | 30057 | 8 | 1 |
257299 | 257299 | 2020-06-20 | Madison | Montana | 30057 | 8 | 1 |
260425 | 260425 | 2020-06-21 | Madison | Montana | 30057 | 8 | 1 |
263554 | 263554 | 2020-06-22 | Madison | Montana | 30057 | 8 | 1 |
266680 | 266680 | 2020-06-23 | Madison | Montana | 30057 | 8 | 1 |
269813 | 269813 | 2020-06-24 | Madison | Montana | 30057 | 8 | 1 |
272952 | 272952 | 2020-06-25 | Madison | Montana | 30057 | 8 | 1 |
276095 | 276095 | 2020-06-26 | Madison | Montana | 30057 | 8 | 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);