ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "St. Lucie" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
293756 | 293756 | 2020-07-02 | St. Lucie | Florida | 12111 | 1876 | 49 |
290602 | 290602 | 2020-07-01 | St. Lucie | Florida | 12111 | 1812 | 48 |
287451 | 287451 | 2020-06-30 | St. Lucie | Florida | 12111 | 1724 | 47 |
284305 | 284305 | 2020-06-29 | St. Lucie | Florida | 12111 | 1691 | 45 |
281159 | 281159 | 2020-06-28 | St. Lucie | Florida | 12111 | 1652 | 45 |
278012 | 278012 | 2020-06-27 | St. Lucie | Florida | 12111 | 1576 | 45 |
274864 | 274864 | 2020-06-26 | St. Lucie | Florida | 12111 | 1441 | 45 |
271724 | 271724 | 2020-06-25 | St. Lucie | Florida | 12111 | 1384 | 45 |
268588 | 268588 | 2020-06-24 | St. Lucie | Florida | 12111 | 1333 | 43 |
265458 | 265458 | 2020-06-23 | St. Lucie | Florida | 12111 | 1249 | 42 |
262330 | 262330 | 2020-06-22 | St. Lucie | Florida | 12111 | 1226 | 41 |
259203 | 259203 | 2020-06-21 | St. Lucie | Florida | 12111 | 1214 | 41 |
256076 | 256076 | 2020-06-20 | St. Lucie | Florida | 12111 | 1169 | 41 |
252957 | 252957 | 2020-06-19 | St. Lucie | Florida | 12111 | 1131 | 40 |
249842 | 249842 | 2020-06-18 | St. Lucie | Florida | 12111 | 1057 | 40 |
246730 | 246730 | 2020-06-17 | St. Lucie | Florida | 12111 | 1037 | 40 |
243617 | 243617 | 2020-06-16 | St. Lucie | Florida | 12111 | 981 | 38 |
240506 | 240506 | 2020-06-15 | St. Lucie | Florida | 12111 | 926 | 36 |
237398 | 237398 | 2020-06-14 | St. Lucie | Florida | 12111 | 883 | 36 |
234291 | 234291 | 2020-06-13 | St. Lucie | Florida | 12111 | 830 | 35 |
231185 | 231185 | 2020-06-12 | St. Lucie | Florida | 12111 | 793 | 33 |
228082 | 228082 | 2020-06-11 | St. Lucie | Florida | 12111 | 760 | 33 |
224980 | 224980 | 2020-06-10 | St. Lucie | Florida | 12111 | 696 | 31 |
221885 | 221885 | 2020-06-09 | St. Lucie | Florida | 12111 | 669 | 31 |
218790 | 218790 | 2020-06-08 | St. Lucie | Florida | 12111 | 654 | 31 |
215699 | 215699 | 2020-06-07 | St. Lucie | Florida | 12111 | 627 | 31 |
212612 | 212612 | 2020-06-06 | St. Lucie | Florida | 12111 | 607 | 31 |
209527 | 209527 | 2020-06-05 | St. Lucie | Florida | 12111 | 561 | 31 |
206446 | 206446 | 2020-06-04 | St. Lucie | Florida | 12111 | 535 | 31 |
203366 | 203366 | 2020-06-03 | St. Lucie | Florida | 12111 | 508 | 31 |
200290 | 200290 | 2020-06-02 | St. Lucie | Florida | 12111 | 492 | 31 |
197217 | 197217 | 2020-06-01 | St. Lucie | Florida | 12111 | 473 | 30 |
194147 | 194147 | 2020-05-31 | St. Lucie | Florida | 12111 | 471 | 30 |
191080 | 191080 | 2020-05-30 | St. Lucie | Florida | 12111 | 463 | 30 |
188015 | 188015 | 2020-05-29 | St. Lucie | Florida | 12111 | 449 | 30 |
184959 | 184959 | 2020-05-28 | St. Lucie | Florida | 12111 | 424 | 30 |
181905 | 181905 | 2020-05-27 | St. Lucie | Florida | 12111 | 420 | 29 |
178861 | 178861 | 2020-05-26 | St. Lucie | Florida | 12111 | 413 | 29 |
175817 | 175817 | 2020-05-25 | St. Lucie | Florida | 12111 | 404 | 29 |
172774 | 172774 | 2020-05-24 | St. Lucie | Florida | 12111 | 391 | 28 |
169733 | 169733 | 2020-05-23 | St. Lucie | Florida | 12111 | 386 | 28 |
166696 | 166696 | 2020-05-22 | St. Lucie | Florida | 12111 | 363 | 28 |
163663 | 163663 | 2020-05-21 | St. Lucie | Florida | 12111 | 349 | 28 |
160635 | 160635 | 2020-05-20 | St. Lucie | Florida | 12111 | 336 | 28 |
157609 | 157609 | 2020-05-19 | St. Lucie | Florida | 12111 | 337 | 28 |
154593 | 154593 | 2020-05-18 | St. Lucie | Florida | 12111 | 334 | 27 |
151581 | 151581 | 2020-05-17 | St. Lucie | Florida | 12111 | 323 | 27 |
148572 | 148572 | 2020-05-16 | St. Lucie | Florida | 12111 | 316 | 27 |
145569 | 145569 | 2020-05-15 | St. Lucie | Florida | 12111 | 313 | 27 |
142569 | 142569 | 2020-05-14 | St. Lucie | Florida | 12111 | 301 | 26 |
139573 | 139573 | 2020-05-13 | St. Lucie | Florida | 12111 | 299 | 26 |
136582 | 136582 | 2020-05-12 | St. Lucie | Florida | 12111 | 290 | 26 |
133593 | 133593 | 2020-05-11 | St. Lucie | Florida | 12111 | 284 | 25 |
130602 | 130602 | 2020-05-10 | St. Lucie | Florida | 12111 | 282 | 25 |
127611 | 127611 | 2020-05-09 | St. Lucie | Florida | 12111 | 280 | 25 |
124624 | 124624 | 2020-05-08 | St. Lucie | Florida | 12111 | 275 | 25 |
121645 | 121645 | 2020-05-07 | St. Lucie | Florida | 12111 | 271 | 25 |
118676 | 118676 | 2020-05-06 | St. Lucie | Florida | 12111 | 265 | 25 |
115716 | 115716 | 2020-05-05 | St. Lucie | Florida | 12111 | 260 | 25 |
112833 | 112833 | 2020-05-04 | St. Lucie | Florida | 12111 | 260 | 25 |
109958 | 109958 | 2020-05-03 | St. Lucie | Florida | 12111 | 257 | 24 |
107089 | 107089 | 2020-05-02 | St. Lucie | Florida | 12111 | 254 | 24 |
104224 | 104224 | 2020-05-01 | St. Lucie | Florida | 12111 | 249 | 23 |
101369 | 101369 | 2020-04-30 | St. Lucie | Florida | 12111 | 247 | 22 |
98519 | 98519 | 2020-04-29 | St. Lucie | Florida | 12111 | 239 | 22 |
95674 | 95674 | 2020-04-28 | St. Lucie | Florida | 12111 | 239 | 22 |
92842 | 92842 | 2020-04-27 | St. Lucie | Florida | 12111 | 236 | 20 |
90024 | 90024 | 2020-04-26 | St. Lucie | Florida | 12111 | 228 | 19 |
87207 | 87207 | 2020-04-25 | St. Lucie | Florida | 12111 | 225 | 19 |
84399 | 84399 | 2020-04-24 | St. Lucie | Florida | 12111 | 223 | 19 |
81599 | 81599 | 2020-04-23 | St. Lucie | Florida | 12111 | 220 | 17 |
78805 | 78805 | 2020-04-22 | St. Lucie | Florida | 12111 | 207 | 16 |
76021 | 76021 | 2020-04-21 | St. Lucie | Florida | 12111 | 206 | 16 |
73245 | 73245 | 2020-04-20 | St. Lucie | Florida | 12111 | 204 | 15 |
70476 | 70476 | 2020-04-19 | St. Lucie | Florida | 12111 | 202 | 15 |
67714 | 67714 | 2020-04-18 | St. Lucie | Florida | 12111 | 196 | 13 |
64966 | 64966 | 2020-04-17 | St. Lucie | Florida | 12111 | 191 | 11 |
62233 | 62233 | 2020-04-16 | St. Lucie | Florida | 12111 | 186 | 9 |
59514 | 59514 | 2020-04-15 | St. Lucie | Florida | 12111 | 172 | 8 |
56806 | 56806 | 2020-04-14 | St. Lucie | Florida | 12111 | 165 | 8 |
54114 | 54114 | 2020-04-13 | St. Lucie | Florida | 12111 | 161 | 7 |
51434 | 51434 | 2020-04-12 | St. Lucie | Florida | 12111 | 152 | 6 |
48773 | 48773 | 2020-04-11 | St. Lucie | Florida | 12111 | 149 | 6 |
46143 | 46143 | 2020-04-10 | St. Lucie | Florida | 12111 | 146 | 6 |
43541 | 43541 | 2020-04-09 | St. Lucie | Florida | 12111 | 137 | 6 |
40967 | 40967 | 2020-04-08 | St. Lucie | Florida | 12111 | 129 | 6 |
38423 | 38423 | 2020-04-07 | St. Lucie | Florida | 12111 | 122 | 6 |
35932 | 35932 | 2020-04-06 | St. Lucie | Florida | 12111 | 107 | 5 |
33486 | 33486 | 2020-04-05 | St. Lucie | Florida | 12111 | 82 | 3 |
31080 | 31080 | 2020-04-04 | St. Lucie | Florida | 12111 | 76 | 3 |
28720 | 28720 | 2020-04-03 | St. Lucie | Florida | 12111 | 60 | 3 |
26417 | 26417 | 2020-04-02 | St. Lucie | Florida | 12111 | 48 | 3 |
24187 | 24187 | 2020-04-01 | St. Lucie | Florida | 12111 | 47 | 2 |
22024 | 22024 | 2020-03-31 | St. Lucie | Florida | 12111 | 38 | 2 |
19946 | 19946 | 2020-03-30 | St. Lucie | Florida | 12111 | 31 | 2 |
17965 | 17965 | 2020-03-29 | St. Lucie | Florida | 12111 | 24 | 2 |
16072 | 16072 | 2020-03-28 | St. Lucie | Florida | 12111 | 22 | 2 |
14287 | 14287 | 2020-03-27 | St. Lucie | Florida | 12111 | 17 | 1 |
12617 | 12617 | 2020-03-26 | St. Lucie | Florida | 12111 | 11 | 0 |
11069 | 11069 | 2020-03-25 | St. Lucie | Florida | 12111 | 9 | 0 |
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);