ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Hall" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
322345 | 322345 | 2020-07-11 | Hall | Georgia | 13139 | 3774 | 63 |
319166 | 319166 | 2020-07-10 | Hall | Georgia | 13139 | 3713 | 63 |
315993 | 315993 | 2020-07-09 | Hall | Georgia | 13139 | 3620 | 63 |
312818 | 312818 | 2020-07-08 | Hall | Georgia | 13139 | 3573 | 63 |
309648 | 309648 | 2020-07-07 | Hall | Georgia | 13139 | 3475 | 62 |
306480 | 306480 | 2020-07-06 | Hall | Georgia | 13139 | 3419 | 63 |
303316 | 303316 | 2020-07-05 | Hall | Georgia | 13139 | 3404 | 60 |
300152 | 300152 | 2020-07-04 | Hall | Georgia | 13139 | 3395 | 60 |
296990 | 296990 | 2020-07-03 | Hall | Georgia | 13139 | 3357 | 60 |
293834 | 293834 | 2020-07-02 | Hall | Georgia | 13139 | 3310 | 60 |
290680 | 290680 | 2020-07-01 | Hall | Georgia | 13139 | 3252 | 60 |
287529 | 287529 | 2020-06-30 | Hall | Georgia | 13139 | 3187 | 60 |
284383 | 284383 | 2020-06-29 | Hall | Georgia | 13139 | 3138 | 59 |
281237 | 281237 | 2020-06-28 | Hall | Georgia | 13139 | 3117 | 59 |
278090 | 278090 | 2020-06-27 | Hall | Georgia | 13139 | 3101 | 59 |
274942 | 274942 | 2020-06-26 | Hall | Georgia | 13139 | 3075 | 59 |
271802 | 271802 | 2020-06-25 | Hall | Georgia | 13139 | 3048 | 59 |
268666 | 268666 | 2020-06-24 | Hall | Georgia | 13139 | 3032 | 58 |
265536 | 265536 | 2020-06-23 | Hall | Georgia | 13139 | 2982 | 58 |
262408 | 262408 | 2020-06-22 | Hall | Georgia | 13139 | 2946 | 58 |
259281 | 259281 | 2020-06-21 | Hall | Georgia | 13139 | 2935 | 58 |
256154 | 256154 | 2020-06-20 | Hall | Georgia | 13139 | 2922 | 58 |
253035 | 253035 | 2020-06-19 | Hall | Georgia | 13139 | 2901 | 58 |
249920 | 249920 | 2020-06-18 | Hall | Georgia | 13139 | 2874 | 58 |
246808 | 246808 | 2020-06-17 | Hall | Georgia | 13139 | 2822 | 58 |
243695 | 243695 | 2020-06-16 | Hall | Georgia | 13139 | 2787 | 56 |
240584 | 240584 | 2020-06-15 | Hall | Georgia | 13139 | 2755 | 55 |
237476 | 237476 | 2020-06-14 | Hall | Georgia | 13139 | 2747 | 55 |
234369 | 234369 | 2020-06-13 | Hall | Georgia | 13139 | 2740 | 55 |
231263 | 231263 | 2020-06-12 | Hall | Georgia | 13139 | 2727 | 55 |
228160 | 228160 | 2020-06-11 | Hall | Georgia | 13139 | 2699 | 54 |
225058 | 225058 | 2020-06-10 | Hall | Georgia | 13139 | 2686 | 52 |
221963 | 221963 | 2020-06-09 | Hall | Georgia | 13139 | 2664 | 51 |
218868 | 218868 | 2020-06-08 | Hall | Georgia | 13139 | 2642 | 50 |
215777 | 215777 | 2020-06-07 | Hall | Georgia | 13139 | 2616 | 50 |
212690 | 212690 | 2020-06-06 | Hall | Georgia | 13139 | 2615 | 50 |
209605 | 209605 | 2020-06-05 | Hall | Georgia | 13139 | 2596 | 50 |
206524 | 206524 | 2020-06-04 | Hall | Georgia | 13139 | 2566 | 50 |
203444 | 203444 | 2020-06-03 | Hall | Georgia | 13139 | 2539 | 50 |
200368 | 200368 | 2020-06-02 | Hall | Georgia | 13139 | 2508 | 50 |
197295 | 197295 | 2020-06-01 | Hall | Georgia | 13139 | 2507 | 49 |
194225 | 194225 | 2020-05-31 | Hall | Georgia | 13139 | 2467 | 47 |
191158 | 191158 | 2020-05-30 | Hall | Georgia | 13139 | 2467 | 47 |
188093 | 188093 | 2020-05-29 | Hall | Georgia | 13139 | 2465 | 47 |
185037 | 185037 | 2020-05-28 | Hall | Georgia | 13139 | 2450 | 46 |
181983 | 181983 | 2020-05-27 | Hall | Georgia | 13139 | 2422 | 42 |
178939 | 178939 | 2020-05-26 | Hall | Georgia | 13139 | 2378 | 41 |
175895 | 175895 | 2020-05-25 | Hall | Georgia | 13139 | 2327 | 41 |
172852 | 172852 | 2020-05-24 | Hall | Georgia | 13139 | 2322 | 41 |
169811 | 169811 | 2020-05-23 | Hall | Georgia | 13139 | 2305 | 41 |
166774 | 166774 | 2020-05-22 | Hall | Georgia | 13139 | 2269 | 41 |
163741 | 163741 | 2020-05-21 | Hall | Georgia | 13139 | 2248 | 41 |
160713 | 160713 | 2020-05-20 | Hall | Georgia | 13139 | 2230 | 40 |
157687 | 157687 | 2020-05-19 | Hall | Georgia | 13139 | 2191 | 40 |
154671 | 154671 | 2020-05-18 | Hall | Georgia | 13139 | 2164 | 42 |
151659 | 151659 | 2020-05-17 | Hall | Georgia | 13139 | 2150 | 40 |
148650 | 148650 | 2020-05-16 | Hall | Georgia | 13139 | 2146 | 40 |
145647 | 145647 | 2020-05-15 | Hall | Georgia | 13139 | 2140 | 40 |
142647 | 142647 | 2020-05-14 | Hall | Georgia | 13139 | 2125 | 40 |
139651 | 139651 | 2020-05-13 | Hall | Georgia | 13139 | 2112 | 37 |
136660 | 136660 | 2020-05-12 | Hall | Georgia | 13139 | 2060 | 35 |
133671 | 133671 | 2020-05-11 | Hall | Georgia | 13139 | 2039 | 29 |
130680 | 130680 | 2020-05-10 | Hall | Georgia | 13139 | 2012 | 28 |
127689 | 127689 | 2020-05-09 | Hall | Georgia | 13139 | 2002 | 28 |
124702 | 124702 | 2020-05-08 | Hall | Georgia | 13139 | 1997 | 28 |
121723 | 121723 | 2020-05-07 | Hall | Georgia | 13139 | 1956 | 27 |
118753 | 118753 | 2020-05-06 | Hall | Georgia | 13139 | 1914 | 27 |
115793 | 115793 | 2020-05-05 | Hall | Georgia | 13139 | 1846 | 26 |
112910 | 112910 | 2020-05-04 | Hall | Georgia | 13139 | 1776 | 23 |
110035 | 110035 | 2020-05-03 | Hall | Georgia | 13139 | 1700 | 23 |
107166 | 107166 | 2020-05-02 | Hall | Georgia | 13139 | 1694 | 22 |
104301 | 104301 | 2020-05-01 | Hall | Georgia | 13139 | 1482 | 22 |
101446 | 101446 | 2020-04-30 | Hall | Georgia | 13139 | 1346 | 21 |
98596 | 98596 | 2020-04-29 | Hall | Georgia | 13139 | 1261 | 20 |
95751 | 95751 | 2020-04-28 | Hall | Georgia | 13139 | 1185 | 16 |
92919 | 92919 | 2020-04-27 | Hall | Georgia | 13139 | 1098 | 12 |
90100 | 90100 | 2020-04-26 | Hall | Georgia | 13139 | 1033 | 11 |
87284 | 87284 | 2020-04-25 | Hall | Georgia | 13139 | 1032 | 9 |
84475 | 84475 | 2020-04-24 | Hall | Georgia | 13139 | 1022 | 9 |
81675 | 81675 | 2020-04-23 | Hall | Georgia | 13139 | 963 | 9 |
78882 | 78882 | 2020-04-22 | Hall | Georgia | 13139 | 907 | 9 |
76098 | 76098 | 2020-04-21 | Hall | Georgia | 13139 | 756 | 9 |
73322 | 73322 | 2020-04-20 | Hall | Georgia | 13139 | 702 | 9 |
70553 | 70553 | 2020-04-19 | Hall | Georgia | 13139 | 625 | 6 |
67791 | 67791 | 2020-04-18 | Hall | Georgia | 13139 | 607 | 6 |
65043 | 65043 | 2020-04-17 | Hall | Georgia | 13139 | 605 | 6 |
62310 | 62310 | 2020-04-16 | Hall | Georgia | 13139 | 526 | 5 |
59590 | 59590 | 2020-04-15 | Hall | Georgia | 13139 | 402 | 5 |
56883 | 56883 | 2020-04-14 | Hall | Georgia | 13139 | 363 | 0 |
54191 | 54191 | 2020-04-13 | Hall | Georgia | 13139 | 319 | 0 |
51511 | 51511 | 2020-04-12 | Hall | Georgia | 13139 | 282 | 0 |
48849 | 48849 | 2020-04-11 | Hall | Georgia | 13139 | 276 | 0 |
46219 | 46219 | 2020-04-10 | Hall | Georgia | 13139 | 273 | 0 |
43617 | 43617 | 2020-04-09 | Hall | Georgia | 13139 | 247 | 0 |
41043 | 41043 | 2020-04-08 | Hall | Georgia | 13139 | 233 | 0 |
38499 | 38499 | 2020-04-07 | Hall | Georgia | 13139 | 215 | 0 |
36007 | 36007 | 2020-04-06 | Hall | Georgia | 13139 | 138 | 0 |
33558 | 33558 | 2020-04-05 | Hall | Georgia | 13139 | 117 | 0 |
31151 | 31151 | 2020-04-04 | Hall | Georgia | 13139 | 117 | 0 |
28791 | 28791 | 2020-04-03 | Hall | Georgia | 13139 | 81 | 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);