ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 13171 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 |
---|---|---|---|---|---|---|---|
5363 | 5363 | 2020-03-20 | Lamar | Georgia | 13171 | 1 | 0 |
6296 | 6296 | 2020-03-21 | Lamar | Georgia | 13171 | 1 | 0 |
7342 | 7342 | 2020-03-22 | Lamar | Georgia | 13171 | 3 | 0 |
8491 | 8491 | 2020-03-23 | Lamar | Georgia | 13171 | 3 | 0 |
9746 | 9746 | 2020-03-24 | Lamar | Georgia | 13171 | 3 | 0 |
11125 | 11125 | 2020-03-25 | Lamar | Georgia | 13171 | 3 | 0 |
12676 | 12676 | 2020-03-26 | Lamar | Georgia | 13171 | 3 | 0 |
14350 | 14350 | 2020-03-27 | Lamar | Georgia | 13171 | 3 | 0 |
16137 | 16137 | 2020-03-28 | Lamar | Georgia | 13171 | 3 | 0 |
18034 | 18034 | 2020-03-29 | Lamar | Georgia | 13171 | 3 | 0 |
20026 | 20026 | 2020-03-30 | Lamar | Georgia | 13171 | 3 | 0 |
22107 | 22107 | 2020-03-31 | Lamar | Georgia | 13171 | 3 | 0 |
24270 | 24270 | 2020-04-01 | Lamar | Georgia | 13171 | 4 | 0 |
26501 | 26501 | 2020-04-02 | Lamar | Georgia | 13171 | 6 | 0 |
28805 | 28805 | 2020-04-03 | Lamar | Georgia | 13171 | 6 | 0 |
31165 | 31165 | 2020-04-04 | Lamar | Georgia | 13171 | 7 | 0 |
33572 | 33572 | 2020-04-05 | Lamar | Georgia | 13171 | 7 | 0 |
36022 | 36022 | 2020-04-06 | Lamar | Georgia | 13171 | 15 | 0 |
38515 | 38515 | 2020-04-07 | Lamar | Georgia | 13171 | 15 | 0 |
41059 | 41059 | 2020-04-08 | Lamar | Georgia | 13171 | 15 | 0 |
43633 | 43633 | 2020-04-09 | Lamar | Georgia | 13171 | 15 | 0 |
46235 | 46235 | 2020-04-10 | Lamar | Georgia | 13171 | 15 | 0 |
48865 | 48865 | 2020-04-11 | Lamar | Georgia | 13171 | 15 | 0 |
51527 | 51527 | 2020-04-12 | Lamar | Georgia | 13171 | 17 | 0 |
54207 | 54207 | 2020-04-13 | Lamar | Georgia | 13171 | 18 | 0 |
56899 | 56899 | 2020-04-14 | Lamar | Georgia | 13171 | 20 | 0 |
59606 | 59606 | 2020-04-15 | Lamar | Georgia | 13171 | 21 | 0 |
62326 | 62326 | 2020-04-16 | Lamar | Georgia | 13171 | 21 | 0 |
65059 | 65059 | 2020-04-17 | Lamar | Georgia | 13171 | 22 | 0 |
67807 | 67807 | 2020-04-18 | Lamar | Georgia | 13171 | 24 | 0 |
70569 | 70569 | 2020-04-19 | Lamar | Georgia | 13171 | 25 | 0 |
73338 | 73338 | 2020-04-20 | Lamar | Georgia | 13171 | 27 | 0 |
76114 | 76114 | 2020-04-21 | Lamar | Georgia | 13171 | 29 | 0 |
78898 | 78898 | 2020-04-22 | Lamar | Georgia | 13171 | 28 | 0 |
81691 | 81691 | 2020-04-23 | Lamar | Georgia | 13171 | 31 | 0 |
84491 | 84491 | 2020-04-24 | Lamar | Georgia | 13171 | 31 | 0 |
87300 | 87300 | 2020-04-25 | Lamar | Georgia | 13171 | 33 | 0 |
90116 | 90116 | 2020-04-26 | Lamar | Georgia | 13171 | 33 | 0 |
92935 | 92935 | 2020-04-27 | Lamar | Georgia | 13171 | 34 | 0 |
95767 | 95767 | 2020-04-28 | Lamar | Georgia | 13171 | 35 | 2 |
98612 | 98612 | 2020-04-29 | Lamar | Georgia | 13171 | 37 | 2 |
101462 | 101462 | 2020-04-30 | Lamar | Georgia | 13171 | 38 | 1 |
104317 | 104317 | 2020-05-01 | Lamar | Georgia | 13171 | 39 | 1 |
107182 | 107182 | 2020-05-02 | Lamar | Georgia | 13171 | 40 | 1 |
110051 | 110051 | 2020-05-03 | Lamar | Georgia | 13171 | 40 | 1 |
112926 | 112926 | 2020-05-04 | Lamar | Georgia | 13171 | 39 | 1 |
115809 | 115809 | 2020-05-05 | Lamar | Georgia | 13171 | 39 | 1 |
118769 | 118769 | 2020-05-06 | Lamar | Georgia | 13171 | 39 | 1 |
121739 | 121739 | 2020-05-07 | Lamar | Georgia | 13171 | 38 | 1 |
124718 | 124718 | 2020-05-08 | Lamar | Georgia | 13171 | 39 | 1 |
127705 | 127705 | 2020-05-09 | Lamar | Georgia | 13171 | 39 | 1 |
130696 | 130696 | 2020-05-10 | Lamar | Georgia | 13171 | 40 | 1 |
133687 | 133687 | 2020-05-11 | Lamar | Georgia | 13171 | 40 | 1 |
136676 | 136676 | 2020-05-12 | Lamar | Georgia | 13171 | 40 | 1 |
139667 | 139667 | 2020-05-13 | Lamar | Georgia | 13171 | 40 | 1 |
142663 | 142663 | 2020-05-14 | Lamar | Georgia | 13171 | 41 | 1 |
145663 | 145663 | 2020-05-15 | Lamar | Georgia | 13171 | 41 | 1 |
148666 | 148666 | 2020-05-16 | Lamar | Georgia | 13171 | 41 | 1 |
151675 | 151675 | 2020-05-17 | Lamar | Georgia | 13171 | 41 | 1 |
154687 | 154687 | 2020-05-18 | Lamar | Georgia | 13171 | 41 | 1 |
157703 | 157703 | 2020-05-19 | Lamar | Georgia | 13171 | 44 | 1 |
160729 | 160729 | 2020-05-20 | Lamar | Georgia | 13171 | 44 | 1 |
163757 | 163757 | 2020-05-21 | Lamar | Georgia | 13171 | 46 | 1 |
166790 | 166790 | 2020-05-22 | Lamar | Georgia | 13171 | 50 | 1 |
169827 | 169827 | 2020-05-23 | Lamar | Georgia | 13171 | 50 | 1 |
172868 | 172868 | 2020-05-24 | Lamar | Georgia | 13171 | 51 | 1 |
175911 | 175911 | 2020-05-25 | Lamar | Georgia | 13171 | 53 | 1 |
178955 | 178955 | 2020-05-26 | Lamar | Georgia | 13171 | 57 | 1 |
181999 | 181999 | 2020-05-27 | Lamar | Georgia | 13171 | 60 | 1 |
185053 | 185053 | 2020-05-28 | Lamar | Georgia | 13171 | 66 | 1 |
188109 | 188109 | 2020-05-29 | Lamar | Georgia | 13171 | 67 | 1 |
191174 | 191174 | 2020-05-30 | Lamar | Georgia | 13171 | 67 | 2 |
194241 | 194241 | 2020-05-31 | Lamar | Georgia | 13171 | 67 | 2 |
197311 | 197311 | 2020-06-01 | Lamar | Georgia | 13171 | 71 | 2 |
200384 | 200384 | 2020-06-02 | Lamar | Georgia | 13171 | 71 | 2 |
203460 | 203460 | 2020-06-03 | Lamar | Georgia | 13171 | 73 | 2 |
206540 | 206540 | 2020-06-04 | Lamar | Georgia | 13171 | 75 | 2 |
209621 | 209621 | 2020-06-05 | Lamar | Georgia | 13171 | 76 | 3 |
212706 | 212706 | 2020-06-06 | Lamar | Georgia | 13171 | 76 | 3 |
215793 | 215793 | 2020-06-07 | Lamar | Georgia | 13171 | 76 | 3 |
218884 | 218884 | 2020-06-08 | Lamar | Georgia | 13171 | 76 | 3 |
221979 | 221979 | 2020-06-09 | Lamar | Georgia | 13171 | 76 | 4 |
225074 | 225074 | 2020-06-10 | Lamar | Georgia | 13171 | 78 | 5 |
228176 | 228176 | 2020-06-11 | Lamar | Georgia | 13171 | 79 | 5 |
231279 | 231279 | 2020-06-12 | Lamar | Georgia | 13171 | 79 | 5 |
234385 | 234385 | 2020-06-13 | Lamar | Georgia | 13171 | 79 | 5 |
237492 | 237492 | 2020-06-14 | Lamar | Georgia | 13171 | 79 | 5 |
240600 | 240600 | 2020-06-15 | Lamar | Georgia | 13171 | 79 | 5 |
243711 | 243711 | 2020-06-16 | Lamar | Georgia | 13171 | 79 | 5 |
246824 | 246824 | 2020-06-17 | Lamar | Georgia | 13171 | 84 | 5 |
249936 | 249936 | 2020-06-18 | Lamar | Georgia | 13171 | 85 | 5 |
253051 | 253051 | 2020-06-19 | Lamar | Georgia | 13171 | 86 | 5 |
256170 | 256170 | 2020-06-20 | Lamar | Georgia | 13171 | 87 | 6 |
259297 | 259297 | 2020-06-21 | Lamar | Georgia | 13171 | 87 | 6 |
262424 | 262424 | 2020-06-22 | Lamar | Georgia | 13171 | 91 | 6 |
265552 | 265552 | 2020-06-23 | Lamar | Georgia | 13171 | 95 | 6 |
268682 | 268682 | 2020-06-24 | Lamar | Georgia | 13171 | 102 | 6 |
271818 | 271818 | 2020-06-25 | Lamar | Georgia | 13171 | 107 | 6 |
274958 | 274958 | 2020-06-26 | Lamar | Georgia | 13171 | 107 | 6 |
278106 | 278106 | 2020-06-27 | Lamar | Georgia | 13171 | 110 | 6 |
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);