ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Lanier" and state = "Georgia" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
24271 | 24271 | 2020-04-01 | Lanier | Georgia | 13173 | 1 | 0 |
26502 | 26502 | 2020-04-02 | Lanier | Georgia | 13173 | 1 | 0 |
28806 | 28806 | 2020-04-03 | Lanier | Georgia | 13173 | 1 | 0 |
31166 | 31166 | 2020-04-04 | Lanier | Georgia | 13173 | 1 | 0 |
33573 | 33573 | 2020-04-05 | Lanier | Georgia | 13173 | 1 | 0 |
36023 | 36023 | 2020-04-06 | Lanier | Georgia | 13173 | 5 | 0 |
38516 | 38516 | 2020-04-07 | Lanier | Georgia | 13173 | 5 | 0 |
41060 | 41060 | 2020-04-08 | Lanier | Georgia | 13173 | 5 | 0 |
43634 | 43634 | 2020-04-09 | Lanier | Georgia | 13173 | 5 | 0 |
46236 | 46236 | 2020-04-10 | Lanier | Georgia | 13173 | 5 | 0 |
48866 | 48866 | 2020-04-11 | Lanier | Georgia | 13173 | 5 | 0 |
51528 | 51528 | 2020-04-12 | Lanier | Georgia | 13173 | 5 | 0 |
54208 | 54208 | 2020-04-13 | Lanier | Georgia | 13173 | 5 | 0 |
56900 | 56900 | 2020-04-14 | Lanier | Georgia | 13173 | 5 | 1 |
59607 | 59607 | 2020-04-15 | Lanier | Georgia | 13173 | 5 | 1 |
62327 | 62327 | 2020-04-16 | Lanier | Georgia | 13173 | 6 | 1 |
65060 | 65060 | 2020-04-17 | Lanier | Georgia | 13173 | 6 | 1 |
67808 | 67808 | 2020-04-18 | Lanier | Georgia | 13173 | 6 | 1 |
70570 | 70570 | 2020-04-19 | Lanier | Georgia | 13173 | 6 | 1 |
73339 | 73339 | 2020-04-20 | Lanier | Georgia | 13173 | 7 | 1 |
76115 | 76115 | 2020-04-21 | Lanier | Georgia | 13173 | 7 | 1 |
78899 | 78899 | 2020-04-22 | Lanier | Georgia | 13173 | 7 | 1 |
81692 | 81692 | 2020-04-23 | Lanier | Georgia | 13173 | 7 | 1 |
84492 | 84492 | 2020-04-24 | Lanier | Georgia | 13173 | 8 | 1 |
87301 | 87301 | 2020-04-25 | Lanier | Georgia | 13173 | 8 | 1 |
90117 | 90117 | 2020-04-26 | Lanier | Georgia | 13173 | 8 | 1 |
92936 | 92936 | 2020-04-27 | Lanier | Georgia | 13173 | 8 | 1 |
95768 | 95768 | 2020-04-28 | Lanier | Georgia | 13173 | 8 | 1 |
98613 | 98613 | 2020-04-29 | Lanier | Georgia | 13173 | 8 | 1 |
101463 | 101463 | 2020-04-30 | Lanier | Georgia | 13173 | 8 | 1 |
104318 | 104318 | 2020-05-01 | Lanier | Georgia | 13173 | 9 | 1 |
107183 | 107183 | 2020-05-02 | Lanier | Georgia | 13173 | 9 | 1 |
110052 | 110052 | 2020-05-03 | Lanier | Georgia | 13173 | 9 | 1 |
112927 | 112927 | 2020-05-04 | Lanier | Georgia | 13173 | 10 | 1 |
115810 | 115810 | 2020-05-05 | Lanier | Georgia | 13173 | 10 | 1 |
118770 | 118770 | 2020-05-06 | Lanier | Georgia | 13173 | 10 | 1 |
121740 | 121740 | 2020-05-07 | Lanier | Georgia | 13173 | 10 | 1 |
124719 | 124719 | 2020-05-08 | Lanier | Georgia | 13173 | 10 | 2 |
127706 | 127706 | 2020-05-09 | Lanier | Georgia | 13173 | 10 | 2 |
130697 | 130697 | 2020-05-10 | Lanier | Georgia | 13173 | 11 | 2 |
133688 | 133688 | 2020-05-11 | Lanier | Georgia | 13173 | 11 | 2 |
136677 | 136677 | 2020-05-12 | Lanier | Georgia | 13173 | 11 | 2 |
139668 | 139668 | 2020-05-13 | Lanier | Georgia | 13173 | 11 | 2 |
142664 | 142664 | 2020-05-14 | Lanier | Georgia | 13173 | 11 | 2 |
145664 | 145664 | 2020-05-15 | Lanier | Georgia | 13173 | 12 | 2 |
148667 | 148667 | 2020-05-16 | Lanier | Georgia | 13173 | 12 | 2 |
151676 | 151676 | 2020-05-17 | Lanier | Georgia | 13173 | 12 | 3 |
154688 | 154688 | 2020-05-18 | Lanier | Georgia | 13173 | 11 | 2 |
157704 | 157704 | 2020-05-19 | Lanier | Georgia | 13173 | 11 | 2 |
160730 | 160730 | 2020-05-20 | Lanier | Georgia | 13173 | 12 | 2 |
163758 | 163758 | 2020-05-21 | Lanier | Georgia | 13173 | 12 | 2 |
166791 | 166791 | 2020-05-22 | Lanier | Georgia | 13173 | 12 | 2 |
169828 | 169828 | 2020-05-23 | Lanier | Georgia | 13173 | 12 | 2 |
172869 | 172869 | 2020-05-24 | Lanier | Georgia | 13173 | 12 | 2 |
175912 | 175912 | 2020-05-25 | Lanier | Georgia | 13173 | 14 | 2 |
178956 | 178956 | 2020-05-26 | Lanier | Georgia | 13173 | 16 | 2 |
182000 | 182000 | 2020-05-27 | Lanier | Georgia | 13173 | 20 | 2 |
185054 | 185054 | 2020-05-28 | Lanier | Georgia | 13173 | 20 | 2 |
188110 | 188110 | 2020-05-29 | Lanier | Georgia | 13173 | 21 | 2 |
191175 | 191175 | 2020-05-30 | Lanier | Georgia | 13173 | 21 | 2 |
194242 | 194242 | 2020-05-31 | Lanier | Georgia | 13173 | 21 | 2 |
197312 | 197312 | 2020-06-01 | Lanier | Georgia | 13173 | 25 | 2 |
200385 | 200385 | 2020-06-02 | Lanier | Georgia | 13173 | 25 | 2 |
203461 | 203461 | 2020-06-03 | Lanier | Georgia | 13173 | 24 | 2 |
206541 | 206541 | 2020-06-04 | Lanier | Georgia | 13173 | 27 | 2 |
209622 | 209622 | 2020-06-05 | Lanier | Georgia | 13173 | 27 | 2 |
212707 | 212707 | 2020-06-06 | Lanier | Georgia | 13173 | 32 | 2 |
215794 | 215794 | 2020-06-07 | Lanier | Georgia | 13173 | 32 | 2 |
218885 | 218885 | 2020-06-08 | Lanier | Georgia | 13173 | 32 | 2 |
221980 | 221980 | 2020-06-09 | Lanier | Georgia | 13173 | 34 | 2 |
225075 | 225075 | 2020-06-10 | Lanier | Georgia | 13173 | 36 | 2 |
228177 | 228177 | 2020-06-11 | Lanier | Georgia | 13173 | 36 | 2 |
231280 | 231280 | 2020-06-12 | Lanier | Georgia | 13173 | 37 | 2 |
234386 | 234386 | 2020-06-13 | Lanier | Georgia | 13173 | 96 | 2 |
237493 | 237493 | 2020-06-14 | Lanier | Georgia | 13173 | 98 | 2 |
240601 | 240601 | 2020-06-15 | Lanier | Georgia | 13173 | 98 | 2 |
243712 | 243712 | 2020-06-16 | Lanier | Georgia | 13173 | 98 | 2 |
246825 | 246825 | 2020-06-17 | Lanier | Georgia | 13173 | 102 | 2 |
249937 | 249937 | 2020-06-18 | Lanier | Georgia | 13173 | 108 | 2 |
253052 | 253052 | 2020-06-19 | Lanier | Georgia | 13173 | 111 | 2 |
256171 | 256171 | 2020-06-20 | Lanier | Georgia | 13173 | 112 | 2 |
259298 | 259298 | 2020-06-21 | Lanier | Georgia | 13173 | 114 | 2 |
262425 | 262425 | 2020-06-22 | Lanier | Georgia | 13173 | 116 | 2 |
265553 | 265553 | 2020-06-23 | Lanier | Georgia | 13173 | 116 | 3 |
268683 | 268683 | 2020-06-24 | Lanier | Georgia | 13173 | 118 | 3 |
271819 | 271819 | 2020-06-25 | Lanier | Georgia | 13173 | 122 | 3 |
274959 | 274959 | 2020-06-26 | Lanier | Georgia | 13173 | 124 | 3 |
278107 | 278107 | 2020-06-27 | Lanier | Georgia | 13173 | 127 | 3 |
281254 | 281254 | 2020-06-28 | Lanier | Georgia | 13173 | 129 | 3 |
284400 | 284400 | 2020-06-29 | Lanier | Georgia | 13173 | 129 | 3 |
287546 | 287546 | 2020-06-30 | Lanier | Georgia | 13173 | 132 | 3 |
290697 | 290697 | 2020-07-01 | Lanier | Georgia | 13173 | 137 | 3 |
293851 | 293851 | 2020-07-02 | Lanier | Georgia | 13173 | 145 | 3 |
297007 | 297007 | 2020-07-03 | Lanier | Georgia | 13173 | 145 | 3 |
300169 | 300169 | 2020-07-04 | Lanier | Georgia | 13173 | 146 | 3 |
303333 | 303333 | 2020-07-05 | Lanier | Georgia | 13173 | 152 | 3 |
306497 | 306497 | 2020-07-06 | Lanier | Georgia | 13173 | 152 | 3 |
309665 | 309665 | 2020-07-07 | Lanier | Georgia | 13173 | 153 | 3 |
312835 | 312835 | 2020-07-08 | Lanier | Georgia | 13173 | 153 | 3 |
316010 | 316010 | 2020-07-09 | Lanier | Georgia | 13173 | 160 | 3 |
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);