ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Marshall" and fips = 18099 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12817 | 12817 | 2020-03-26 | Marshall | Indiana | 18099 | 1 | 0 |
14502 | 14502 | 2020-03-27 | Marshall | Indiana | 18099 | 4 | 0 |
16300 | 16300 | 2020-03-28 | Marshall | Indiana | 18099 | 3 | 0 |
18204 | 18204 | 2020-03-29 | Marshall | Indiana | 18099 | 3 | 0 |
20210 | 20210 | 2020-03-30 | Marshall | Indiana | 18099 | 3 | 0 |
22305 | 22305 | 2020-03-31 | Marshall | Indiana | 18099 | 3 | 0 |
24476 | 24476 | 2020-04-01 | Marshall | Indiana | 18099 | 3 | 0 |
26715 | 26715 | 2020-04-02 | Marshall | Indiana | 18099 | 4 | 0 |
29025 | 29025 | 2020-04-03 | Marshall | Indiana | 18099 | 4 | 0 |
31391 | 31391 | 2020-04-04 | Marshall | Indiana | 18099 | 4 | 0 |
33802 | 33802 | 2020-04-05 | Marshall | Indiana | 18099 | 6 | 0 |
36255 | 36255 | 2020-04-06 | Marshall | Indiana | 18099 | 8 | 0 |
38753 | 38753 | 2020-04-07 | Marshall | Indiana | 18099 | 10 | 0 |
41299 | 41299 | 2020-04-08 | Marshall | Indiana | 18099 | 11 | 0 |
43875 | 43875 | 2020-04-09 | Marshall | Indiana | 18099 | 11 | 0 |
46479 | 46479 | 2020-04-10 | Marshall | Indiana | 18099 | 12 | 0 |
49113 | 49113 | 2020-04-11 | Marshall | Indiana | 18099 | 14 | 0 |
51776 | 51776 | 2020-04-12 | Marshall | Indiana | 18099 | 19 | 0 |
54457 | 54457 | 2020-04-13 | Marshall | Indiana | 18099 | 17 | 0 |
57150 | 57150 | 2020-04-14 | Marshall | Indiana | 18099 | 17 | 0 |
59858 | 59858 | 2020-04-15 | Marshall | Indiana | 18099 | 19 | 0 |
62579 | 62579 | 2020-04-16 | Marshall | Indiana | 18099 | 20 | 0 |
65313 | 65313 | 2020-04-17 | Marshall | Indiana | 18099 | 22 | 0 |
68062 | 68062 | 2020-04-18 | Marshall | Indiana | 18099 | 22 | 0 |
70824 | 70824 | 2020-04-19 | Marshall | Indiana | 18099 | 23 | 0 |
73595 | 73595 | 2020-04-20 | Marshall | Indiana | 18099 | 24 | 0 |
76372 | 76372 | 2020-04-21 | Marshall | Indiana | 18099 | 24 | 0 |
79156 | 79156 | 2020-04-22 | Marshall | Indiana | 18099 | 26 | 1 |
81949 | 81949 | 2020-04-23 | Marshall | Indiana | 18099 | 25 | 1 |
84749 | 84749 | 2020-04-24 | Marshall | Indiana | 18099 | 25 | 1 |
87559 | 87559 | 2020-04-25 | Marshall | Indiana | 18099 | 26 | 1 |
90375 | 90375 | 2020-04-26 | Marshall | Indiana | 18099 | 27 | 1 |
93194 | 93194 | 2020-04-27 | Marshall | Indiana | 18099 | 29 | 1 |
96026 | 96026 | 2020-04-28 | Marshall | Indiana | 18099 | 28 | 1 |
98870 | 98870 | 2020-04-29 | Marshall | Indiana | 18099 | 28 | 1 |
101721 | 101721 | 2020-04-30 | Marshall | Indiana | 18099 | 29 | 1 |
104577 | 104577 | 2020-05-01 | Marshall | Indiana | 18099 | 30 | 1 |
107442 | 107442 | 2020-05-02 | Marshall | Indiana | 18099 | 30 | 1 |
110312 | 110312 | 2020-05-03 | Marshall | Indiana | 18099 | 31 | 1 |
113187 | 113187 | 2020-05-04 | Marshall | Indiana | 18099 | 31 | 1 |
116070 | 116070 | 2020-05-05 | Marshall | Indiana | 18099 | 32 | 1 |
119030 | 119030 | 2020-05-06 | Marshall | Indiana | 18099 | 31 | 1 |
122000 | 122000 | 2020-05-07 | Marshall | Indiana | 18099 | 31 | 1 |
124980 | 124980 | 2020-05-08 | Marshall | Indiana | 18099 | 31 | 1 |
127967 | 127967 | 2020-05-09 | Marshall | Indiana | 18099 | 32 | 1 |
130958 | 130958 | 2020-05-10 | Marshall | Indiana | 18099 | 33 | 1 |
133948 | 133948 | 2020-05-11 | Marshall | Indiana | 18099 | 34 | 1 |
136937 | 136937 | 2020-05-12 | Marshall | Indiana | 18099 | 36 | 1 |
139929 | 139929 | 2020-05-13 | Marshall | Indiana | 18099 | 37 | 1 |
142925 | 142925 | 2020-05-14 | Marshall | Indiana | 18099 | 39 | 1 |
145925 | 145925 | 2020-05-15 | Marshall | Indiana | 18099 | 39 | 1 |
148929 | 148929 | 2020-05-16 | Marshall | Indiana | 18099 | 40 | 1 |
151938 | 151938 | 2020-05-17 | Marshall | Indiana | 18099 | 43 | 1 |
154950 | 154950 | 2020-05-18 | Marshall | Indiana | 18099 | 42 | 1 |
157966 | 157966 | 2020-05-19 | Marshall | Indiana | 18099 | 44 | 1 |
160992 | 160992 | 2020-05-20 | Marshall | Indiana | 18099 | 50 | 1 |
164020 | 164020 | 2020-05-21 | Marshall | Indiana | 18099 | 51 | 1 |
167053 | 167053 | 2020-05-22 | Marshall | Indiana | 18099 | 54 | 1 |
170090 | 170090 | 2020-05-23 | Marshall | Indiana | 18099 | 61 | 1 |
173131 | 173131 | 2020-05-24 | Marshall | Indiana | 18099 | 64 | 1 |
176175 | 176175 | 2020-05-25 | Marshall | Indiana | 18099 | 64 | 1 |
179219 | 179219 | 2020-05-26 | Marshall | Indiana | 18099 | 76 | 1 |
182263 | 182263 | 2020-05-27 | Marshall | Indiana | 18099 | 80 | 1 |
185317 | 185317 | 2020-05-28 | Marshall | Indiana | 18099 | 80 | 1 |
188375 | 188375 | 2020-05-29 | Marshall | Indiana | 18099 | 90 | 1 |
191440 | 191440 | 2020-05-30 | Marshall | Indiana | 18099 | 102 | 1 |
194507 | 194507 | 2020-05-31 | Marshall | Indiana | 18099 | 108 | 2 |
197577 | 197577 | 2020-06-01 | Marshall | Indiana | 18099 | 111 | 2 |
200650 | 200650 | 2020-06-02 | Marshall | Indiana | 18099 | 128 | 2 |
203726 | 203726 | 2020-06-03 | Marshall | Indiana | 18099 | 147 | 2 |
206806 | 206806 | 2020-06-04 | Marshall | Indiana | 18099 | 178 | 2 |
209887 | 209887 | 2020-06-05 | Marshall | Indiana | 18099 | 187 | 2 |
212972 | 212972 | 2020-06-06 | Marshall | Indiana | 18099 | 196 | 2 |
216059 | 216059 | 2020-06-07 | Marshall | Indiana | 18099 | 214 | 2 |
219151 | 219151 | 2020-06-08 | Marshall | Indiana | 18099 | 227 | 2 |
222246 | 222246 | 2020-06-09 | Marshall | Indiana | 18099 | 230 | 2 |
225341 | 225341 | 2020-06-10 | Marshall | Indiana | 18099 | 247 | 2 |
228443 | 228443 | 2020-06-11 | Marshall | Indiana | 18099 | 261 | 3 |
231546 | 231546 | 2020-06-12 | Marshall | Indiana | 18099 | 276 | 3 |
234652 | 234652 | 2020-06-13 | Marshall | Indiana | 18099 | 287 | 3 |
237759 | 237759 | 2020-06-14 | Marshall | Indiana | 18099 | 301 | 3 |
240867 | 240867 | 2020-06-15 | Marshall | Indiana | 18099 | 305 | 3 |
243978 | 243978 | 2020-06-16 | Marshall | Indiana | 18099 | 315 | 3 |
247091 | 247091 | 2020-06-17 | Marshall | Indiana | 18099 | 322 | 3 |
250203 | 250203 | 2020-06-18 | Marshall | Indiana | 18099 | 338 | 3 |
253318 | 253318 | 2020-06-19 | Marshall | Indiana | 18099 | 344 | 3 |
256438 | 256438 | 2020-06-20 | Marshall | Indiana | 18099 | 347 | 3 |
259564 | 259564 | 2020-06-21 | Marshall | Indiana | 18099 | 359 | 3 |
262691 | 262691 | 2020-06-22 | Marshall | Indiana | 18099 | 365 | 3 |
265819 | 265819 | 2020-06-23 | Marshall | Indiana | 18099 | 369 | 3 |
268949 | 268949 | 2020-06-24 | Marshall | Indiana | 18099 | 374 | 3 |
272086 | 272086 | 2020-06-25 | Marshall | Indiana | 18099 | 385 | 3 |
275228 | 275228 | 2020-06-26 | Marshall | Indiana | 18099 | 393 | 3 |
278376 | 278376 | 2020-06-27 | Marshall | Indiana | 18099 | 401 | 3 |
281524 | 281524 | 2020-06-28 | Marshall | Indiana | 18099 | 403 | 3 |
284669 | 284669 | 2020-06-29 | Marshall | Indiana | 18099 | 407 | 3 |
287818 | 287818 | 2020-06-30 | Marshall | Indiana | 18099 | 409 | 3 |
290968 | 290968 | 2020-07-01 | Marshall | Indiana | 18099 | 412 | 3 |
294122 | 294122 | 2020-07-02 | Marshall | Indiana | 18099 | 418 | 3 |
297280 | 297280 | 2020-07-03 | Marshall | Indiana | 18099 | 427 | 3 |
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);