ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Martin" and state = "Indiana" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
31392 | 31392 | 2020-04-04 | Martin | Indiana | 18101 | 1 | 0 |
33803 | 33803 | 2020-04-05 | Martin | Indiana | 18101 | 1 | 0 |
36256 | 36256 | 2020-04-06 | Martin | Indiana | 18101 | 2 | 0 |
38754 | 38754 | 2020-04-07 | Martin | Indiana | 18101 | 2 | 0 |
41300 | 41300 | 2020-04-08 | Martin | Indiana | 18101 | 1 | 0 |
43876 | 43876 | 2020-04-09 | Martin | Indiana | 18101 | 2 | 0 |
46480 | 46480 | 2020-04-10 | Martin | Indiana | 18101 | 2 | 0 |
49114 | 49114 | 2020-04-11 | Martin | Indiana | 18101 | 2 | 0 |
51777 | 51777 | 2020-04-12 | Martin | Indiana | 18101 | 5 | 0 |
54458 | 54458 | 2020-04-13 | Martin | Indiana | 18101 | 5 | 0 |
57151 | 57151 | 2020-04-14 | Martin | Indiana | 18101 | 5 | 0 |
59859 | 59859 | 2020-04-15 | Martin | Indiana | 18101 | 5 | 0 |
62580 | 62580 | 2020-04-16 | Martin | Indiana | 18101 | 5 | 0 |
65314 | 65314 | 2020-04-17 | Martin | Indiana | 18101 | 5 | 0 |
68063 | 68063 | 2020-04-18 | Martin | Indiana | 18101 | 5 | 0 |
70825 | 70825 | 2020-04-19 | Martin | Indiana | 18101 | 5 | 0 |
73596 | 73596 | 2020-04-20 | Martin | Indiana | 18101 | 6 | 0 |
76373 | 76373 | 2020-04-21 | Martin | Indiana | 18101 | 6 | 0 |
79157 | 79157 | 2020-04-22 | Martin | Indiana | 18101 | 6 | 0 |
81950 | 81950 | 2020-04-23 | Martin | Indiana | 18101 | 6 | 0 |
84750 | 84750 | 2020-04-24 | Martin | Indiana | 18101 | 7 | 0 |
87560 | 87560 | 2020-04-25 | Martin | Indiana | 18101 | 7 | 0 |
90376 | 90376 | 2020-04-26 | Martin | Indiana | 18101 | 7 | 0 |
93195 | 93195 | 2020-04-27 | Martin | Indiana | 18101 | 7 | 0 |
96027 | 96027 | 2020-04-28 | Martin | Indiana | 18101 | 7 | 0 |
98871 | 98871 | 2020-04-29 | Martin | Indiana | 18101 | 7 | 0 |
101722 | 101722 | 2020-04-30 | Martin | Indiana | 18101 | 7 | 0 |
104578 | 104578 | 2020-05-01 | Martin | Indiana | 18101 | 7 | 0 |
107443 | 107443 | 2020-05-02 | Martin | Indiana | 18101 | 7 | 0 |
110313 | 110313 | 2020-05-03 | Martin | Indiana | 18101 | 7 | 0 |
113188 | 113188 | 2020-05-04 | Martin | Indiana | 18101 | 7 | 0 |
116071 | 116071 | 2020-05-05 | Martin | Indiana | 18101 | 7 | 0 |
119031 | 119031 | 2020-05-06 | Martin | Indiana | 18101 | 7 | 0 |
122001 | 122001 | 2020-05-07 | Martin | Indiana | 18101 | 7 | 0 |
124981 | 124981 | 2020-05-08 | Martin | Indiana | 18101 | 7 | 0 |
127968 | 127968 | 2020-05-09 | Martin | Indiana | 18101 | 7 | 0 |
130959 | 130959 | 2020-05-10 | Martin | Indiana | 18101 | 7 | 0 |
133949 | 133949 | 2020-05-11 | Martin | Indiana | 18101 | 7 | 0 |
136938 | 136938 | 2020-05-12 | Martin | Indiana | 18101 | 7 | 0 |
139930 | 139930 | 2020-05-13 | Martin | Indiana | 18101 | 7 | 0 |
142926 | 142926 | 2020-05-14 | Martin | Indiana | 18101 | 7 | 0 |
145926 | 145926 | 2020-05-15 | Martin | Indiana | 18101 | 7 | 0 |
148930 | 148930 | 2020-05-16 | Martin | Indiana | 18101 | 7 | 0 |
151939 | 151939 | 2020-05-17 | Martin | Indiana | 18101 | 7 | 0 |
154951 | 154951 | 2020-05-18 | Martin | Indiana | 18101 | 8 | 0 |
157967 | 157967 | 2020-05-19 | Martin | Indiana | 18101 | 8 | 0 |
160993 | 160993 | 2020-05-20 | Martin | Indiana | 18101 | 8 | 0 |
164021 | 164021 | 2020-05-21 | Martin | Indiana | 18101 | 8 | 0 |
167054 | 167054 | 2020-05-22 | Martin | Indiana | 18101 | 8 | 0 |
170091 | 170091 | 2020-05-23 | Martin | Indiana | 18101 | 10 | 0 |
173132 | 173132 | 2020-05-24 | Martin | Indiana | 18101 | 9 | 0 |
176176 | 176176 | 2020-05-25 | Martin | Indiana | 18101 | 9 | 0 |
179220 | 179220 | 2020-05-26 | Martin | Indiana | 18101 | 9 | 0 |
182264 | 182264 | 2020-05-27 | Martin | Indiana | 18101 | 9 | 0 |
185318 | 185318 | 2020-05-28 | Martin | Indiana | 18101 | 9 | 0 |
188376 | 188376 | 2020-05-29 | Martin | Indiana | 18101 | 11 | 0 |
191441 | 191441 | 2020-05-30 | Martin | Indiana | 18101 | 11 | 0 |
194508 | 194508 | 2020-05-31 | Martin | Indiana | 18101 | 11 | 0 |
197578 | 197578 | 2020-06-01 | Martin | Indiana | 18101 | 11 | 0 |
200651 | 200651 | 2020-06-02 | Martin | Indiana | 18101 | 12 | 0 |
203727 | 203727 | 2020-06-03 | Martin | Indiana | 18101 | 12 | 0 |
206807 | 206807 | 2020-06-04 | Martin | Indiana | 18101 | 13 | 0 |
209888 | 209888 | 2020-06-05 | Martin | Indiana | 18101 | 14 | 0 |
212973 | 212973 | 2020-06-06 | Martin | Indiana | 18101 | 14 | 0 |
216060 | 216060 | 2020-06-07 | Martin | Indiana | 18101 | 15 | 0 |
219152 | 219152 | 2020-06-08 | Martin | Indiana | 18101 | 15 | 0 |
222247 | 222247 | 2020-06-09 | Martin | Indiana | 18101 | 15 | 0 |
225342 | 225342 | 2020-06-10 | Martin | Indiana | 18101 | 15 | 0 |
228444 | 228444 | 2020-06-11 | Martin | Indiana | 18101 | 15 | 0 |
231547 | 231547 | 2020-06-12 | Martin | Indiana | 18101 | 15 | 0 |
234653 | 234653 | 2020-06-13 | Martin | Indiana | 18101 | 15 | 0 |
237760 | 237760 | 2020-06-14 | Martin | Indiana | 18101 | 16 | 0 |
240868 | 240868 | 2020-06-15 | Martin | Indiana | 18101 | 16 | 0 |
243979 | 243979 | 2020-06-16 | Martin | Indiana | 18101 | 16 | 0 |
247092 | 247092 | 2020-06-17 | Martin | Indiana | 18101 | 16 | 0 |
250204 | 250204 | 2020-06-18 | Martin | Indiana | 18101 | 20 | 0 |
253319 | 253319 | 2020-06-19 | Martin | Indiana | 18101 | 20 | 0 |
256439 | 256439 | 2020-06-20 | Martin | Indiana | 18101 | 20 | 0 |
259565 | 259565 | 2020-06-21 | Martin | Indiana | 18101 | 21 | 0 |
262692 | 262692 | 2020-06-22 | Martin | Indiana | 18101 | 21 | 0 |
265820 | 265820 | 2020-06-23 | Martin | Indiana | 18101 | 22 | 0 |
268950 | 268950 | 2020-06-24 | Martin | Indiana | 18101 | 22 | 0 |
272087 | 272087 | 2020-06-25 | Martin | Indiana | 18101 | 22 | 0 |
275229 | 275229 | 2020-06-26 | Martin | Indiana | 18101 | 22 | 0 |
278377 | 278377 | 2020-06-27 | Martin | Indiana | 18101 | 22 | 0 |
281525 | 281525 | 2020-06-28 | Martin | Indiana | 18101 | 22 | 0 |
284670 | 284670 | 2020-06-29 | Martin | Indiana | 18101 | 24 | 0 |
287819 | 287819 | 2020-06-30 | Martin | Indiana | 18101 | 22 | 0 |
290969 | 290969 | 2020-07-01 | Martin | Indiana | 18101 | 22 | 0 |
294123 | 294123 | 2020-07-02 | Martin | Indiana | 18101 | 22 | 0 |
297281 | 297281 | 2020-07-03 | Martin | Indiana | 18101 | 22 | 0 |
300443 | 300443 | 2020-07-04 | Martin | Indiana | 18101 | 22 | 0 |
303607 | 303607 | 2020-07-05 | Martin | Indiana | 18101 | 22 | 0 |
306772 | 306772 | 2020-07-06 | Martin | Indiana | 18101 | 22 | 0 |
309940 | 309940 | 2020-07-07 | Martin | Indiana | 18101 | 23 | 0 |
313110 | 313110 | 2020-07-08 | Martin | Indiana | 18101 | 22 | 0 |
316284 | 316284 | 2020-07-09 | Martin | Indiana | 18101 | 22 | 0 |
319457 | 319457 | 2020-07-10 | Martin | Indiana | 18101 | 24 | 0 |
322636 | 322636 | 2020-07-11 | Martin | Indiana | 18101 | 26 | 0 |
325817 | 325817 | 2020-07-12 | Martin | Indiana | 18101 | 26 | 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);