ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Union" and state = "Florida" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
22027 | 22027 | 2020-03-31 | Union | Florida | 12125 | 1 | 0 |
24190 | 24190 | 2020-04-01 | Union | Florida | 12125 | 1 | 0 |
26420 | 26420 | 2020-04-02 | Union | Florida | 12125 | 1 | 0 |
28723 | 28723 | 2020-04-03 | Union | Florida | 12125 | 1 | 0 |
31083 | 31083 | 2020-04-04 | Union | Florida | 12125 | 1 | 0 |
33489 | 33489 | 2020-04-05 | Union | Florida | 12125 | 2 | 0 |
35935 | 35935 | 2020-04-06 | Union | Florida | 12125 | 2 | 0 |
38427 | 38427 | 2020-04-07 | Union | Florida | 12125 | 2 | 0 |
40971 | 40971 | 2020-04-08 | Union | Florida | 12125 | 2 | 0 |
43545 | 43545 | 2020-04-09 | Union | Florida | 12125 | 2 | 0 |
46147 | 46147 | 2020-04-10 | Union | Florida | 12125 | 2 | 0 |
48777 | 48777 | 2020-04-11 | Union | Florida | 12125 | 2 | 0 |
51438 | 51438 | 2020-04-12 | Union | Florida | 12125 | 2 | 0 |
54118 | 54118 | 2020-04-13 | Union | Florida | 12125 | 2 | 0 |
56810 | 56810 | 2020-04-14 | Union | Florida | 12125 | 2 | 0 |
59518 | 59518 | 2020-04-15 | Union | Florida | 12125 | 2 | 0 |
62237 | 62237 | 2020-04-16 | Union | Florida | 12125 | 2 | 0 |
64970 | 64970 | 2020-04-17 | Union | Florida | 12125 | 2 | 0 |
67718 | 67718 | 2020-04-18 | Union | Florida | 12125 | 2 | 0 |
70480 | 70480 | 2020-04-19 | Union | Florida | 12125 | 3 | 0 |
73249 | 73249 | 2020-04-20 | Union | Florida | 12125 | 2 | 0 |
76025 | 76025 | 2020-04-21 | Union | Florida | 12125 | 3 | 0 |
78809 | 78809 | 2020-04-22 | Union | Florida | 12125 | 3 | 0 |
81603 | 81603 | 2020-04-23 | Union | Florida | 12125 | 3 | 0 |
84403 | 84403 | 2020-04-24 | Union | Florida | 12125 | 4 | 0 |
87211 | 87211 | 2020-04-25 | Union | Florida | 12125 | 4 | 0 |
90028 | 90028 | 2020-04-26 | Union | Florida | 12125 | 4 | 0 |
92846 | 92846 | 2020-04-27 | Union | Florida | 12125 | 4 | 0 |
95678 | 95678 | 2020-04-28 | Union | Florida | 12125 | 4 | 0 |
98523 | 98523 | 2020-04-29 | Union | Florida | 12125 | 4 | 0 |
101373 | 101373 | 2020-04-30 | Union | Florida | 12125 | 4 | 0 |
104228 | 104228 | 2020-05-01 | Union | Florida | 12125 | 5 | 0 |
107093 | 107093 | 2020-05-02 | Union | Florida | 12125 | 5 | 0 |
109962 | 109962 | 2020-05-03 | Union | Florida | 12125 | 5 | 0 |
112837 | 112837 | 2020-05-04 | Union | Florida | 12125 | 5 | 0 |
115720 | 115720 | 2020-05-05 | Union | Florida | 12125 | 5 | 0 |
118680 | 118680 | 2020-05-06 | Union | Florida | 12125 | 5 | 0 |
121649 | 121649 | 2020-05-07 | Union | Florida | 12125 | 5 | 0 |
124628 | 124628 | 2020-05-08 | Union | Florida | 12125 | 5 | 0 |
127615 | 127615 | 2020-05-09 | Union | Florida | 12125 | 6 | 0 |
130606 | 130606 | 2020-05-10 | Union | Florida | 12125 | 6 | 0 |
133597 | 133597 | 2020-05-11 | Union | Florida | 12125 | 7 | 0 |
136586 | 136586 | 2020-05-12 | Union | Florida | 12125 | 7 | 0 |
139577 | 139577 | 2020-05-13 | Union | Florida | 12125 | 10 | 0 |
142573 | 142573 | 2020-05-14 | Union | Florida | 12125 | 14 | 0 |
145573 | 145573 | 2020-05-15 | Union | Florida | 12125 | 14 | 0 |
148576 | 148576 | 2020-05-16 | Union | Florida | 12125 | 20 | 0 |
151585 | 151585 | 2020-05-17 | Union | Florida | 12125 | 25 | 0 |
154597 | 154597 | 2020-05-18 | Union | Florida | 12125 | 25 | 0 |
157613 | 157613 | 2020-05-19 | Union | Florida | 12125 | 26 | 0 |
160639 | 160639 | 2020-05-20 | Union | Florida | 12125 | 26 | 0 |
163667 | 163667 | 2020-05-21 | Union | Florida | 12125 | 28 | 0 |
166700 | 166700 | 2020-05-22 | Union | Florida | 12125 | 28 | 0 |
169737 | 169737 | 2020-05-23 | Union | Florida | 12125 | 29 | 0 |
172778 | 172778 | 2020-05-24 | Union | Florida | 12125 | 30 | 0 |
175821 | 175821 | 2020-05-25 | Union | Florida | 12125 | 30 | 0 |
178865 | 178865 | 2020-05-26 | Union | Florida | 12125 | 31 | 0 |
181909 | 181909 | 2020-05-27 | Union | Florida | 12125 | 31 | 0 |
184963 | 184963 | 2020-05-28 | Union | Florida | 12125 | 31 | 0 |
188019 | 188019 | 2020-05-29 | Union | Florida | 12125 | 31 | 1 |
191084 | 191084 | 2020-05-30 | Union | Florida | 12125 | 31 | 1 |
194151 | 194151 | 2020-05-31 | Union | Florida | 12125 | 32 | 1 |
197221 | 197221 | 2020-06-01 | Union | Florida | 12125 | 32 | 1 |
200294 | 200294 | 2020-06-02 | Union | Florida | 12125 | 33 | 1 |
203370 | 203370 | 2020-06-03 | Union | Florida | 12125 | 33 | 1 |
206450 | 206450 | 2020-06-04 | Union | Florida | 12125 | 34 | 1 |
209531 | 209531 | 2020-06-05 | Union | Florida | 12125 | 34 | 1 |
212616 | 212616 | 2020-06-06 | Union | Florida | 12125 | 36 | 1 |
215703 | 215703 | 2020-06-07 | Union | Florida | 12125 | 38 | 1 |
218794 | 218794 | 2020-06-08 | Union | Florida | 12125 | 38 | 1 |
221889 | 221889 | 2020-06-09 | Union | Florida | 12125 | 38 | 1 |
224984 | 224984 | 2020-06-10 | Union | Florida | 12125 | 38 | 1 |
228086 | 228086 | 2020-06-11 | Union | Florida | 12125 | 38 | 1 |
231189 | 231189 | 2020-06-12 | Union | Florida | 12125 | 38 | 1 |
234295 | 234295 | 2020-06-13 | Union | Florida | 12125 | 39 | 1 |
237402 | 237402 | 2020-06-14 | Union | Florida | 12125 | 38 | 1 |
240510 | 240510 | 2020-06-15 | Union | Florida | 12125 | 38 | 1 |
243621 | 243621 | 2020-06-16 | Union | Florida | 12125 | 38 | 1 |
246734 | 246734 | 2020-06-17 | Union | Florida | 12125 | 38 | 1 |
249846 | 249846 | 2020-06-18 | Union | Florida | 12125 | 38 | 1 |
252961 | 252961 | 2020-06-19 | Union | Florida | 12125 | 39 | 2 |
256080 | 256080 | 2020-06-20 | Union | Florida | 12125 | 40 | 2 |
259207 | 259207 | 2020-06-21 | Union | Florida | 12125 | 41 | 2 |
262334 | 262334 | 2020-06-22 | Union | Florida | 12125 | 42 | 2 |
265462 | 265462 | 2020-06-23 | Union | Florida | 12125 | 43 | 2 |
268592 | 268592 | 2020-06-24 | Union | Florida | 12125 | 44 | 2 |
271728 | 271728 | 2020-06-25 | Union | Florida | 12125 | 46 | 2 |
274868 | 274868 | 2020-06-26 | Union | Florida | 12125 | 48 | 2 |
278016 | 278016 | 2020-06-27 | Union | Florida | 12125 | 58 | 2 |
281163 | 281163 | 2020-06-28 | Union | Florida | 12125 | 61 | 2 |
284309 | 284309 | 2020-06-29 | Union | Florida | 12125 | 61 | 2 |
287455 | 287455 | 2020-06-30 | Union | Florida | 12125 | 62 | 2 |
290606 | 290606 | 2020-07-01 | Union | Florida | 12125 | 62 | 2 |
293760 | 293760 | 2020-07-02 | Union | Florida | 12125 | 71 | 2 |
296916 | 296916 | 2020-07-03 | Union | Florida | 12125 | 74 | 2 |
300078 | 300078 | 2020-07-04 | Union | Florida | 12125 | 82 | 2 |
303242 | 303242 | 2020-07-05 | Union | Florida | 12125 | 85 | 2 |
306406 | 306406 | 2020-07-06 | Union | Florida | 12125 | 89 | 2 |
309574 | 309574 | 2020-07-07 | Union | Florida | 12125 | 92 | 2 |
312744 | 312744 | 2020-07-08 | Union | Florida | 12125 | 99 | 2 |
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);