ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,292 rows where county = "Hall" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
county 1
- Hall · 2,292 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2856 | 2856 | 2020-03-16 | Hall | Georgia | 13139 | 1 | 0 |
3341 | 3341 | 2020-03-17 | Hall | Georgia | 13139 | 1 | 0 |
3902 | 3902 | 2020-03-18 | Hall | Georgia | 13139 | 3 | 0 |
4575 | 4575 | 2020-03-19 | Hall | Georgia | 13139 | 5 | 0 |
5359 | 5359 | 2020-03-20 | Hall | Georgia | 13139 | 6 | 0 |
6292 | 6292 | 2020-03-21 | Hall | Georgia | 13139 | 9 | 0 |
7338 | 7338 | 2020-03-22 | Hall | Georgia | 13139 | 9 | 0 |
8486 | 8486 | 2020-03-23 | Hall | Georgia | 13139 | 10 | 0 |
9739 | 9739 | 2020-03-24 | Hall | Georgia | 13139 | 16 | 0 |
11116 | 11116 | 2020-03-25 | Hall | Georgia | 13139 | 19 | 0 |
12666 | 12666 | 2020-03-26 | Hall | Georgia | 13139 | 22 | 0 |
13272 | 13272 | 2020-03-26 | Hall | Nebraska | 31079 | 1 | 0 |
14339 | 14339 | 2020-03-27 | Hall | Georgia | 13139 | 30 | 0 |
15004 | 15004 | 2020-03-27 | Hall | Nebraska | 31079 | 2 | 1 |
16125 | 16125 | 2020-03-28 | Hall | Georgia | 13139 | 31 | 0 |
16831 | 16831 | 2020-03-28 | Hall | Nebraska | 31079 | 3 | 1 |
18022 | 18022 | 2020-03-29 | Hall | Georgia | 13139 | 33 | 0 |
18754 | 18754 | 2020-03-29 | Hall | Nebraska | 31079 | 6 | 1 |
20012 | 20012 | 2020-03-30 | Hall | Georgia | 13139 | 34 | 0 |
20790 | 20790 | 2020-03-30 | Hall | Nebraska | 31079 | 6 | 1 |
22093 | 22093 | 2020-03-31 | Hall | Georgia | 13139 | 67 | 0 |
22913 | 22913 | 2020-03-31 | Hall | Nebraska | 31079 | 9 | 1 |
24256 | 24256 | 2020-04-01 | Hall | Georgia | 13139 | 71 | 0 |
25103 | 25103 | 2020-04-01 | Hall | Nebraska | 31079 | 15 | 1 |
26487 | 26487 | 2020-04-02 | Hall | Georgia | 13139 | 72 | 0 |
27361 | 27361 | 2020-04-02 | Hall | Nebraska | 31079 | 19 | 1 |
28791 | 28791 | 2020-04-03 | Hall | Georgia | 13139 | 81 | 0 |
29684 | 29684 | 2020-04-03 | Hall | Nebraska | 31079 | 27 | 1 |
31151 | 31151 | 2020-04-04 | Hall | Georgia | 13139 | 117 | 0 |
32067 | 32067 | 2020-04-04 | Hall | Nebraska | 31079 | 40 | 1 |
33558 | 33558 | 2020-04-05 | Hall | Georgia | 13139 | 117 | 0 |
34495 | 34495 | 2020-04-05 | Hall | Nebraska | 31079 | 44 | 1 |
36007 | 36007 | 2020-04-06 | Hall | Georgia | 13139 | 138 | 0 |
36964 | 36964 | 2020-04-06 | Hall | Nebraska | 31079 | 55 | 1 |
38499 | 38499 | 2020-04-07 | Hall | Georgia | 13139 | 215 | 0 |
39480 | 39480 | 2020-04-07 | Hall | Nebraska | 31079 | 60 | 2 |
41043 | 41043 | 2020-04-08 | Hall | Georgia | 13139 | 233 | 0 |
42036 | 42036 | 2020-04-08 | Hall | Nebraska | 31079 | 69 | 2 |
43617 | 43617 | 2020-04-09 | Hall | Georgia | 13139 | 247 | 0 |
44617 | 44617 | 2020-04-09 | Hall | Nebraska | 31079 | 84 | 2 |
46219 | 46219 | 2020-04-10 | Hall | Georgia | 13139 | 273 | 0 |
47229 | 47229 | 2020-04-10 | Hall | Nebraska | 31079 | 129 | 4 |
48849 | 48849 | 2020-04-11 | Hall | Georgia | 13139 | 276 | 0 |
49879 | 49879 | 2020-04-11 | Hall | Nebraska | 31079 | 131 | 4 |
51511 | 51511 | 2020-04-12 | Hall | Georgia | 13139 | 282 | 0 |
52553 | 52553 | 2020-04-12 | Hall | Nebraska | 31079 | 161 | 4 |
54191 | 54191 | 2020-04-13 | Hall | Georgia | 13139 | 319 | 0 |
55234 | 55234 | 2020-04-13 | Hall | Nebraska | 31079 | 199 | 4 |
56883 | 56883 | 2020-04-14 | Hall | Georgia | 13139 | 363 | 0 |
57933 | 57933 | 2020-04-14 | Hall | Nebraska | 31079 | 235 | 4 |
59590 | 59590 | 2020-04-15 | Hall | Georgia | 13139 | 402 | 5 |
60647 | 60647 | 2020-04-15 | Hall | Nebraska | 31079 | 278 | 5 |
62310 | 62310 | 2020-04-16 | Hall | Georgia | 13139 | 526 | 5 |
63370 | 63370 | 2020-04-16 | Hall | Nebraska | 31079 | 339 | 5 |
65043 | 65043 | 2020-04-17 | Hall | Georgia | 13139 | 605 | 6 |
66111 | 66111 | 2020-04-17 | Hall | Nebraska | 31079 | 403 | 5 |
67791 | 67791 | 2020-04-18 | Hall | Georgia | 13139 | 607 | 6 |
68866 | 68866 | 2020-04-18 | Hall | Nebraska | 31079 | 468 | 8 |
70553 | 70553 | 2020-04-19 | Hall | Georgia | 13139 | 625 | 6 |
71633 | 71633 | 2020-04-19 | Hall | Nebraska | 31079 | 468 | 8 |
73322 | 73322 | 2020-04-20 | Hall | Georgia | 13139 | 702 | 9 |
74407 | 74407 | 2020-04-20 | Hall | Nebraska | 31079 | 531 | 10 |
76098 | 76098 | 2020-04-21 | Hall | Georgia | 13139 | 756 | 9 |
77187 | 77187 | 2020-04-21 | Hall | Nebraska | 31079 | 560 | 10 |
78882 | 78882 | 2020-04-22 | Hall | Georgia | 13139 | 907 | 9 |
79976 | 79976 | 2020-04-22 | Hall | Nebraska | 31079 | 588 | 13 |
81675 | 81675 | 2020-04-23 | Hall | Georgia | 13139 | 963 | 9 |
82773 | 82773 | 2020-04-23 | Hall | Nebraska | 31079 | 664 | 16 |
84475 | 84475 | 2020-04-24 | Hall | Georgia | 13139 | 1022 | 9 |
85578 | 85578 | 2020-04-24 | Hall | Nebraska | 31079 | 760 | 21 |
87284 | 87284 | 2020-04-25 | Hall | Georgia | 13139 | 1032 | 9 |
88388 | 88388 | 2020-04-25 | Hall | Nebraska | 31079 | 811 | 21 |
90100 | 90100 | 2020-04-26 | Hall | Georgia | 13139 | 1033 | 11 |
91203 | 91203 | 2020-04-26 | Hall | Nebraska | 31079 | 877 | 19 |
92919 | 92919 | 2020-04-27 | Hall | Georgia | 13139 | 1098 | 12 |
94025 | 94025 | 2020-04-27 | Hall | Nebraska | 31079 | 908 | 19 |
95751 | 95751 | 2020-04-28 | Hall | Georgia | 13139 | 1185 | 16 |
96861 | 96861 | 2020-04-28 | Hall | Nebraska | 31079 | 933 | 19 |
98596 | 98596 | 2020-04-29 | Hall | Georgia | 13139 | 1261 | 20 |
99708 | 99708 | 2020-04-29 | Hall | Nebraska | 31079 | 943 | 27 |
101446 | 101446 | 2020-04-30 | Hall | Georgia | 13139 | 1346 | 21 |
102560 | 102560 | 2020-04-30 | Hall | Nebraska | 31079 | 1042 | 28 |
104301 | 104301 | 2020-05-01 | Hall | Georgia | 13139 | 1482 | 22 |
105421 | 105421 | 2020-05-01 | Hall | Nebraska | 31079 | 1111 | 28 |
107166 | 107166 | 2020-05-02 | Hall | Georgia | 13139 | 1694 | 22 |
108287 | 108287 | 2020-05-02 | Hall | Nebraska | 31079 | 1160 | 28 |
110035 | 110035 | 2020-05-03 | Hall | Georgia | 13139 | 1700 | 23 |
111159 | 111159 | 2020-05-03 | Hall | Nebraska | 31079 | 1256 | 28 |
112910 | 112910 | 2020-05-04 | Hall | Georgia | 13139 | 1776 | 23 |
114039 | 114039 | 2020-05-04 | Hall | Nebraska | 31079 | 1281 | 28 |
115793 | 115793 | 2020-05-05 | Hall | Georgia | 13139 | 1846 | 26 |
116921 | 116921 | 2020-05-05 | Hall | Nebraska | 31079 | 1284 | 31 |
118753 | 118753 | 2020-05-06 | Hall | Georgia | 13139 | 1914 | 27 |
119881 | 119881 | 2020-05-06 | Hall | Nebraska | 31079 | 1290 | 31 |
121723 | 121723 | 2020-05-07 | Hall | Georgia | 13139 | 1956 | 27 |
122855 | 122855 | 2020-05-07 | Hall | Nebraska | 31079 | 1306 | 31 |
124702 | 124702 | 2020-05-08 | Hall | Georgia | 13139 | 1997 | 28 |
125837 | 125837 | 2020-05-08 | Hall | Nebraska | 31079 | 1311 | 34 |
127689 | 127689 | 2020-05-09 | Hall | Georgia | 13139 | 2002 | 28 |
128826 | 128826 | 2020-05-09 | Hall | Nebraska | 31079 | 1325 | 34 |
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);