ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Union" and fips = 13291 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
24322 | 24322 | 2020-04-01 | Union | Georgia | 13291 | 1 | 0 |
26554 | 26554 | 2020-04-02 | Union | Georgia | 13291 | 1 | 0 |
28861 | 28861 | 2020-04-03 | Union | Georgia | 13291 | 1 | 0 |
31221 | 31221 | 2020-04-04 | Union | Georgia | 13291 | 1 | 0 |
33628 | 33628 | 2020-04-05 | Union | Georgia | 13291 | 1 | 0 |
36079 | 36079 | 2020-04-06 | Union | Georgia | 13291 | 1 | 0 |
38572 | 38572 | 2020-04-07 | Union | Georgia | 13291 | 4 | 0 |
41116 | 41116 | 2020-04-08 | Union | Georgia | 13291 | 5 | 0 |
43690 | 43690 | 2020-04-09 | Union | Georgia | 13291 | 5 | 1 |
46292 | 46292 | 2020-04-10 | Union | Georgia | 13291 | 6 | 1 |
48923 | 48923 | 2020-04-11 | Union | Georgia | 13291 | 7 | 1 |
51585 | 51585 | 2020-04-12 | Union | Georgia | 13291 | 7 | 1 |
54265 | 54265 | 2020-04-13 | Union | Georgia | 13291 | 7 | 1 |
56957 | 56957 | 2020-04-14 | Union | Georgia | 13291 | 8 | 1 |
59664 | 59664 | 2020-04-15 | Union | Georgia | 13291 | 8 | 1 |
62384 | 62384 | 2020-04-16 | Union | Georgia | 13291 | 8 | 1 |
65117 | 65117 | 2020-04-17 | Union | Georgia | 13291 | 10 | 1 |
67865 | 67865 | 2020-04-18 | Union | Georgia | 13291 | 12 | 1 |
70627 | 70627 | 2020-04-19 | Union | Georgia | 13291 | 14 | 1 |
76172 | 76172 | 2020-04-21 | Union | Georgia | 13291 | 15 | 1 |
73396 | 73396 | 2020-04-20 | Union | Georgia | 13291 | 16 | 1 |
78956 | 78956 | 2020-04-22 | Union | Georgia | 13291 | 18 | 1 |
81749 | 81749 | 2020-04-23 | Union | Georgia | 13291 | 25 | 1 |
84549 | 84549 | 2020-04-24 | Union | Georgia | 13291 | 27 | 2 |
87358 | 87358 | 2020-04-25 | Union | Georgia | 13291 | 28 | 2 |
107240 | 107240 | 2020-05-02 | Union | Georgia | 13291 | 31 | 1 |
110110 | 110110 | 2020-05-03 | Union | Georgia | 13291 | 31 | 1 |
112985 | 112985 | 2020-05-04 | Union | Georgia | 13291 | 31 | 1 |
90174 | 90174 | 2020-04-26 | Union | Georgia | 13291 | 32 | 2 |
92993 | 92993 | 2020-04-27 | Union | Georgia | 13291 | 32 | 2 |
115868 | 115868 | 2020-05-05 | Union | Georgia | 13291 | 32 | 1 |
118828 | 118828 | 2020-05-06 | Union | Georgia | 13291 | 32 | 1 |
98670 | 98670 | 2020-04-29 | Union | Georgia | 13291 | 33 | 1 |
101520 | 101520 | 2020-04-30 | Union | Georgia | 13291 | 33 | 1 |
104375 | 104375 | 2020-05-01 | Union | Georgia | 13291 | 33 | 1 |
121798 | 121798 | 2020-05-07 | Union | Georgia | 13291 | 33 | 1 |
95825 | 95825 | 2020-04-28 | Union | Georgia | 13291 | 34 | 1 |
124777 | 124777 | 2020-05-08 | Union | Georgia | 13291 | 34 | 1 |
127764 | 127764 | 2020-05-09 | Union | Georgia | 13291 | 34 | 1 |
130755 | 130755 | 2020-05-10 | Union | Georgia | 13291 | 34 | 1 |
133746 | 133746 | 2020-05-11 | Union | Georgia | 13291 | 35 | 1 |
136735 | 136735 | 2020-05-12 | Union | Georgia | 13291 | 36 | 1 |
139726 | 139726 | 2020-05-13 | Union | Georgia | 13291 | 36 | 1 |
142722 | 142722 | 2020-05-14 | Union | Georgia | 13291 | 36 | 1 |
145722 | 145722 | 2020-05-15 | Union | Georgia | 13291 | 36 | 1 |
148725 | 148725 | 2020-05-16 | Union | Georgia | 13291 | 36 | 1 |
151734 | 151734 | 2020-05-17 | Union | Georgia | 13291 | 36 | 1 |
154746 | 154746 | 2020-05-18 | Union | Georgia | 13291 | 37 | 1 |
157762 | 157762 | 2020-05-19 | Union | Georgia | 13291 | 37 | 1 |
160788 | 160788 | 2020-05-20 | Union | Georgia | 13291 | 38 | 1 |
163816 | 163816 | 2020-05-21 | Union | Georgia | 13291 | 39 | 1 |
166849 | 166849 | 2020-05-22 | Union | Georgia | 13291 | 39 | 1 |
169886 | 169886 | 2020-05-23 | Union | Georgia | 13291 | 39 | 1 |
172927 | 172927 | 2020-05-24 | Union | Georgia | 13291 | 39 | 1 |
175970 | 175970 | 2020-05-25 | Union | Georgia | 13291 | 39 | 1 |
179014 | 179014 | 2020-05-26 | Union | Georgia | 13291 | 41 | 1 |
185112 | 185112 | 2020-05-28 | Union | Georgia | 13291 | 43 | 1 |
182058 | 182058 | 2020-05-27 | Union | Georgia | 13291 | 44 | 1 |
188168 | 188168 | 2020-05-29 | Union | Georgia | 13291 | 44 | 1 |
191233 | 191233 | 2020-05-30 | Union | Georgia | 13291 | 44 | 1 |
194300 | 194300 | 2020-05-31 | Union | Georgia | 13291 | 46 | 1 |
197370 | 197370 | 2020-06-01 | Union | Georgia | 13291 | 46 | 1 |
200443 | 200443 | 2020-06-02 | Union | Georgia | 13291 | 46 | 1 |
203519 | 203519 | 2020-06-03 | Union | Georgia | 13291 | 48 | 1 |
206599 | 206599 | 2020-06-04 | Union | Georgia | 13291 | 48 | 1 |
209680 | 209680 | 2020-06-05 | Union | Georgia | 13291 | 48 | 1 |
212765 | 212765 | 2020-06-06 | Union | Georgia | 13291 | 49 | 1 |
215852 | 215852 | 2020-06-07 | Union | Georgia | 13291 | 49 | 1 |
218943 | 218943 | 2020-06-08 | Union | Georgia | 13291 | 49 | 1 |
222038 | 222038 | 2020-06-09 | Union | Georgia | 13291 | 50 | 1 |
225133 | 225133 | 2020-06-10 | Union | Georgia | 13291 | 51 | 2 |
228235 | 228235 | 2020-06-11 | Union | Georgia | 13291 | 53 | 2 |
231338 | 231338 | 2020-06-12 | Union | Georgia | 13291 | 53 | 2 |
234444 | 234444 | 2020-06-13 | Union | Georgia | 13291 | 53 | 2 |
237551 | 237551 | 2020-06-14 | Union | Georgia | 13291 | 53 | 2 |
240659 | 240659 | 2020-06-15 | Union | Georgia | 13291 | 54 | 3 |
243770 | 243770 | 2020-06-16 | Union | Georgia | 13291 | 55 | 3 |
246883 | 246883 | 2020-06-17 | Union | Georgia | 13291 | 56 | 3 |
249995 | 249995 | 2020-06-18 | Union | Georgia | 13291 | 56 | 3 |
253110 | 253110 | 2020-06-19 | Union | Georgia | 13291 | 56 | 3 |
256229 | 256229 | 2020-06-20 | Union | Georgia | 13291 | 56 | 3 |
259356 | 259356 | 2020-06-21 | Union | Georgia | 13291 | 56 | 3 |
262483 | 262483 | 2020-06-22 | Union | Georgia | 13291 | 56 | 3 |
265611 | 265611 | 2020-06-23 | Union | Georgia | 13291 | 60 | 3 |
268741 | 268741 | 2020-06-24 | Union | Georgia | 13291 | 62 | 3 |
271877 | 271877 | 2020-06-25 | Union | Georgia | 13291 | 62 | 3 |
275017 | 275017 | 2020-06-26 | Union | Georgia | 13291 | 67 | 3 |
278165 | 278165 | 2020-06-27 | Union | Georgia | 13291 | 67 | 3 |
281312 | 281312 | 2020-06-28 | Union | Georgia | 13291 | 68 | 3 |
284458 | 284458 | 2020-06-29 | Union | Georgia | 13291 | 68 | 3 |
287604 | 287604 | 2020-06-30 | Union | Georgia | 13291 | 71 | 3 |
293909 | 293909 | 2020-07-02 | Union | Georgia | 13291 | 75 | 3 |
290755 | 290755 | 2020-07-01 | Union | Georgia | 13291 | 76 | 3 |
297065 | 297065 | 2020-07-03 | Union | Georgia | 13291 | 76 | 3 |
300227 | 300227 | 2020-07-04 | Union | Georgia | 13291 | 78 | 3 |
303391 | 303391 | 2020-07-05 | Union | Georgia | 13291 | 78 | 3 |
306555 | 306555 | 2020-07-06 | Union | Georgia | 13291 | 78 | 3 |
309723 | 309723 | 2020-07-07 | Union | Georgia | 13291 | 85 | 3 |
312893 | 312893 | 2020-07-08 | Union | Georgia | 13291 | 89 | 3 |
316068 | 316068 | 2020-07-09 | Union | Georgia | 13291 | 92 | 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);