ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Newton" and fips = 48351 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
25804 | 25804 | 2020-04-01 | Newton | Texas | 48351 | 1 | 0 |
28090 | 28090 | 2020-04-02 | Newton | Texas | 48351 | 1 | 0 |
30426 | 30426 | 2020-04-03 | Newton | Texas | 48351 | 1 | 0 |
32822 | 32822 | 2020-04-04 | Newton | Texas | 48351 | 1 | 0 |
35260 | 35260 | 2020-04-05 | Newton | Texas | 48351 | 1 | 0 |
37736 | 37736 | 2020-04-06 | Newton | Texas | 48351 | 1 | 0 |
40265 | 40265 | 2020-04-07 | Newton | Texas | 48351 | 1 | 0 |
42833 | 42833 | 2020-04-08 | Newton | Texas | 48351 | 1 | 0 |
45425 | 45425 | 2020-04-09 | Newton | Texas | 48351 | 1 | 0 |
48046 | 48046 | 2020-04-10 | Newton | Texas | 48351 | 1 | 0 |
50704 | 50704 | 2020-04-11 | Newton | Texas | 48351 | 2 | 0 |
53379 | 53379 | 2020-04-12 | Newton | Texas | 48351 | 2 | 0 |
56068 | 56068 | 2020-04-13 | Newton | Texas | 48351 | 2 | 0 |
58773 | 58773 | 2020-04-14 | Newton | Texas | 48351 | 2 | 0 |
61491 | 61491 | 2020-04-15 | Newton | Texas | 48351 | 2 | 0 |
64220 | 64220 | 2020-04-16 | Newton | Texas | 48351 | 2 | 0 |
66967 | 66967 | 2020-04-17 | Newton | Texas | 48351 | 2 | 0 |
69727 | 69727 | 2020-04-18 | Newton | Texas | 48351 | 2 | 0 |
72496 | 72496 | 2020-04-19 | Newton | Texas | 48351 | 2 | 0 |
75272 | 75272 | 2020-04-20 | Newton | Texas | 48351 | 2 | 0 |
78054 | 78054 | 2020-04-21 | Newton | Texas | 48351 | 2 | 0 |
80845 | 80845 | 2020-04-22 | Newton | Texas | 48351 | 2 | 0 |
83646 | 83646 | 2020-04-23 | Newton | Texas | 48351 | 2 | 0 |
86451 | 86451 | 2020-04-24 | Newton | Texas | 48351 | 2 | 0 |
89266 | 89266 | 2020-04-25 | Newton | Texas | 48351 | 2 | 0 |
92083 | 92083 | 2020-04-26 | Newton | Texas | 48351 | 2 | 0 |
94912 | 94912 | 2020-04-27 | Newton | Texas | 48351 | 2 | 0 |
97753 | 97753 | 2020-04-28 | Newton | Texas | 48351 | 2 | 0 |
100603 | 100603 | 2020-04-29 | Newton | Texas | 48351 | 2 | 0 |
103458 | 103458 | 2020-04-30 | Newton | Texas | 48351 | 2 | 0 |
106322 | 106322 | 2020-05-01 | Newton | Texas | 48351 | 2 | 0 |
109191 | 109191 | 2020-05-02 | Newton | Texas | 48351 | 2 | 0 |
112065 | 112065 | 2020-05-03 | Newton | Texas | 48351 | 2 | 0 |
114947 | 114947 | 2020-05-04 | Newton | Texas | 48351 | 2 | 0 |
117906 | 117906 | 2020-05-05 | Newton | Texas | 48351 | 2 | 0 |
120870 | 120870 | 2020-05-06 | Newton | Texas | 48351 | 4 | 0 |
123849 | 123849 | 2020-05-07 | Newton | Texas | 48351 | 4 | 0 |
126833 | 126833 | 2020-05-08 | Newton | Texas | 48351 | 4 | 0 |
129822 | 129822 | 2020-05-09 | Newton | Texas | 48351 | 4 | 0 |
132812 | 132812 | 2020-05-10 | Newton | Texas | 48351 | 4 | 0 |
135803 | 135803 | 2020-05-11 | Newton | Texas | 48351 | 4 | 0 |
138793 | 138793 | 2020-05-12 | Newton | Texas | 48351 | 4 | 0 |
141789 | 141789 | 2020-05-13 | Newton | Texas | 48351 | 4 | 0 |
144786 | 144786 | 2020-05-14 | Newton | Texas | 48351 | 4 | 0 |
147790 | 147790 | 2020-05-15 | Newton | Texas | 48351 | 4 | 0 |
150798 | 150798 | 2020-05-16 | Newton | Texas | 48351 | 4 | 0 |
153809 | 153809 | 2020-05-17 | Newton | Texas | 48351 | 4 | 0 |
156826 | 156826 | 2020-05-18 | Newton | Texas | 48351 | 4 | 0 |
159849 | 159849 | 2020-05-19 | Newton | Texas | 48351 | 4 | 0 |
162877 | 162877 | 2020-05-20 | Newton | Texas | 48351 | 4 | 0 |
165906 | 165906 | 2020-05-21 | Newton | Texas | 48351 | 4 | 0 |
168942 | 168942 | 2020-05-22 | Newton | Texas | 48351 | 4 | 0 |
171982 | 171982 | 2020-05-23 | Newton | Texas | 48351 | 4 | 0 |
175025 | 175025 | 2020-05-24 | Newton | Texas | 48351 | 4 | 0 |
178069 | 178069 | 2020-05-25 | Newton | Texas | 48351 | 4 | 0 |
181113 | 181113 | 2020-05-26 | Newton | Texas | 48351 | 4 | 0 |
184163 | 184163 | 2020-05-27 | Newton | Texas | 48351 | 4 | 0 |
187220 | 187220 | 2020-05-28 | Newton | Texas | 48351 | 4 | 0 |
190284 | 190284 | 2020-05-29 | Newton | Texas | 48351 | 4 | 0 |
193350 | 193350 | 2020-05-30 | Newton | Texas | 48351 | 5 | 0 |
196420 | 196420 | 2020-05-31 | Newton | Texas | 48351 | 5 | 0 |
199493 | 199493 | 2020-06-01 | Newton | Texas | 48351 | 5 | 0 |
202569 | 202569 | 2020-06-02 | Newton | Texas | 48351 | 5 | 0 |
205648 | 205648 | 2020-06-03 | Newton | Texas | 48351 | 5 | 0 |
208730 | 208730 | 2020-06-04 | Newton | Texas | 48351 | 5 | 0 |
211814 | 211814 | 2020-06-05 | Newton | Texas | 48351 | 5 | 0 |
214901 | 214901 | 2020-06-06 | Newton | Texas | 48351 | 6 | 0 |
217991 | 217991 | 2020-06-07 | Newton | Texas | 48351 | 6 | 0 |
221083 | 221083 | 2020-06-08 | Newton | Texas | 48351 | 6 | 0 |
224178 | 224178 | 2020-06-09 | Newton | Texas | 48351 | 6 | 0 |
227278 | 227278 | 2020-06-10 | Newton | Texas | 48351 | 6 | 0 |
230382 | 230382 | 2020-06-11 | Newton | Texas | 48351 | 6 | 0 |
233486 | 233486 | 2020-06-12 | Newton | Texas | 48351 | 6 | 0 |
236592 | 236592 | 2020-06-13 | Newton | Texas | 48351 | 6 | 0 |
239700 | 239700 | 2020-06-14 | Newton | Texas | 48351 | 6 | 0 |
242810 | 242810 | 2020-06-15 | Newton | Texas | 48351 | 6 | 0 |
245922 | 245922 | 2020-06-16 | Newton | Texas | 48351 | 6 | 0 |
249035 | 249035 | 2020-06-17 | Newton | Texas | 48351 | 6 | 0 |
252150 | 252150 | 2020-06-18 | Newton | Texas | 48351 | 6 | 0 |
255265 | 255265 | 2020-06-19 | Newton | Texas | 48351 | 6 | 0 |
258392 | 258392 | 2020-06-20 | Newton | Texas | 48351 | 6 | 0 |
261519 | 261519 | 2020-06-21 | Newton | Texas | 48351 | 8 | 0 |
264648 | 264648 | 2020-06-22 | Newton | Texas | 48351 | 11 | 0 |
267776 | 267776 | 2020-06-23 | Newton | Texas | 48351 | 11 | 0 |
270910 | 270910 | 2020-06-24 | Newton | Texas | 48351 | 12 | 0 |
274050 | 274050 | 2020-06-25 | Newton | Texas | 48351 | 12 | 0 |
277198 | 277198 | 2020-06-26 | Newton | Texas | 48351 | 12 | 0 |
280346 | 280346 | 2020-06-27 | Newton | Texas | 48351 | 12 | 0 |
283492 | 283492 | 2020-06-28 | Newton | Texas | 48351 | 12 | 0 |
286638 | 286638 | 2020-06-29 | Newton | Texas | 48351 | 12 | 0 |
289788 | 289788 | 2020-06-30 | Newton | Texas | 48351 | 12 | 0 |
292941 | 292941 | 2020-07-01 | Newton | Texas | 48351 | 12 | 0 |
296096 | 296096 | 2020-07-02 | Newton | Texas | 48351 | 12 | 0 |
299257 | 299257 | 2020-07-03 | Newton | Texas | 48351 | 12 | 0 |
302421 | 302421 | 2020-07-04 | Newton | Texas | 48351 | 12 | 0 |
305585 | 305585 | 2020-07-05 | Newton | Texas | 48351 | 12 | 0 |
308753 | 308753 | 2020-07-06 | Newton | Texas | 48351 | 12 | 0 |
311922 | 311922 | 2020-07-07 | Newton | Texas | 48351 | 12 | 0 |
315096 | 315096 | 2020-07-08 | Newton | Texas | 48351 | 12 | 0 |
318269 | 318269 | 2020-07-09 | Newton | Texas | 48351 | 12 | 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);