ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 13243 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 |
---|---|---|---|---|---|---|---|
5377 | 5377 | 2020-03-20 | Randolph | Georgia | 13243 | 1 | 0 |
6311 | 6311 | 2020-03-21 | Randolph | Georgia | 13243 | 1 | 0 |
7357 | 7357 | 2020-03-22 | Randolph | Georgia | 13243 | 1 | 0 |
8510 | 8510 | 2020-03-23 | Randolph | Georgia | 13243 | 1 | 0 |
9769 | 9769 | 2020-03-24 | Randolph | Georgia | 13243 | 1 | 0 |
11149 | 11149 | 2020-03-25 | Randolph | Georgia | 13243 | 1 | 0 |
12701 | 12701 | 2020-03-26 | Randolph | Georgia | 13243 | 2 | 0 |
14375 | 14375 | 2020-03-27 | Randolph | Georgia | 13243 | 3 | 0 |
16164 | 16164 | 2020-03-28 | Randolph | Georgia | 13243 | 3 | 0 |
18061 | 18061 | 2020-03-29 | Randolph | Georgia | 13243 | 3 | 0 |
20054 | 20054 | 2020-03-30 | Randolph | Georgia | 13243 | 3 | 0 |
22137 | 22137 | 2020-03-31 | Randolph | Georgia | 13243 | 5 | 0 |
24302 | 24302 | 2020-04-01 | Randolph | Georgia | 13243 | 5 | 0 |
26533 | 26533 | 2020-04-02 | Randolph | Georgia | 13243 | 4 | 0 |
28839 | 28839 | 2020-04-03 | Randolph | Georgia | 13243 | 11 | 0 |
31199 | 31199 | 2020-04-04 | Randolph | Georgia | 13243 | 18 | 0 |
33606 | 33606 | 2020-04-05 | Randolph | Georgia | 13243 | 18 | 0 |
36056 | 36056 | 2020-04-06 | Randolph | Georgia | 13243 | 26 | 2 |
38549 | 38549 | 2020-04-07 | Randolph | Georgia | 13243 | 83 | 4 |
41093 | 41093 | 2020-04-08 | Randolph | Georgia | 13243 | 87 | 3 |
43667 | 43667 | 2020-04-09 | Randolph | Georgia | 13243 | 95 | 4 |
46269 | 46269 | 2020-04-10 | Randolph | Georgia | 13243 | 102 | 5 |
48900 | 48900 | 2020-04-11 | Randolph | Georgia | 13243 | 103 | 5 |
51562 | 51562 | 2020-04-12 | Randolph | Georgia | 13243 | 111 | 5 |
54242 | 54242 | 2020-04-13 | Randolph | Georgia | 13243 | 122 | 6 |
56934 | 56934 | 2020-04-14 | Randolph | Georgia | 13243 | 131 | 6 |
59641 | 59641 | 2020-04-15 | Randolph | Georgia | 13243 | 131 | 7 |
62361 | 62361 | 2020-04-16 | Randolph | Georgia | 13243 | 135 | 11 |
65094 | 65094 | 2020-04-17 | Randolph | Georgia | 13243 | 140 | 12 |
67842 | 67842 | 2020-04-18 | Randolph | Georgia | 13243 | 141 | 13 |
70604 | 70604 | 2020-04-19 | Randolph | Georgia | 13243 | 144 | 13 |
73373 | 73373 | 2020-04-20 | Randolph | Georgia | 13243 | 145 | 15 |
76149 | 76149 | 2020-04-21 | Randolph | Georgia | 13243 | 146 | 16 |
78933 | 78933 | 2020-04-22 | Randolph | Georgia | 13243 | 148 | 17 |
81726 | 81726 | 2020-04-23 | Randolph | Georgia | 13243 | 149 | 18 |
84526 | 84526 | 2020-04-24 | Randolph | Georgia | 13243 | 152 | 18 |
87335 | 87335 | 2020-04-25 | Randolph | Georgia | 13243 | 153 | 19 |
90151 | 90151 | 2020-04-26 | Randolph | Georgia | 13243 | 153 | 19 |
92970 | 92970 | 2020-04-27 | Randolph | Georgia | 13243 | 156 | 19 |
95802 | 95802 | 2020-04-28 | Randolph | Georgia | 13243 | 156 | 19 |
98647 | 98647 | 2020-04-29 | Randolph | Georgia | 13243 | 159 | 19 |
101497 | 101497 | 2020-04-30 | Randolph | Georgia | 13243 | 159 | 19 |
104352 | 104352 | 2020-05-01 | Randolph | Georgia | 13243 | 162 | 19 |
107217 | 107217 | 2020-05-02 | Randolph | Georgia | 13243 | 163 | 19 |
110086 | 110086 | 2020-05-03 | Randolph | Georgia | 13243 | 163 | 19 |
112961 | 112961 | 2020-05-04 | Randolph | Georgia | 13243 | 164 | 19 |
115844 | 115844 | 2020-05-05 | Randolph | Georgia | 13243 | 165 | 20 |
118804 | 118804 | 2020-05-06 | Randolph | Georgia | 13243 | 167 | 20 |
121774 | 121774 | 2020-05-07 | Randolph | Georgia | 13243 | 167 | 20 |
124753 | 124753 | 2020-05-08 | Randolph | Georgia | 13243 | 167 | 21 |
127740 | 127740 | 2020-05-09 | Randolph | Georgia | 13243 | 168 | 21 |
130731 | 130731 | 2020-05-10 | Randolph | Georgia | 13243 | 168 | 21 |
133722 | 133722 | 2020-05-11 | Randolph | Georgia | 13243 | 168 | 21 |
136711 | 136711 | 2020-05-12 | Randolph | Georgia | 13243 | 169 | 21 |
139702 | 139702 | 2020-05-13 | Randolph | Georgia | 13243 | 169 | 21 |
142698 | 142698 | 2020-05-14 | Randolph | Georgia | 13243 | 169 | 21 |
145698 | 145698 | 2020-05-15 | Randolph | Georgia | 13243 | 169 | 21 |
148701 | 148701 | 2020-05-16 | Randolph | Georgia | 13243 | 169 | 21 |
151710 | 151710 | 2020-05-17 | Randolph | Georgia | 13243 | 169 | 21 |
154722 | 154722 | 2020-05-18 | Randolph | Georgia | 13243 | 169 | 21 |
157738 | 157738 | 2020-05-19 | Randolph | Georgia | 13243 | 169 | 21 |
160764 | 160764 | 2020-05-20 | Randolph | Georgia | 13243 | 170 | 21 |
163792 | 163792 | 2020-05-21 | Randolph | Georgia | 13243 | 170 | 20 |
166825 | 166825 | 2020-05-22 | Randolph | Georgia | 13243 | 170 | 19 |
169862 | 169862 | 2020-05-23 | Randolph | Georgia | 13243 | 170 | 19 |
172903 | 172903 | 2020-05-24 | Randolph | Georgia | 13243 | 170 | 19 |
175946 | 175946 | 2020-05-25 | Randolph | Georgia | 13243 | 174 | 19 |
178990 | 178990 | 2020-05-26 | Randolph | Georgia | 13243 | 175 | 19 |
182034 | 182034 | 2020-05-27 | Randolph | Georgia | 13243 | 176 | 19 |
185088 | 185088 | 2020-05-28 | Randolph | Georgia | 13243 | 177 | 19 |
188144 | 188144 | 2020-05-29 | Randolph | Georgia | 13243 | 179 | 19 |
191209 | 191209 | 2020-05-30 | Randolph | Georgia | 13243 | 179 | 19 |
194276 | 194276 | 2020-05-31 | Randolph | Georgia | 13243 | 179 | 19 |
197346 | 197346 | 2020-06-01 | Randolph | Georgia | 13243 | 179 | 19 |
200419 | 200419 | 2020-06-02 | Randolph | Georgia | 13243 | 179 | 19 |
203495 | 203495 | 2020-06-03 | Randolph | Georgia | 13243 | 179 | 19 |
206575 | 206575 | 2020-06-04 | Randolph | Georgia | 13243 | 181 | 19 |
209656 | 209656 | 2020-06-05 | Randolph | Georgia | 13243 | 181 | 19 |
212741 | 212741 | 2020-06-06 | Randolph | Georgia | 13243 | 183 | 19 |
215828 | 215828 | 2020-06-07 | Randolph | Georgia | 13243 | 183 | 19 |
218919 | 218919 | 2020-06-08 | Randolph | Georgia | 13243 | 183 | 19 |
222014 | 222014 | 2020-06-09 | Randolph | Georgia | 13243 | 187 | 20 |
225109 | 225109 | 2020-06-10 | Randolph | Georgia | 13243 | 186 | 20 |
228211 | 228211 | 2020-06-11 | Randolph | Georgia | 13243 | 188 | 20 |
231314 | 231314 | 2020-06-12 | Randolph | Georgia | 13243 | 190 | 21 |
234420 | 234420 | 2020-06-13 | Randolph | Georgia | 13243 | 190 | 21 |
237527 | 237527 | 2020-06-14 | Randolph | Georgia | 13243 | 190 | 21 |
240635 | 240635 | 2020-06-15 | Randolph | Georgia | 13243 | 191 | 22 |
243746 | 243746 | 2020-06-16 | Randolph | Georgia | 13243 | 191 | 23 |
246859 | 246859 | 2020-06-17 | Randolph | Georgia | 13243 | 191 | 23 |
249971 | 249971 | 2020-06-18 | Randolph | Georgia | 13243 | 193 | 23 |
253086 | 253086 | 2020-06-19 | Randolph | Georgia | 13243 | 194 | 23 |
256205 | 256205 | 2020-06-20 | Randolph | Georgia | 13243 | 194 | 23 |
259332 | 259332 | 2020-06-21 | Randolph | Georgia | 13243 | 194 | 23 |
262459 | 262459 | 2020-06-22 | Randolph | Georgia | 13243 | 195 | 23 |
265587 | 265587 | 2020-06-23 | Randolph | Georgia | 13243 | 197 | 25 |
268717 | 268717 | 2020-06-24 | Randolph | Georgia | 13243 | 198 | 25 |
271853 | 271853 | 2020-06-25 | Randolph | Georgia | 13243 | 197 | 25 |
274993 | 274993 | 2020-06-26 | Randolph | Georgia | 13243 | 197 | 25 |
278141 | 278141 | 2020-06-27 | Randolph | Georgia | 13243 | 197 | 25 |
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);