ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Newton" and state = "Indiana" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
16305 | 16305 | 2020-03-28 | Newton | Indiana | 18111 | 1 | 0 |
18209 | 18209 | 2020-03-29 | Newton | Indiana | 18111 | 1 | 0 |
20215 | 20215 | 2020-03-30 | Newton | Indiana | 18111 | 1 | 0 |
22310 | 22310 | 2020-03-31 | Newton | Indiana | 18111 | 1 | 0 |
24481 | 24481 | 2020-04-01 | Newton | Indiana | 18111 | 1 | 0 |
26720 | 26720 | 2020-04-02 | Newton | Indiana | 18111 | 1 | 0 |
29030 | 29030 | 2020-04-03 | Newton | Indiana | 18111 | 1 | 0 |
31397 | 31397 | 2020-04-04 | Newton | Indiana | 18111 | 1 | 0 |
33808 | 33808 | 2020-04-05 | Newton | Indiana | 18111 | 4 | 0 |
36261 | 36261 | 2020-04-06 | Newton | Indiana | 18111 | 4 | 1 |
38759 | 38759 | 2020-04-07 | Newton | Indiana | 18111 | 6 | 1 |
41305 | 41305 | 2020-04-08 | Newton | Indiana | 18111 | 6 | 1 |
43881 | 43881 | 2020-04-09 | Newton | Indiana | 18111 | 6 | 1 |
46485 | 46485 | 2020-04-10 | Newton | Indiana | 18111 | 7 | 1 |
49119 | 49119 | 2020-04-11 | Newton | Indiana | 18111 | 9 | 1 |
51782 | 51782 | 2020-04-12 | Newton | Indiana | 18111 | 26 | 1 |
54463 | 54463 | 2020-04-13 | Newton | Indiana | 18111 | 27 | 1 |
57156 | 57156 | 2020-04-14 | Newton | Indiana | 18111 | 30 | 2 |
59864 | 59864 | 2020-04-15 | Newton | Indiana | 18111 | 30 | 3 |
62585 | 62585 | 2020-04-16 | Newton | Indiana | 18111 | 30 | 4 |
65319 | 65319 | 2020-04-17 | Newton | Indiana | 18111 | 30 | 5 |
68068 | 68068 | 2020-04-18 | Newton | Indiana | 18111 | 32 | 5 |
70830 | 70830 | 2020-04-19 | Newton | Indiana | 18111 | 32 | 5 |
73601 | 73601 | 2020-04-20 | Newton | Indiana | 18111 | 32 | 5 |
76378 | 76378 | 2020-04-21 | Newton | Indiana | 18111 | 34 | 5 |
79162 | 79162 | 2020-04-22 | Newton | Indiana | 18111 | 39 | 5 |
81955 | 81955 | 2020-04-23 | Newton | Indiana | 18111 | 41 | 6 |
84755 | 84755 | 2020-04-24 | Newton | Indiana | 18111 | 41 | 6 |
87565 | 87565 | 2020-04-25 | Newton | Indiana | 18111 | 45 | 6 |
90381 | 90381 | 2020-04-26 | Newton | Indiana | 18111 | 47 | 6 |
93200 | 93200 | 2020-04-27 | Newton | Indiana | 18111 | 48 | 7 |
96032 | 96032 | 2020-04-28 | Newton | Indiana | 18111 | 48 | 7 |
98876 | 98876 | 2020-04-29 | Newton | Indiana | 18111 | 48 | 7 |
101727 | 101727 | 2020-04-30 | Newton | Indiana | 18111 | 48 | 7 |
104583 | 104583 | 2020-05-01 | Newton | Indiana | 18111 | 62 | 8 |
107448 | 107448 | 2020-05-02 | Newton | Indiana | 18111 | 63 | 10 |
110318 | 110318 | 2020-05-03 | Newton | Indiana | 18111 | 63 | 10 |
113193 | 113193 | 2020-05-04 | Newton | Indiana | 18111 | 64 | 10 |
116076 | 116076 | 2020-05-05 | Newton | Indiana | 18111 | 63 | 10 |
119036 | 119036 | 2020-05-06 | Newton | Indiana | 18111 | 63 | 10 |
122006 | 122006 | 2020-05-07 | Newton | Indiana | 18111 | 63 | 10 |
124986 | 124986 | 2020-05-08 | Newton | Indiana | 18111 | 66 | 10 |
127973 | 127973 | 2020-05-09 | Newton | Indiana | 18111 | 66 | 10 |
130964 | 130964 | 2020-05-10 | Newton | Indiana | 18111 | 66 | 10 |
133954 | 133954 | 2020-05-11 | Newton | Indiana | 18111 | 66 | 10 |
136943 | 136943 | 2020-05-12 | Newton | Indiana | 18111 | 69 | 10 |
139935 | 139935 | 2020-05-13 | Newton | Indiana | 18111 | 69 | 10 |
142931 | 142931 | 2020-05-14 | Newton | Indiana | 18111 | 69 | 10 |
145931 | 145931 | 2020-05-15 | Newton | Indiana | 18111 | 72 | 10 |
148935 | 148935 | 2020-05-16 | Newton | Indiana | 18111 | 72 | 10 |
151944 | 151944 | 2020-05-17 | Newton | Indiana | 18111 | 72 | 10 |
154956 | 154956 | 2020-05-18 | Newton | Indiana | 18111 | 72 | 10 |
157972 | 157972 | 2020-05-19 | Newton | Indiana | 18111 | 72 | 10 |
160998 | 160998 | 2020-05-20 | Newton | Indiana | 18111 | 72 | 10 |
164026 | 164026 | 2020-05-21 | Newton | Indiana | 18111 | 73 | 11 |
167059 | 167059 | 2020-05-22 | Newton | Indiana | 18111 | 73 | 11 |
170096 | 170096 | 2020-05-23 | Newton | Indiana | 18111 | 73 | 11 |
173137 | 173137 | 2020-05-24 | Newton | Indiana | 18111 | 75 | 11 |
176181 | 176181 | 2020-05-25 | Newton | Indiana | 18111 | 75 | 11 |
179225 | 179225 | 2020-05-26 | Newton | Indiana | 18111 | 75 | 11 |
182269 | 182269 | 2020-05-27 | Newton | Indiana | 18111 | 75 | 11 |
185323 | 185323 | 2020-05-28 | Newton | Indiana | 18111 | 77 | 11 |
188381 | 188381 | 2020-05-29 | Newton | Indiana | 18111 | 78 | 11 |
191446 | 191446 | 2020-05-30 | Newton | Indiana | 18111 | 78 | 11 |
194513 | 194513 | 2020-05-31 | Newton | Indiana | 18111 | 79 | 11 |
197583 | 197583 | 2020-06-01 | Newton | Indiana | 18111 | 79 | 11 |
200656 | 200656 | 2020-06-02 | Newton | Indiana | 18111 | 79 | 11 |
203732 | 203732 | 2020-06-03 | Newton | Indiana | 18111 | 79 | 11 |
206812 | 206812 | 2020-06-04 | Newton | Indiana | 18111 | 79 | 11 |
209893 | 209893 | 2020-06-05 | Newton | Indiana | 18111 | 81 | 11 |
212978 | 212978 | 2020-06-06 | Newton | Indiana | 18111 | 82 | 11 |
216065 | 216065 | 2020-06-07 | Newton | Indiana | 18111 | 82 | 11 |
219157 | 219157 | 2020-06-08 | Newton | Indiana | 18111 | 82 | 11 |
222252 | 222252 | 2020-06-09 | Newton | Indiana | 18111 | 82 | 11 |
225347 | 225347 | 2020-06-10 | Newton | Indiana | 18111 | 83 | 11 |
228449 | 228449 | 2020-06-11 | Newton | Indiana | 18111 | 87 | 11 |
231552 | 231552 | 2020-06-12 | Newton | Indiana | 18111 | 88 | 11 |
234658 | 234658 | 2020-06-13 | Newton | Indiana | 18111 | 88 | 11 |
237765 | 237765 | 2020-06-14 | Newton | Indiana | 18111 | 88 | 11 |
240873 | 240873 | 2020-06-15 | Newton | Indiana | 18111 | 89 | 11 |
243984 | 243984 | 2020-06-16 | Newton | Indiana | 18111 | 89 | 11 |
247097 | 247097 | 2020-06-17 | Newton | Indiana | 18111 | 89 | 11 |
250209 | 250209 | 2020-06-18 | Newton | Indiana | 18111 | 89 | 11 |
253324 | 253324 | 2020-06-19 | Newton | Indiana | 18111 | 88 | 11 |
256444 | 256444 | 2020-06-20 | Newton | Indiana | 18111 | 89 | 11 |
259570 | 259570 | 2020-06-21 | Newton | Indiana | 18111 | 89 | 11 |
262697 | 262697 | 2020-06-22 | Newton | Indiana | 18111 | 90 | 11 |
265825 | 265825 | 2020-06-23 | Newton | Indiana | 18111 | 90 | 11 |
268955 | 268955 | 2020-06-24 | Newton | Indiana | 18111 | 91 | 11 |
272092 | 272092 | 2020-06-25 | Newton | Indiana | 18111 | 91 | 11 |
275234 | 275234 | 2020-06-26 | Newton | Indiana | 18111 | 91 | 11 |
278382 | 278382 | 2020-06-27 | Newton | Indiana | 18111 | 92 | 11 |
281530 | 281530 | 2020-06-28 | Newton | Indiana | 18111 | 94 | 11 |
284675 | 284675 | 2020-06-29 | Newton | Indiana | 18111 | 94 | 11 |
287824 | 287824 | 2020-06-30 | Newton | Indiana | 18111 | 95 | 11 |
290974 | 290974 | 2020-07-01 | Newton | Indiana | 18111 | 96 | 11 |
294128 | 294128 | 2020-07-02 | Newton | Indiana | 18111 | 97 | 11 |
297286 | 297286 | 2020-07-03 | Newton | Indiana | 18111 | 98 | 11 |
300448 | 300448 | 2020-07-04 | Newton | Indiana | 18111 | 99 | 11 |
303612 | 303612 | 2020-07-05 | Newton | Indiana | 18111 | 99 | 11 |
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);