ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Porter" and state = "Indiana" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9872 | 9872 | 2020-03-24 | Porter | Indiana | 18127 | 1 | 0 |
11267 | 11267 | 2020-03-25 | Porter | Indiana | 18127 | 3 | 0 |
12826 | 12826 | 2020-03-26 | Porter | Indiana | 18127 | 5 | 0 |
14511 | 14511 | 2020-03-27 | Porter | Indiana | 18127 | 6 | 0 |
16310 | 16310 | 2020-03-28 | Porter | Indiana | 18127 | 9 | 0 |
18214 | 18214 | 2020-03-29 | Porter | Indiana | 18127 | 14 | 0 |
20220 | 20220 | 2020-03-30 | Porter | Indiana | 18127 | 15 | 0 |
22315 | 22315 | 2020-03-31 | Porter | Indiana | 18127 | 21 | 0 |
24486 | 24486 | 2020-04-01 | Porter | Indiana | 18127 | 27 | 0 |
26725 | 26725 | 2020-04-02 | Porter | Indiana | 18127 | 35 | 0 |
29036 | 29036 | 2020-04-03 | Porter | Indiana | 18127 | 45 | 0 |
31403 | 31403 | 2020-04-04 | Porter | Indiana | 18127 | 51 | 0 |
33814 | 33814 | 2020-04-05 | Porter | Indiana | 18127 | 59 | 0 |
36267 | 36267 | 2020-04-06 | Porter | Indiana | 18127 | 79 | 0 |
38765 | 38765 | 2020-04-07 | Porter | Indiana | 18127 | 84 | 0 |
41311 | 41311 | 2020-04-08 | Porter | Indiana | 18127 | 86 | 1 |
43887 | 43887 | 2020-04-09 | Porter | Indiana | 18127 | 94 | 1 |
46492 | 46492 | 2020-04-10 | Porter | Indiana | 18127 | 96 | 1 |
49126 | 49126 | 2020-04-11 | Porter | Indiana | 18127 | 108 | 2 |
51790 | 51790 | 2020-04-12 | Porter | Indiana | 18127 | 119 | 3 |
54471 | 54471 | 2020-04-13 | Porter | Indiana | 18127 | 121 | 3 |
57164 | 57164 | 2020-04-14 | Porter | Indiana | 18127 | 128 | 3 |
59872 | 59872 | 2020-04-15 | Porter | Indiana | 18127 | 131 | 3 |
62593 | 62593 | 2020-04-16 | Porter | Indiana | 18127 | 144 | 3 |
65327 | 65327 | 2020-04-17 | Porter | Indiana | 18127 | 156 | 3 |
68076 | 68076 | 2020-04-18 | Porter | Indiana | 18127 | 169 | 4 |
70838 | 70838 | 2020-04-19 | Porter | Indiana | 18127 | 176 | 4 |
73609 | 73609 | 2020-04-20 | Porter | Indiana | 18127 | 181 | 4 |
76386 | 76386 | 2020-04-21 | Porter | Indiana | 18127 | 184 | 6 |
79170 | 79170 | 2020-04-22 | Porter | Indiana | 18127 | 197 | 6 |
81963 | 81963 | 2020-04-23 | Porter | Indiana | 18127 | 202 | 6 |
84763 | 84763 | 2020-04-24 | Porter | Indiana | 18127 | 208 | 6 |
87573 | 87573 | 2020-04-25 | Porter | Indiana | 18127 | 214 | 6 |
90389 | 90389 | 2020-04-26 | Porter | Indiana | 18127 | 216 | 6 |
93208 | 93208 | 2020-04-27 | Porter | Indiana | 18127 | 219 | 6 |
96040 | 96040 | 2020-04-28 | Porter | Indiana | 18127 | 232 | 6 |
98884 | 98884 | 2020-04-29 | Porter | Indiana | 18127 | 236 | 7 |
101735 | 101735 | 2020-04-30 | Porter | Indiana | 18127 | 243 | 8 |
104591 | 104591 | 2020-05-01 | Porter | Indiana | 18127 | 245 | 8 |
107456 | 107456 | 2020-05-02 | Porter | Indiana | 18127 | 255 | 8 |
110326 | 110326 | 2020-05-03 | Porter | Indiana | 18127 | 257 | 8 |
113201 | 113201 | 2020-05-04 | Porter | Indiana | 18127 | 263 | 8 |
116084 | 116084 | 2020-05-05 | Porter | Indiana | 18127 | 271 | 8 |
119044 | 119044 | 2020-05-06 | Porter | Indiana | 18127 | 286 | 8 |
122014 | 122014 | 2020-05-07 | Porter | Indiana | 18127 | 300 | 8 |
124994 | 124994 | 2020-05-08 | Porter | Indiana | 18127 | 309 | 9 |
127981 | 127981 | 2020-05-09 | Porter | Indiana | 18127 | 315 | 10 |
130972 | 130972 | 2020-05-10 | Porter | Indiana | 18127 | 320 | 10 |
133962 | 133962 | 2020-05-11 | Porter | Indiana | 18127 | 338 | 10 |
136951 | 136951 | 2020-05-12 | Porter | Indiana | 18127 | 361 | 10 |
139943 | 139943 | 2020-05-13 | Porter | Indiana | 18127 | 370 | 10 |
142939 | 142939 | 2020-05-14 | Porter | Indiana | 18127 | 379 | 10 |
145939 | 145939 | 2020-05-15 | Porter | Indiana | 18127 | 388 | 11 |
148943 | 148943 | 2020-05-16 | Porter | Indiana | 18127 | 395 | 11 |
151952 | 151952 | 2020-05-17 | Porter | Indiana | 18127 | 401 | 11 |
154964 | 154964 | 2020-05-18 | Porter | Indiana | 18127 | 412 | 13 |
157980 | 157980 | 2020-05-19 | Porter | Indiana | 18127 | 420 | 14 |
161006 | 161006 | 2020-05-20 | Porter | Indiana | 18127 | 429 | 16 |
164034 | 164034 | 2020-05-21 | Porter | Indiana | 18127 | 433 | 20 |
167067 | 167067 | 2020-05-22 | Porter | Indiana | 18127 | 466 | 20 |
170104 | 170104 | 2020-05-23 | Porter | Indiana | 18127 | 472 | 22 |
173145 | 173145 | 2020-05-24 | Porter | Indiana | 18127 | 480 | 22 |
176189 | 176189 | 2020-05-25 | Porter | Indiana | 18127 | 494 | 22 |
179233 | 179233 | 2020-05-26 | Porter | Indiana | 18127 | 497 | 22 |
182277 | 182277 | 2020-05-27 | Porter | Indiana | 18127 | 502 | 22 |
185331 | 185331 | 2020-05-28 | Porter | Indiana | 18127 | 512 | 23 |
188389 | 188389 | 2020-05-29 | Porter | Indiana | 18127 | 523 | 28 |
191454 | 191454 | 2020-05-30 | Porter | Indiana | 18127 | 543 | 30 |
194521 | 194521 | 2020-05-31 | Porter | Indiana | 18127 | 548 | 30 |
197591 | 197591 | 2020-06-01 | Porter | Indiana | 18127 | 552 | 30 |
200664 | 200664 | 2020-06-02 | Porter | Indiana | 18127 | 556 | 31 |
203740 | 203740 | 2020-06-03 | Porter | Indiana | 18127 | 562 | 31 |
206820 | 206820 | 2020-06-04 | Porter | Indiana | 18127 | 567 | 32 |
209901 | 209901 | 2020-06-05 | Porter | Indiana | 18127 | 571 | 35 |
212986 | 212986 | 2020-06-06 | Porter | Indiana | 18127 | 573 | 35 |
216073 | 216073 | 2020-06-07 | Porter | Indiana | 18127 | 580 | 35 |
219165 | 219165 | 2020-06-08 | Porter | Indiana | 18127 | 583 | 35 |
222260 | 222260 | 2020-06-09 | Porter | Indiana | 18127 | 584 | 35 |
225355 | 225355 | 2020-06-10 | Porter | Indiana | 18127 | 585 | 35 |
228457 | 228457 | 2020-06-11 | Porter | Indiana | 18127 | 591 | 35 |
231560 | 231560 | 2020-06-12 | Porter | Indiana | 18127 | 594 | 35 |
234666 | 234666 | 2020-06-13 | Porter | Indiana | 18127 | 595 | 36 |
237773 | 237773 | 2020-06-14 | Porter | Indiana | 18127 | 596 | 36 |
240881 | 240881 | 2020-06-15 | Porter | Indiana | 18127 | 598 | 36 |
243992 | 243992 | 2020-06-16 | Porter | Indiana | 18127 | 602 | 36 |
247105 | 247105 | 2020-06-17 | Porter | Indiana | 18127 | 606 | 37 |
250217 | 250217 | 2020-06-18 | Porter | Indiana | 18127 | 615 | 38 |
253332 | 253332 | 2020-06-19 | Porter | Indiana | 18127 | 620 | 38 |
256452 | 256452 | 2020-06-20 | Porter | Indiana | 18127 | 622 | 38 |
259578 | 259578 | 2020-06-21 | Porter | Indiana | 18127 | 624 | 38 |
262705 | 262705 | 2020-06-22 | Porter | Indiana | 18127 | 630 | 38 |
265833 | 265833 | 2020-06-23 | Porter | Indiana | 18127 | 634 | 38 |
268963 | 268963 | 2020-06-24 | Porter | Indiana | 18127 | 638 | 38 |
272100 | 272100 | 2020-06-25 | Porter | Indiana | 18127 | 643 | 38 |
275242 | 275242 | 2020-06-26 | Porter | Indiana | 18127 | 662 | 38 |
278390 | 278390 | 2020-06-27 | Porter | Indiana | 18127 | 668 | 38 |
281538 | 281538 | 2020-06-28 | Porter | Indiana | 18127 | 676 | 38 |
284683 | 284683 | 2020-06-29 | Porter | Indiana | 18127 | 684 | 38 |
287832 | 287832 | 2020-06-30 | Porter | Indiana | 18127 | 688 | 38 |
290982 | 290982 | 2020-07-01 | Porter | Indiana | 18127 | 693 | 39 |
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);