ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,676 rows where county = "Newton" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Newton · 4,676 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
19769 | 19769 | 2020-03-30 | Newton | Arkansas | 5101 | 1 | 0 |
21842 | 21842 | 2020-03-31 | Newton | Arkansas | 5101 | 1 | 0 |
24000 | 24000 | 2020-04-01 | Newton | Arkansas | 5101 | 1 | 0 |
26226 | 26226 | 2020-04-02 | Newton | Arkansas | 5101 | 1 | 0 |
28524 | 28524 | 2020-04-03 | Newton | Arkansas | 5101 | 1 | 0 |
30882 | 30882 | 2020-04-04 | Newton | Arkansas | 5101 | 1 | 0 |
33286 | 33286 | 2020-04-05 | Newton | Arkansas | 5101 | 1 | 0 |
35730 | 35730 | 2020-04-06 | Newton | Arkansas | 5101 | 1 | 0 |
38219 | 38219 | 2020-04-07 | Newton | Arkansas | 5101 | 1 | 0 |
40763 | 40763 | 2020-04-08 | Newton | Arkansas | 5101 | 1 | 0 |
43335 | 43335 | 2020-04-09 | Newton | Arkansas | 5101 | 1 | 0 |
45935 | 45935 | 2020-04-10 | Newton | Arkansas | 5101 | 1 | 0 |
48565 | 48565 | 2020-04-11 | Newton | Arkansas | 5101 | 1 | 0 |
51227 | 51227 | 2020-04-12 | Newton | Arkansas | 5101 | 1 | 0 |
53906 | 53906 | 2020-04-13 | Newton | Arkansas | 5101 | 1 | 0 |
56598 | 56598 | 2020-04-14 | Newton | Arkansas | 5101 | 1 | 0 |
59306 | 59306 | 2020-04-15 | Newton | Arkansas | 5101 | 1 | 0 |
62025 | 62025 | 2020-04-16 | Newton | Arkansas | 5101 | 1 | 0 |
64758 | 64758 | 2020-04-17 | Newton | Arkansas | 5101 | 2 | 0 |
67506 | 67506 | 2020-04-18 | Newton | Arkansas | 5101 | 2 | 0 |
70268 | 70268 | 2020-04-19 | Newton | Arkansas | 5101 | 2 | 0 |
73037 | 73037 | 2020-04-20 | Newton | Arkansas | 5101 | 2 | 0 |
75813 | 75813 | 2020-04-21 | Newton | Arkansas | 5101 | 2 | 0 |
78597 | 78597 | 2020-04-22 | Newton | Arkansas | 5101 | 2 | 0 |
81391 | 81391 | 2020-04-23 | Newton | Arkansas | 5101 | 3 | 0 |
84191 | 84191 | 2020-04-24 | Newton | Arkansas | 5101 | 3 | 0 |
86999 | 86999 | 2020-04-25 | Newton | Arkansas | 5101 | 3 | 0 |
89816 | 89816 | 2020-04-26 | Newton | Arkansas | 5101 | 3 | 0 |
92634 | 92634 | 2020-04-27 | Newton | Arkansas | 5101 | 3 | 0 |
95465 | 95465 | 2020-04-28 | Newton | Arkansas | 5101 | 3 | 0 |
98310 | 98310 | 2020-04-29 | Newton | Arkansas | 5101 | 3 | 0 |
101160 | 101160 | 2020-04-30 | Newton | Arkansas | 5101 | 3 | 0 |
104015 | 104015 | 2020-05-01 | Newton | Arkansas | 5101 | 3 | 0 |
106880 | 106880 | 2020-05-02 | Newton | Arkansas | 5101 | 3 | 0 |
109749 | 109749 | 2020-05-03 | Newton | Arkansas | 5101 | 3 | 0 |
112624 | 112624 | 2020-05-04 | Newton | Arkansas | 5101 | 3 | 0 |
115507 | 115507 | 2020-05-05 | Newton | Arkansas | 5101 | 3 | 0 |
118466 | 118466 | 2020-05-06 | Newton | Arkansas | 5101 | 3 | 0 |
121433 | 121433 | 2020-05-07 | Newton | Arkansas | 5101 | 3 | 0 |
124413 | 124413 | 2020-05-08 | Newton | Arkansas | 5101 | 3 | 0 |
127398 | 127398 | 2020-05-09 | Newton | Arkansas | 5101 | 3 | 0 |
130388 | 130388 | 2020-05-10 | Newton | Arkansas | 5101 | 3 | 0 |
133378 | 133378 | 2020-05-11 | Newton | Arkansas | 5101 | 3 | 0 |
136368 | 136368 | 2020-05-12 | Newton | Arkansas | 5101 | 3 | 0 |
139359 | 139359 | 2020-05-13 | Newton | Arkansas | 5101 | 3 | 0 |
142355 | 142355 | 2020-05-14 | Newton | Arkansas | 5101 | 3 | 0 |
145354 | 145354 | 2020-05-15 | Newton | Arkansas | 5101 | 3 | 0 |
148358 | 148358 | 2020-05-16 | Newton | Arkansas | 5101 | 3 | 0 |
151367 | 151367 | 2020-05-17 | Newton | Arkansas | 5101 | 3 | 0 |
154379 | 154379 | 2020-05-18 | Newton | Arkansas | 5101 | 3 | 0 |
157395 | 157395 | 2020-05-19 | Newton | Arkansas | 5101 | 3 | 0 |
160421 | 160421 | 2020-05-20 | Newton | Arkansas | 5101 | 3 | 0 |
163449 | 163449 | 2020-05-21 | Newton | Arkansas | 5101 | 3 | 0 |
166481 | 166481 | 2020-05-22 | Newton | Arkansas | 5101 | 3 | 0 |
169517 | 169517 | 2020-05-23 | Newton | Arkansas | 5101 | 3 | 0 |
172558 | 172558 | 2020-05-24 | Newton | Arkansas | 5101 | 3 | 0 |
175602 | 175602 | 2020-05-25 | Newton | Arkansas | 5101 | 3 | 0 |
178646 | 178646 | 2020-05-26 | Newton | Arkansas | 5101 | 3 | 0 |
181690 | 181690 | 2020-05-27 | Newton | Arkansas | 5101 | 3 | 0 |
184744 | 184744 | 2020-05-28 | Newton | Arkansas | 5101 | 3 | 0 |
187800 | 187800 | 2020-05-29 | Newton | Arkansas | 5101 | 3 | 0 |
190865 | 190865 | 2020-05-30 | Newton | Arkansas | 5101 | 3 | 0 |
193932 | 193932 | 2020-05-31 | Newton | Arkansas | 5101 | 3 | 0 |
197002 | 197002 | 2020-06-01 | Newton | Arkansas | 5101 | 3 | 0 |
200075 | 200075 | 2020-06-02 | Newton | Arkansas | 5101 | 3 | 0 |
203151 | 203151 | 2020-06-03 | Newton | Arkansas | 5101 | 3 | 0 |
206231 | 206231 | 2020-06-04 | Newton | Arkansas | 5101 | 3 | 0 |
209312 | 209312 | 2020-06-05 | Newton | Arkansas | 5101 | 3 | 0 |
212397 | 212397 | 2020-06-06 | Newton | Arkansas | 5101 | 3 | 0 |
215484 | 215484 | 2020-06-07 | Newton | Arkansas | 5101 | 3 | 0 |
218575 | 218575 | 2020-06-08 | Newton | Arkansas | 5101 | 3 | 0 |
221670 | 221670 | 2020-06-09 | Newton | Arkansas | 5101 | 3 | 0 |
224765 | 224765 | 2020-06-10 | Newton | Arkansas | 5101 | 3 | 0 |
227867 | 227867 | 2020-06-11 | Newton | Arkansas | 5101 | 3 | 0 |
230970 | 230970 | 2020-06-12 | Newton | Arkansas | 5101 | 3 | 0 |
234076 | 234076 | 2020-06-13 | Newton | Arkansas | 5101 | 3 | 0 |
237183 | 237183 | 2020-06-14 | Newton | Arkansas | 5101 | 3 | 0 |
240291 | 240291 | 2020-06-15 | Newton | Arkansas | 5101 | 3 | 0 |
243402 | 243402 | 2020-06-16 | Newton | Arkansas | 5101 | 3 | 0 |
246515 | 246515 | 2020-06-17 | Newton | Arkansas | 5101 | 3 | 0 |
249627 | 249627 | 2020-06-18 | Newton | Arkansas | 5101 | 3 | 0 |
252742 | 252742 | 2020-06-19 | Newton | Arkansas | 5101 | 3 | 0 |
255861 | 255861 | 2020-06-20 | Newton | Arkansas | 5101 | 3 | 0 |
258988 | 258988 | 2020-06-21 | Newton | Arkansas | 5101 | 4 | 0 |
262115 | 262115 | 2020-06-22 | Newton | Arkansas | 5101 | 4 | 0 |
265243 | 265243 | 2020-06-23 | Newton | Arkansas | 5101 | 4 | 0 |
268373 | 268373 | 2020-06-24 | Newton | Arkansas | 5101 | 4 | 0 |
271508 | 271508 | 2020-06-25 | Newton | Arkansas | 5101 | 4 | 0 |
274648 | 274648 | 2020-06-26 | Newton | Arkansas | 5101 | 5 | 0 |
277796 | 277796 | 2020-06-27 | Newton | Arkansas | 5101 | 5 | 0 |
280943 | 280943 | 2020-06-28 | Newton | Arkansas | 5101 | 5 | 0 |
284089 | 284089 | 2020-06-29 | Newton | Arkansas | 5101 | 5 | 0 |
287235 | 287235 | 2020-06-30 | Newton | Arkansas | 5101 | 5 | 0 |
290386 | 290386 | 2020-07-01 | Newton | Arkansas | 5101 | 6 | 0 |
293540 | 293540 | 2020-07-02 | Newton | Arkansas | 5101 | 6 | 0 |
296696 | 296696 | 2020-07-03 | Newton | Arkansas | 5101 | 7 | 0 |
299858 | 299858 | 2020-07-04 | Newton | Arkansas | 5101 | 8 | 0 |
303022 | 303022 | 2020-07-05 | Newton | Arkansas | 5101 | 7 | 0 |
306186 | 306186 | 2020-07-06 | Newton | Arkansas | 5101 | 7 | 0 |
309354 | 309354 | 2020-07-07 | Newton | Arkansas | 5101 | 7 | 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);