ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 12011 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
293703 | 293703 | 2020-07-02 | Broward | Florida | 12011 | 17116 | 394 |
290549 | 290549 | 2020-07-01 | Broward | Florida | 12011 | 16155 | 385 |
287398 | 287398 | 2020-06-30 | Broward | Florida | 12011 | 15624 | 383 |
284252 | 284252 | 2020-06-29 | Broward | Florida | 12011 | 15045 | 382 |
281106 | 281106 | 2020-06-28 | Broward | Florida | 12011 | 14620 | 382 |
277959 | 277959 | 2020-06-27 | Broward | Florida | 12011 | 14046 | 382 |
274811 | 274811 | 2020-06-26 | Broward | Florida | 12011 | 13320 | 381 |
271671 | 271671 | 2020-06-25 | Broward | Florida | 12011 | 12584 | 379 |
268535 | 268535 | 2020-06-24 | Broward | Florida | 12011 | 12217 | 378 |
265405 | 265405 | 2020-06-23 | Broward | Florida | 12011 | 11744 | 377 |
262277 | 262277 | 2020-06-22 | Broward | Florida | 12011 | 11327 | 373 |
259150 | 259150 | 2020-06-21 | Broward | Florida | 12011 | 11155 | 373 |
256023 | 256023 | 2020-06-20 | Broward | Florida | 12011 | 10837 | 370 |
252904 | 252904 | 2020-06-19 | Broward | Florida | 12011 | 10448 | 367 |
249789 | 249789 | 2020-06-18 | Broward | Florida | 12011 | 10111 | 365 |
246677 | 246677 | 2020-06-17 | Broward | Florida | 12011 | 9812 | 360 |
243564 | 243564 | 2020-06-16 | Broward | Florida | 12011 | 9498 | 358 |
240453 | 240453 | 2020-06-15 | Broward | Florida | 12011 | 9086 | 358 |
237345 | 237345 | 2020-06-14 | Broward | Florida | 12011 | 8928 | 357 |
234238 | 234238 | 2020-06-13 | Broward | Florida | 12011 | 8864 | 357 |
231132 | 231132 | 2020-06-12 | Broward | Florida | 12011 | 8589 | 350 |
228029 | 228029 | 2020-06-11 | Broward | Florida | 12011 | 8337 | 351 |
224927 | 224927 | 2020-06-10 | Broward | Florida | 12011 | 8193 | 349 |
221832 | 221832 | 2020-06-09 | Broward | Florida | 12011 | 8035 | 346 |
218737 | 218737 | 2020-06-08 | Broward | Florida | 12011 | 7924 | 343 |
215646 | 215646 | 2020-06-07 | Broward | Florida | 12011 | 7804 | 339 |
212559 | 212559 | 2020-06-06 | Broward | Florida | 12011 | 7690 | 334 |
209474 | 209474 | 2020-06-05 | Broward | Florida | 12011 | 7572 | 327 |
206393 | 206393 | 2020-06-04 | Broward | Florida | 12011 | 7462 | 325 |
203313 | 203313 | 2020-06-03 | Broward | Florida | 12011 | 7339 | 318 |
200237 | 200237 | 2020-06-02 | Broward | Florida | 12011 | 7248 | 317 |
197164 | 197164 | 2020-06-01 | Broward | Florida | 12011 | 7196 | 314 |
194094 | 194094 | 2020-05-31 | Broward | Florida | 12011 | 7123 | 313 |
191027 | 191027 | 2020-05-30 | Broward | Florida | 12011 | 7067 | 313 |
187962 | 187962 | 2020-05-29 | Broward | Florida | 12011 | 6975 | 308 |
184906 | 184906 | 2020-05-28 | Broward | Florida | 12011 | 6870 | 307 |
181852 | 181852 | 2020-05-27 | Broward | Florida | 12011 | 6825 | 305 |
178808 | 178808 | 2020-05-26 | Broward | Florida | 12011 | 6799 | 300 |
175764 | 175764 | 2020-05-25 | Broward | Florida | 12011 | 6760 | 298 |
172721 | 172721 | 2020-05-24 | Broward | Florida | 12011 | 6697 | 292 |
169680 | 169680 | 2020-05-23 | Broward | Florida | 12011 | 6649 | 292 |
166643 | 166643 | 2020-05-22 | Broward | Florida | 12011 | 6580 | 286 |
163610 | 163610 | 2020-05-21 | Broward | Florida | 12011 | 6514 | 286 |
160582 | 160582 | 2020-05-20 | Broward | Florida | 12011 | 6407 | 285 |
157556 | 157556 | 2020-05-19 | Broward | Florida | 12011 | 6369 | 282 |
154540 | 154540 | 2020-05-18 | Broward | Florida | 12011 | 6322 | 281 |
151528 | 151528 | 2020-05-17 | Broward | Florida | 12011 | 6243 | 279 |
148519 | 148519 | 2020-05-16 | Broward | Florida | 12011 | 6201 | 278 |
145516 | 145516 | 2020-05-15 | Broward | Florida | 12011 | 6133 | 272 |
142516 | 142516 | 2020-05-14 | Broward | Florida | 12011 | 6057 | 267 |
139520 | 139520 | 2020-05-13 | Broward | Florida | 12011 | 5998 | 267 |
136529 | 136529 | 2020-05-12 | Broward | Florida | 12011 | 5973 | 258 |
133540 | 133540 | 2020-05-11 | Broward | Florida | 12011 | 5882 | 258 |
130549 | 130549 | 2020-05-10 | Broward | Florida | 12011 | 5858 | 257 |
127558 | 127558 | 2020-05-09 | Broward | Florida | 12011 | 5780 | 257 |
124571 | 124571 | 2020-05-08 | Broward | Florida | 12011 | 5688 | 248 |
121592 | 121592 | 2020-05-07 | Broward | Florida | 12011 | 5677 | 230 |
118623 | 118623 | 2020-05-06 | Broward | Florida | 12011 | 5553 | 219 |
115663 | 115663 | 2020-05-05 | Broward | Florida | 12011 | 5492 | 215 |
112780 | 112780 | 2020-05-04 | Broward | Florida | 12011 | 5383 | 208 |
109905 | 109905 | 2020-05-03 | Broward | Florida | 12011 | 5312 | 207 |
107036 | 107036 | 2020-05-02 | Broward | Florida | 12011 | 5257 | 204 |
104171 | 104171 | 2020-05-01 | Broward | Florida | 12011 | 5144 | 199 |
101316 | 101316 | 2020-04-30 | Broward | Florida | 12011 | 4953 | 185 |
98466 | 98466 | 2020-04-29 | Broward | Florida | 12011 | 4898 | 182 |
95621 | 95621 | 2020-04-28 | Broward | Florida | 12011 | 4847 | 179 |
92789 | 92789 | 2020-04-27 | Broward | Florida | 12011 | 4794 | 174 |
89971 | 89971 | 2020-04-26 | Broward | Florida | 12011 | 4729 | 170 |
87154 | 87154 | 2020-04-25 | Broward | Florida | 12011 | 4659 | 162 |
84346 | 84346 | 2020-04-24 | Broward | Florida | 12011 | 4591 | 162 |
81546 | 81546 | 2020-04-23 | Broward | Florida | 12011 | 4431 | 157 |
78752 | 78752 | 2020-04-22 | Broward | Florida | 12011 | 4228 | 141 |
75968 | 75968 | 2020-04-21 | Broward | Florida | 12011 | 4168 | 126 |
73192 | 73192 | 2020-04-20 | Broward | Florida | 12011 | 4078 | 122 |
70423 | 70423 | 2020-04-19 | Broward | Florida | 12011 | 3971 | 115 |
67661 | 67661 | 2020-04-18 | Broward | Florida | 12011 | 3838 | 115 |
64913 | 64913 | 2020-04-17 | Broward | Florida | 12011 | 3688 | 107 |
62180 | 62180 | 2020-04-16 | Broward | Florida | 12011 | 3466 | 101 |
59461 | 59461 | 2020-04-15 | Broward | Florida | 12011 | 3363 | 94 |
56753 | 56753 | 2020-04-14 | Broward | Florida | 12011 | 3261 | 81 |
54061 | 54061 | 2020-04-13 | Broward | Florida | 12011 | 3177 | 77 |
51381 | 51381 | 2020-04-12 | Broward | Florida | 12011 | 2945 | 76 |
48720 | 48720 | 2020-04-11 | Broward | Florida | 12011 | 2844 | 76 |
46090 | 46090 | 2020-04-10 | Broward | Florida | 12011 | 2679 | 72 |
43489 | 43489 | 2020-04-09 | Broward | Florida | 12011 | 2480 | 67 |
40915 | 40915 | 2020-04-08 | Broward | Florida | 12011 | 2365 | 60 |
38372 | 38372 | 2020-04-07 | Broward | Florida | 12011 | 2230 | 54 |
35882 | 35882 | 2020-04-06 | Broward | Florida | 12011 | 2075 | 47 |
33437 | 33437 | 2020-04-05 | Broward | Florida | 12011 | 1886 | 40 |
31031 | 31031 | 2020-04-04 | Broward | Florida | 12011 | 1765 | 32 |
28673 | 28673 | 2020-04-03 | Broward | Florida | 12011 | 1598 | 22 |
26371 | 26371 | 2020-04-02 | Broward | Florida | 12011 | 1481 | 17 |
24141 | 24141 | 2020-04-01 | Broward | Florida | 12011 | 1348 | 13 |
21982 | 21982 | 2020-03-31 | Broward | Florida | 12011 | 1219 | 12 |
19905 | 19905 | 2020-03-30 | Broward | Florida | 12011 | 1137 | 12 |
17925 | 17925 | 2020-03-29 | Broward | Florida | 12011 | 1012 | 11 |
16033 | 16033 | 2020-03-28 | Broward | Florida | 12011 | 820 | 11 |
14249 | 14249 | 2020-03-27 | Broward | Florida | 12011 | 631 | 10 |
12580 | 12580 | 2020-03-26 | Broward | Florida | 12011 | 505 | 3 |
11032 | 11032 | 2020-03-25 | Broward | Florida | 12011 | 412 | 3 |
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);