ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Floyd", fips = 13115 and state = "Georgia" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
909 | 909 | 2020-03-09 | Floyd | Georgia | 13115 | 1 | 0 |
1050 | 1050 | 2020-03-10 | Floyd | Georgia | 13115 | 1 | 0 |
1222 | 1222 | 2020-03-11 | Floyd | Georgia | 13115 | 2 | 0 |
1436 | 1436 | 2020-03-12 | Floyd | Georgia | 13115 | 2 | 0 |
1704 | 1704 | 2020-03-13 | Floyd | Georgia | 13115 | 2 | 0 |
2027 | 2027 | 2020-03-14 | Floyd | Georgia | 13115 | 3 | 0 |
2414 | 2414 | 2020-03-15 | Floyd | Georgia | 13115 | 4 | 0 |
2851 | 2851 | 2020-03-16 | Floyd | Georgia | 13115 | 4 | 0 |
3336 | 3336 | 2020-03-17 | Floyd | Georgia | 13115 | 5 | 0 |
3897 | 3897 | 2020-03-18 | Floyd | Georgia | 13115 | 5 | 0 |
4569 | 4569 | 2020-03-19 | Floyd | Georgia | 13115 | 6 | 1 |
5353 | 5353 | 2020-03-20 | Floyd | Georgia | 13115 | 7 | 1 |
6286 | 6286 | 2020-03-21 | Floyd | Georgia | 13115 | 8 | 1 |
7332 | 7332 | 2020-03-22 | Floyd | Georgia | 13115 | 9 | 1 |
8480 | 8480 | 2020-03-23 | Floyd | Georgia | 13115 | 10 | 1 |
9732 | 9732 | 2020-03-24 | Floyd | Georgia | 13115 | 12 | 1 |
11109 | 11109 | 2020-03-25 | Floyd | Georgia | 13115 | 14 | 1 |
12658 | 12658 | 2020-03-26 | Floyd | Georgia | 13115 | 17 | 1 |
14330 | 14330 | 2020-03-27 | Floyd | Georgia | 13115 | 26 | 1 |
16116 | 16116 | 2020-03-28 | Floyd | Georgia | 13115 | 27 | 1 |
18013 | 18013 | 2020-03-29 | Floyd | Georgia | 13115 | 28 | 2 |
20002 | 20002 | 2020-03-30 | Floyd | Georgia | 13115 | 31 | 2 |
22082 | 22082 | 2020-03-31 | Floyd | Georgia | 13115 | 50 | 2 |
24245 | 24245 | 2020-04-01 | Floyd | Georgia | 13115 | 70 | 2 |
26476 | 26476 | 2020-04-02 | Floyd | Georgia | 13115 | 78 | 2 |
28780 | 28780 | 2020-04-03 | Floyd | Georgia | 13115 | 79 | 3 |
31140 | 31140 | 2020-04-04 | Floyd | Georgia | 13115 | 80 | 3 |
33547 | 33547 | 2020-04-05 | Floyd | Georgia | 13115 | 82 | 3 |
35996 | 35996 | 2020-04-06 | Floyd | Georgia | 13115 | 89 | 3 |
38488 | 38488 | 2020-04-07 | Floyd | Georgia | 13115 | 92 | 3 |
41032 | 41032 | 2020-04-08 | Floyd | Georgia | 13115 | 97 | 3 |
43606 | 43606 | 2020-04-09 | Floyd | Georgia | 13115 | 100 | 5 |
46208 | 46208 | 2020-04-10 | Floyd | Georgia | 13115 | 104 | 5 |
48838 | 48838 | 2020-04-11 | Floyd | Georgia | 13115 | 107 | 5 |
51500 | 51500 | 2020-04-12 | Floyd | Georgia | 13115 | 108 | 5 |
54180 | 54180 | 2020-04-13 | Floyd | Georgia | 13115 | 118 | 6 |
56872 | 56872 | 2020-04-14 | Floyd | Georgia | 13115 | 120 | 6 |
59579 | 59579 | 2020-04-15 | Floyd | Georgia | 13115 | 120 | 6 |
62299 | 62299 | 2020-04-16 | Floyd | Georgia | 13115 | 122 | 6 |
65032 | 65032 | 2020-04-17 | Floyd | Georgia | 13115 | 121 | 8 |
67780 | 67780 | 2020-04-18 | Floyd | Georgia | 13115 | 122 | 8 |
70542 | 70542 | 2020-04-19 | Floyd | Georgia | 13115 | 122 | 8 |
73311 | 73311 | 2020-04-20 | Floyd | Georgia | 13115 | 126 | 9 |
76087 | 76087 | 2020-04-21 | Floyd | Georgia | 13115 | 127 | 8 |
78871 | 78871 | 2020-04-22 | Floyd | Georgia | 13115 | 128 | 8 |
81664 | 81664 | 2020-04-23 | Floyd | Georgia | 13115 | 128 | 8 |
84464 | 84464 | 2020-04-24 | Floyd | Georgia | 13115 | 131 | 10 |
87273 | 87273 | 2020-04-25 | Floyd | Georgia | 13115 | 133 | 10 |
90089 | 90089 | 2020-04-26 | Floyd | Georgia | 13115 | 133 | 10 |
92908 | 92908 | 2020-04-27 | Floyd | Georgia | 13115 | 134 | 11 |
95740 | 95740 | 2020-04-28 | Floyd | Georgia | 13115 | 137 | 11 |
98585 | 98585 | 2020-04-29 | Floyd | Georgia | 13115 | 139 | 11 |
101435 | 101435 | 2020-04-30 | Floyd | Georgia | 13115 | 144 | 11 |
104290 | 104290 | 2020-05-01 | Floyd | Georgia | 13115 | 145 | 11 |
107155 | 107155 | 2020-05-02 | Floyd | Georgia | 13115 | 145 | 11 |
110024 | 110024 | 2020-05-03 | Floyd | Georgia | 13115 | 145 | 11 |
112899 | 112899 | 2020-05-04 | Floyd | Georgia | 13115 | 150 | 11 |
115782 | 115782 | 2020-05-05 | Floyd | Georgia | 13115 | 151 | 11 |
118742 | 118742 | 2020-05-06 | Floyd | Georgia | 13115 | 152 | 11 |
121711 | 121711 | 2020-05-07 | Floyd | Georgia | 13115 | 155 | 12 |
124690 | 124690 | 2020-05-08 | Floyd | Georgia | 13115 | 155 | 12 |
127677 | 127677 | 2020-05-09 | Floyd | Georgia | 13115 | 157 | 12 |
130668 | 130668 | 2020-05-10 | Floyd | Georgia | 13115 | 157 | 12 |
133659 | 133659 | 2020-05-11 | Floyd | Georgia | 13115 | 158 | 12 |
136648 | 136648 | 2020-05-12 | Floyd | Georgia | 13115 | 160 | 12 |
139639 | 139639 | 2020-05-13 | Floyd | Georgia | 13115 | 166 | 12 |
142635 | 142635 | 2020-05-14 | Floyd | Georgia | 13115 | 169 | 12 |
145635 | 145635 | 2020-05-15 | Floyd | Georgia | 13115 | 172 | 13 |
148638 | 148638 | 2020-05-16 | Floyd | Georgia | 13115 | 180 | 13 |
151647 | 151647 | 2020-05-17 | Floyd | Georgia | 13115 | 180 | 13 |
154659 | 154659 | 2020-05-18 | Floyd | Georgia | 13115 | 187 | 13 |
157675 | 157675 | 2020-05-19 | Floyd | Georgia | 13115 | 195 | 13 |
160701 | 160701 | 2020-05-20 | Floyd | Georgia | 13115 | 208 | 13 |
163729 | 163729 | 2020-05-21 | Floyd | Georgia | 13115 | 218 | 13 |
166762 | 166762 | 2020-05-22 | Floyd | Georgia | 13115 | 224 | 14 |
169799 | 169799 | 2020-05-23 | Floyd | Georgia | 13115 | 226 | 14 |
172840 | 172840 | 2020-05-24 | Floyd | Georgia | 13115 | 227 | 14 |
175883 | 175883 | 2020-05-25 | Floyd | Georgia | 13115 | 228 | 14 |
178927 | 178927 | 2020-05-26 | Floyd | Georgia | 13115 | 243 | 15 |
181971 | 181971 | 2020-05-27 | Floyd | Georgia | 13115 | 253 | 15 |
185025 | 185025 | 2020-05-28 | Floyd | Georgia | 13115 | 258 | 15 |
188081 | 188081 | 2020-05-29 | Floyd | Georgia | 13115 | 260 | 15 |
191146 | 191146 | 2020-05-30 | Floyd | Georgia | 13115 | 263 | 15 |
194213 | 194213 | 2020-05-31 | Floyd | Georgia | 13115 | 265 | 15 |
197283 | 197283 | 2020-06-01 | Floyd | Georgia | 13115 | 268 | 15 |
200356 | 200356 | 2020-06-02 | Floyd | Georgia | 13115 | 274 | 15 |
203432 | 203432 | 2020-06-03 | Floyd | Georgia | 13115 | 281 | 15 |
206512 | 206512 | 2020-06-04 | Floyd | Georgia | 13115 | 292 | 15 |
209593 | 209593 | 2020-06-05 | Floyd | Georgia | 13115 | 311 | 15 |
212678 | 212678 | 2020-06-06 | Floyd | Georgia | 13115 | 322 | 15 |
215765 | 215765 | 2020-06-07 | Floyd | Georgia | 13115 | 323 | 15 |
218856 | 218856 | 2020-06-08 | Floyd | Georgia | 13115 | 326 | 15 |
221951 | 221951 | 2020-06-09 | Floyd | Georgia | 13115 | 335 | 15 |
225046 | 225046 | 2020-06-10 | Floyd | Georgia | 13115 | 349 | 15 |
228148 | 228148 | 2020-06-11 | Floyd | Georgia | 13115 | 356 | 15 |
231251 | 231251 | 2020-06-12 | Floyd | Georgia | 13115 | 365 | 15 |
234357 | 234357 | 2020-06-13 | Floyd | Georgia | 13115 | 367 | 15 |
237464 | 237464 | 2020-06-14 | Floyd | Georgia | 13115 | 367 | 15 |
240572 | 240572 | 2020-06-15 | Floyd | Georgia | 13115 | 371 | 15 |
243683 | 243683 | 2020-06-16 | Floyd | Georgia | 13115 | 375 | 15 |
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);