ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Marion" and fips = 13197 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
28816 | 28816 | 2020-04-03 | Marion | Georgia | 13197 | 1 | 0 |
31176 | 31176 | 2020-04-04 | Marion | Georgia | 13197 | 2 | 0 |
33583 | 33583 | 2020-04-05 | Marion | Georgia | 13197 | 2 | 0 |
36033 | 36033 | 2020-04-06 | Marion | Georgia | 13197 | 2 | 0 |
38526 | 38526 | 2020-04-07 | Marion | Georgia | 13197 | 4 | 0 |
41070 | 41070 | 2020-04-08 | Marion | Georgia | 13197 | 7 | 0 |
43644 | 43644 | 2020-04-09 | Marion | Georgia | 13197 | 8 | 0 |
46246 | 46246 | 2020-04-10 | Marion | Georgia | 13197 | 10 | 0 |
48876 | 48876 | 2020-04-11 | Marion | Georgia | 13197 | 10 | 0 |
51538 | 51538 | 2020-04-12 | Marion | Georgia | 13197 | 10 | 0 |
54218 | 54218 | 2020-04-13 | Marion | Georgia | 13197 | 15 | 0 |
56910 | 56910 | 2020-04-14 | Marion | Georgia | 13197 | 17 | 0 |
59617 | 59617 | 2020-04-15 | Marion | Georgia | 13197 | 17 | 0 |
62337 | 62337 | 2020-04-16 | Marion | Georgia | 13197 | 20 | 0 |
65070 | 65070 | 2020-04-17 | Marion | Georgia | 13197 | 26 | 1 |
67818 | 67818 | 2020-04-18 | Marion | Georgia | 13197 | 26 | 1 |
70580 | 70580 | 2020-04-19 | Marion | Georgia | 13197 | 28 | 1 |
73349 | 73349 | 2020-04-20 | Marion | Georgia | 13197 | 29 | 1 |
76125 | 76125 | 2020-04-21 | Marion | Georgia | 13197 | 29 | 1 |
78909 | 78909 | 2020-04-22 | Marion | Georgia | 13197 | 33 | 1 |
81702 | 81702 | 2020-04-23 | Marion | Georgia | 13197 | 34 | 1 |
84502 | 84502 | 2020-04-24 | Marion | Georgia | 13197 | 35 | 1 |
87311 | 87311 | 2020-04-25 | Marion | Georgia | 13197 | 38 | 1 |
90127 | 90127 | 2020-04-26 | Marion | Georgia | 13197 | 38 | 1 |
92946 | 92946 | 2020-04-27 | Marion | Georgia | 13197 | 40 | 1 |
95778 | 95778 | 2020-04-28 | Marion | Georgia | 13197 | 40 | 1 |
98623 | 98623 | 2020-04-29 | Marion | Georgia | 13197 | 41 | 1 |
101473 | 101473 | 2020-04-30 | Marion | Georgia | 13197 | 42 | 1 |
104328 | 104328 | 2020-05-01 | Marion | Georgia | 13197 | 42 | 1 |
107193 | 107193 | 2020-05-02 | Marion | Georgia | 13197 | 42 | 1 |
110062 | 110062 | 2020-05-03 | Marion | Georgia | 13197 | 40 | 1 |
112937 | 112937 | 2020-05-04 | Marion | Georgia | 13197 | 39 | 1 |
115820 | 115820 | 2020-05-05 | Marion | Georgia | 13197 | 37 | 1 |
118780 | 118780 | 2020-05-06 | Marion | Georgia | 13197 | 37 | 1 |
121750 | 121750 | 2020-05-07 | Marion | Georgia | 13197 | 37 | 1 |
124729 | 124729 | 2020-05-08 | Marion | Georgia | 13197 | 39 | 1 |
127716 | 127716 | 2020-05-09 | Marion | Georgia | 13197 | 39 | 1 |
130707 | 130707 | 2020-05-10 | Marion | Georgia | 13197 | 40 | 1 |
133698 | 133698 | 2020-05-11 | Marion | Georgia | 13197 | 40 | 1 |
136687 | 136687 | 2020-05-12 | Marion | Georgia | 13197 | 38 | 1 |
139678 | 139678 | 2020-05-13 | Marion | Georgia | 13197 | 38 | 1 |
142674 | 142674 | 2020-05-14 | Marion | Georgia | 13197 | 38 | 1 |
145674 | 145674 | 2020-05-15 | Marion | Georgia | 13197 | 39 | 1 |
148677 | 148677 | 2020-05-16 | Marion | Georgia | 13197 | 39 | 1 |
151686 | 151686 | 2020-05-17 | Marion | Georgia | 13197 | 40 | 2 |
154698 | 154698 | 2020-05-18 | Marion | Georgia | 13197 | 46 | 2 |
157714 | 157714 | 2020-05-19 | Marion | Georgia | 13197 | 47 | 2 |
160740 | 160740 | 2020-05-20 | Marion | Georgia | 13197 | 47 | 2 |
163768 | 163768 | 2020-05-21 | Marion | Georgia | 13197 | 48 | 2 |
166801 | 166801 | 2020-05-22 | Marion | Georgia | 13197 | 48 | 2 |
169838 | 169838 | 2020-05-23 | Marion | Georgia | 13197 | 49 | 2 |
172879 | 172879 | 2020-05-24 | Marion | Georgia | 13197 | 49 | 2 |
175922 | 175922 | 2020-05-25 | Marion | Georgia | 13197 | 49 | 2 |
178966 | 178966 | 2020-05-26 | Marion | Georgia | 13197 | 49 | 2 |
182010 | 182010 | 2020-05-27 | Marion | Georgia | 13197 | 52 | 2 |
185064 | 185064 | 2020-05-28 | Marion | Georgia | 13197 | 53 | 2 |
188120 | 188120 | 2020-05-29 | Marion | Georgia | 13197 | 57 | 2 |
191185 | 191185 | 2020-05-30 | Marion | Georgia | 13197 | 57 | 2 |
194252 | 194252 | 2020-05-31 | Marion | Georgia | 13197 | 57 | 2 |
197322 | 197322 | 2020-06-01 | Marion | Georgia | 13197 | 57 | 2 |
200395 | 200395 | 2020-06-02 | Marion | Georgia | 13197 | 59 | 2 |
203471 | 203471 | 2020-06-03 | Marion | Georgia | 13197 | 59 | 2 |
206551 | 206551 | 2020-06-04 | Marion | Georgia | 13197 | 59 | 2 |
209632 | 209632 | 2020-06-05 | Marion | Georgia | 13197 | 59 | 2 |
212717 | 212717 | 2020-06-06 | Marion | Georgia | 13197 | 59 | 2 |
215804 | 215804 | 2020-06-07 | Marion | Georgia | 13197 | 59 | 2 |
218895 | 218895 | 2020-06-08 | Marion | Georgia | 13197 | 59 | 2 |
221990 | 221990 | 2020-06-09 | Marion | Georgia | 13197 | 59 | 2 |
225085 | 225085 | 2020-06-10 | Marion | Georgia | 13197 | 59 | 2 |
228187 | 228187 | 2020-06-11 | Marion | Georgia | 13197 | 61 | 2 |
231290 | 231290 | 2020-06-12 | Marion | Georgia | 13197 | 61 | 2 |
234396 | 234396 | 2020-06-13 | Marion | Georgia | 13197 | 62 | 2 |
237503 | 237503 | 2020-06-14 | Marion | Georgia | 13197 | 62 | 2 |
240611 | 240611 | 2020-06-15 | Marion | Georgia | 13197 | 62 | 2 |
243722 | 243722 | 2020-06-16 | Marion | Georgia | 13197 | 63 | 2 |
246835 | 246835 | 2020-06-17 | Marion | Georgia | 13197 | 66 | 2 |
249947 | 249947 | 2020-06-18 | Marion | Georgia | 13197 | 68 | 3 |
253062 | 253062 | 2020-06-19 | Marion | Georgia | 13197 | 69 | 3 |
256181 | 256181 | 2020-06-20 | Marion | Georgia | 13197 | 73 | 3 |
259308 | 259308 | 2020-06-21 | Marion | Georgia | 13197 | 74 | 3 |
262435 | 262435 | 2020-06-22 | Marion | Georgia | 13197 | 75 | 3 |
265563 | 265563 | 2020-06-23 | Marion | Georgia | 13197 | 78 | 3 |
268693 | 268693 | 2020-06-24 | Marion | Georgia | 13197 | 77 | 2 |
271829 | 271829 | 2020-06-25 | Marion | Georgia | 13197 | 77 | 2 |
274969 | 274969 | 2020-06-26 | Marion | Georgia | 13197 | 77 | 2 |
278117 | 278117 | 2020-06-27 | Marion | Georgia | 13197 | 78 | 2 |
281264 | 281264 | 2020-06-28 | Marion | Georgia | 13197 | 78 | 2 |
284410 | 284410 | 2020-06-29 | Marion | Georgia | 13197 | 78 | 2 |
287556 | 287556 | 2020-06-30 | Marion | Georgia | 13197 | 79 | 2 |
290707 | 290707 | 2020-07-01 | Marion | Georgia | 13197 | 82 | 2 |
293861 | 293861 | 2020-07-02 | Marion | Georgia | 13197 | 83 | 2 |
297017 | 297017 | 2020-07-03 | Marion | Georgia | 13197 | 86 | 2 |
300179 | 300179 | 2020-07-04 | Marion | Georgia | 13197 | 87 | 2 |
303343 | 303343 | 2020-07-05 | Marion | Georgia | 13197 | 87 | 2 |
306507 | 306507 | 2020-07-06 | Marion | Georgia | 13197 | 87 | 2 |
309675 | 309675 | 2020-07-07 | Marion | Georgia | 13197 | 86 | 2 |
312845 | 312845 | 2020-07-08 | Marion | Georgia | 13197 | 88 | 2 |
316020 | 316020 | 2020-07-09 | Marion | Georgia | 13197 | 88 | 2 |
319193 | 319193 | 2020-07-10 | Marion | Georgia | 13197 | 97 | 3 |
322372 | 322372 | 2020-07-11 | Marion | Georgia | 13197 | 99 | 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);