ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Newton" and state = "Georgia" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
2421 | 2421 | 2020-03-15 | Newton | Georgia | 13217 | 1 | 0 |
2860 | 2860 | 2020-03-16 | Newton | Georgia | 13217 | 1 | 0 |
3345 | 3345 | 2020-03-17 | Newton | Georgia | 13217 | 1 | 0 |
3907 | 3907 | 2020-03-18 | Newton | Georgia | 13217 | 3 | 0 |
4581 | 4581 | 2020-03-19 | Newton | Georgia | 13217 | 3 | 0 |
5371 | 5371 | 2020-03-20 | Newton | Georgia | 13217 | 4 | 0 |
6305 | 6305 | 2020-03-21 | Newton | Georgia | 13217 | 4 | 0 |
7351 | 7351 | 2020-03-22 | Newton | Georgia | 13217 | 4 | 0 |
8503 | 8503 | 2020-03-23 | Newton | Georgia | 13217 | 4 | 0 |
9761 | 9761 | 2020-03-24 | Newton | Georgia | 13217 | 6 | 0 |
11141 | 11141 | 2020-03-25 | Newton | Georgia | 13217 | 8 | 0 |
12693 | 12693 | 2020-03-26 | Newton | Georgia | 13217 | 12 | 0 |
14367 | 14367 | 2020-03-27 | Newton | Georgia | 13217 | 15 | 0 |
16155 | 16155 | 2020-03-28 | Newton | Georgia | 13217 | 15 | 0 |
18052 | 18052 | 2020-03-29 | Newton | Georgia | 13217 | 18 | 0 |
20045 | 20045 | 2020-03-30 | Newton | Georgia | 13217 | 22 | 0 |
22126 | 22126 | 2020-03-31 | Newton | Georgia | 13217 | 31 | 0 |
24290 | 24290 | 2020-04-01 | Newton | Georgia | 13217 | 34 | 0 |
26521 | 26521 | 2020-04-02 | Newton | Georgia | 13217 | 37 | 0 |
28826 | 28826 | 2020-04-03 | Newton | Georgia | 13217 | 42 | 1 |
31186 | 31186 | 2020-04-04 | Newton | Georgia | 13217 | 52 | 1 |
33593 | 33593 | 2020-04-05 | Newton | Georgia | 13217 | 55 | 2 |
36043 | 36043 | 2020-04-06 | Newton | Georgia | 13217 | 65 | 2 |
38536 | 38536 | 2020-04-07 | Newton | Georgia | 13217 | 67 | 3 |
41080 | 41080 | 2020-04-08 | Newton | Georgia | 13217 | 67 | 3 |
43654 | 43654 | 2020-04-09 | Newton | Georgia | 13217 | 70 | 3 |
46256 | 46256 | 2020-04-10 | Newton | Georgia | 13217 | 77 | 3 |
48887 | 48887 | 2020-04-11 | Newton | Georgia | 13217 | 78 | 3 |
51549 | 51549 | 2020-04-12 | Newton | Georgia | 13217 | 82 | 3 |
54229 | 54229 | 2020-04-13 | Newton | Georgia | 13217 | 93 | 3 |
56921 | 56921 | 2020-04-14 | Newton | Georgia | 13217 | 100 | 3 |
59628 | 59628 | 2020-04-15 | Newton | Georgia | 13217 | 113 | 3 |
62348 | 62348 | 2020-04-16 | Newton | Georgia | 13217 | 115 | 3 |
65081 | 65081 | 2020-04-17 | Newton | Georgia | 13217 | 121 | 3 |
67829 | 67829 | 2020-04-18 | Newton | Georgia | 13217 | 121 | 3 |
70591 | 70591 | 2020-04-19 | Newton | Georgia | 13217 | 130 | 3 |
73360 | 73360 | 2020-04-20 | Newton | Georgia | 13217 | 139 | 3 |
76136 | 76136 | 2020-04-21 | Newton | Georgia | 13217 | 142 | 4 |
78920 | 78920 | 2020-04-22 | Newton | Georgia | 13217 | 146 | 5 |
81713 | 81713 | 2020-04-23 | Newton | Georgia | 13217 | 153 | 5 |
84513 | 84513 | 2020-04-24 | Newton | Georgia | 13217 | 158 | 6 |
87322 | 87322 | 2020-04-25 | Newton | Georgia | 13217 | 166 | 6 |
90138 | 90138 | 2020-04-26 | Newton | Georgia | 13217 | 166 | 6 |
92957 | 92957 | 2020-04-27 | Newton | Georgia | 13217 | 173 | 7 |
95789 | 95789 | 2020-04-28 | Newton | Georgia | 13217 | 184 | 7 |
98634 | 98634 | 2020-04-29 | Newton | Georgia | 13217 | 193 | 7 |
101484 | 101484 | 2020-04-30 | Newton | Georgia | 13217 | 196 | 7 |
104339 | 104339 | 2020-05-01 | Newton | Georgia | 13217 | 200 | 7 |
107204 | 107204 | 2020-05-02 | Newton | Georgia | 13217 | 205 | 7 |
110073 | 110073 | 2020-05-03 | Newton | Georgia | 13217 | 208 | 7 |
112948 | 112948 | 2020-05-04 | Newton | Georgia | 13217 | 215 | 8 |
115831 | 115831 | 2020-05-05 | Newton | Georgia | 13217 | 222 | 8 |
118791 | 118791 | 2020-05-06 | Newton | Georgia | 13217 | 232 | 8 |
121761 | 121761 | 2020-05-07 | Newton | Georgia | 13217 | 236 | 8 |
124740 | 124740 | 2020-05-08 | Newton | Georgia | 13217 | 240 | 8 |
127727 | 127727 | 2020-05-09 | Newton | Georgia | 13217 | 252 | 8 |
151697 | 151697 | 2020-05-17 | Newton | Georgia | 13217 | 257 | 10 |
130718 | 130718 | 2020-05-10 | Newton | Georgia | 13217 | 258 | 8 |
133709 | 133709 | 2020-05-11 | Newton | Georgia | 13217 | 260 | 8 |
136698 | 136698 | 2020-05-12 | Newton | Georgia | 13217 | 261 | 8 |
148688 | 148688 | 2020-05-16 | Newton | Georgia | 13217 | 261 | 10 |
139689 | 139689 | 2020-05-13 | Newton | Georgia | 13217 | 262 | 8 |
145685 | 145685 | 2020-05-15 | Newton | Georgia | 13217 | 262 | 9 |
142685 | 142685 | 2020-05-14 | Newton | Georgia | 13217 | 263 | 8 |
154709 | 154709 | 2020-05-18 | Newton | Georgia | 13217 | 264 | 10 |
157725 | 157725 | 2020-05-19 | Newton | Georgia | 13217 | 266 | 10 |
160751 | 160751 | 2020-05-20 | Newton | Georgia | 13217 | 275 | 10 |
163779 | 163779 | 2020-05-21 | Newton | Georgia | 13217 | 280 | 11 |
166812 | 166812 | 2020-05-22 | Newton | Georgia | 13217 | 286 | 11 |
169849 | 169849 | 2020-05-23 | Newton | Georgia | 13217 | 289 | 10 |
172890 | 172890 | 2020-05-24 | Newton | Georgia | 13217 | 304 | 10 |
175933 | 175933 | 2020-05-25 | Newton | Georgia | 13217 | 311 | 10 |
178977 | 178977 | 2020-05-26 | Newton | Georgia | 13217 | 335 | 11 |
182021 | 182021 | 2020-05-27 | Newton | Georgia | 13217 | 341 | 11 |
185075 | 185075 | 2020-05-28 | Newton | Georgia | 13217 | 344 | 11 |
188131 | 188131 | 2020-05-29 | Newton | Georgia | 13217 | 351 | 11 |
191196 | 191196 | 2020-05-30 | Newton | Georgia | 13217 | 352 | 11 |
194263 | 194263 | 2020-05-31 | Newton | Georgia | 13217 | 352 | 11 |
197333 | 197333 | 2020-06-01 | Newton | Georgia | 13217 | 361 | 11 |
200406 | 200406 | 2020-06-02 | Newton | Georgia | 13217 | 370 | 11 |
203482 | 203482 | 2020-06-03 | Newton | Georgia | 13217 | 376 | 11 |
206562 | 206562 | 2020-06-04 | Newton | Georgia | 13217 | 382 | 11 |
209643 | 209643 | 2020-06-05 | Newton | Georgia | 13217 | 388 | 10 |
212728 | 212728 | 2020-06-06 | Newton | Georgia | 13217 | 389 | 10 |
215815 | 215815 | 2020-06-07 | Newton | Georgia | 13217 | 389 | 10 |
218906 | 218906 | 2020-06-08 | Newton | Georgia | 13217 | 395 | 10 |
222001 | 222001 | 2020-06-09 | Newton | Georgia | 13217 | 396 | 11 |
225096 | 225096 | 2020-06-10 | Newton | Georgia | 13217 | 402 | 11 |
228198 | 228198 | 2020-06-11 | Newton | Georgia | 13217 | 407 | 11 |
231301 | 231301 | 2020-06-12 | Newton | Georgia | 13217 | 412 | 11 |
234407 | 234407 | 2020-06-13 | Newton | Georgia | 13217 | 415 | 11 |
237514 | 237514 | 2020-06-14 | Newton | Georgia | 13217 | 415 | 11 |
240622 | 240622 | 2020-06-15 | Newton | Georgia | 13217 | 420 | 11 |
243733 | 243733 | 2020-06-16 | Newton | Georgia | 13217 | 425 | 11 |
246846 | 246846 | 2020-06-17 | Newton | Georgia | 13217 | 440 | 11 |
249958 | 249958 | 2020-06-18 | Newton | Georgia | 13217 | 452 | 11 |
253073 | 253073 | 2020-06-19 | Newton | Georgia | 13217 | 466 | 11 |
256192 | 256192 | 2020-06-20 | Newton | Georgia | 13217 | 466 | 11 |
259319 | 259319 | 2020-06-21 | Newton | Georgia | 13217 | 474 | 11 |
262446 | 262446 | 2020-06-22 | Newton | Georgia | 13217 | 493 | 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);