ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Broward", fips = 12011 and state = "Florida" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
605 | 605 | 2020-03-06 | Broward | Florida | 12011 | 2 | 0 |
684 | 684 | 2020-03-07 | Broward | Florida | 12011 | 2 | 0 |
780 | 780 | 2020-03-08 | Broward | Florida | 12011 | 3 | 0 |
897 | 897 | 2020-03-09 | Broward | Florida | 12011 | 3 | 0 |
1033 | 1033 | 2020-03-10 | Broward | Florida | 12011 | 4 | 0 |
1202 | 1202 | 2020-03-11 | Broward | Florida | 12011 | 5 | 0 |
1411 | 1411 | 2020-03-12 | Broward | Florida | 12011 | 12 | 0 |
1677 | 1677 | 2020-03-13 | Broward | Florida | 12011 | 21 | 0 |
1999 | 1999 | 2020-03-14 | Broward | Florida | 12011 | 21 | 0 |
2382 | 2382 | 2020-03-15 | Broward | Florida | 12011 | 37 | 0 |
2817 | 2817 | 2020-03-16 | Broward | Florida | 12011 | 39 | 0 |
3301 | 3301 | 2020-03-17 | Broward | Florida | 12011 | 55 | 1 |
3858 | 3858 | 2020-03-18 | Broward | Florida | 12011 | 80 | 1 |
4523 | 4523 | 2020-03-19 | Broward | Florida | 12011 | 96 | 1 |
5302 | 5302 | 2020-03-20 | Broward | Florida | 12011 | 128 | 2 |
6230 | 6230 | 2020-03-21 | Broward | Florida | 12011 | 164 | 3 |
7267 | 7267 | 2020-03-22 | Broward | Florida | 12011 | 217 | 3 |
8413 | 8413 | 2020-03-23 | Broward | Florida | 12011 | 262 | 3 |
9658 | 9658 | 2020-03-24 | Broward | Florida | 12011 | 312 | 3 |
11032 | 11032 | 2020-03-25 | Broward | Florida | 12011 | 412 | 3 |
12580 | 12580 | 2020-03-26 | Broward | Florida | 12011 | 505 | 3 |
14249 | 14249 | 2020-03-27 | Broward | Florida | 12011 | 631 | 10 |
16033 | 16033 | 2020-03-28 | Broward | Florida | 12011 | 820 | 11 |
17925 | 17925 | 2020-03-29 | Broward | Florida | 12011 | 1012 | 11 |
19905 | 19905 | 2020-03-30 | Broward | Florida | 12011 | 1137 | 12 |
21982 | 21982 | 2020-03-31 | Broward | Florida | 12011 | 1219 | 12 |
24141 | 24141 | 2020-04-01 | Broward | Florida | 12011 | 1348 | 13 |
26371 | 26371 | 2020-04-02 | Broward | Florida | 12011 | 1481 | 17 |
28673 | 28673 | 2020-04-03 | Broward | Florida | 12011 | 1598 | 22 |
31031 | 31031 | 2020-04-04 | Broward | Florida | 12011 | 1765 | 32 |
33437 | 33437 | 2020-04-05 | Broward | Florida | 12011 | 1886 | 40 |
35882 | 35882 | 2020-04-06 | Broward | Florida | 12011 | 2075 | 47 |
38372 | 38372 | 2020-04-07 | Broward | Florida | 12011 | 2230 | 54 |
40915 | 40915 | 2020-04-08 | Broward | Florida | 12011 | 2365 | 60 |
43489 | 43489 | 2020-04-09 | Broward | Florida | 12011 | 2480 | 67 |
46090 | 46090 | 2020-04-10 | Broward | Florida | 12011 | 2679 | 72 |
48720 | 48720 | 2020-04-11 | Broward | Florida | 12011 | 2844 | 76 |
51381 | 51381 | 2020-04-12 | Broward | Florida | 12011 | 2945 | 76 |
54061 | 54061 | 2020-04-13 | Broward | Florida | 12011 | 3177 | 77 |
56753 | 56753 | 2020-04-14 | Broward | Florida | 12011 | 3261 | 81 |
59461 | 59461 | 2020-04-15 | Broward | Florida | 12011 | 3363 | 94 |
62180 | 62180 | 2020-04-16 | Broward | Florida | 12011 | 3466 | 101 |
64913 | 64913 | 2020-04-17 | Broward | Florida | 12011 | 3688 | 107 |
67661 | 67661 | 2020-04-18 | Broward | Florida | 12011 | 3838 | 115 |
70423 | 70423 | 2020-04-19 | Broward | Florida | 12011 | 3971 | 115 |
73192 | 73192 | 2020-04-20 | Broward | Florida | 12011 | 4078 | 122 |
75968 | 75968 | 2020-04-21 | Broward | Florida | 12011 | 4168 | 126 |
78752 | 78752 | 2020-04-22 | Broward | Florida | 12011 | 4228 | 141 |
81546 | 81546 | 2020-04-23 | Broward | Florida | 12011 | 4431 | 157 |
84346 | 84346 | 2020-04-24 | Broward | Florida | 12011 | 4591 | 162 |
87154 | 87154 | 2020-04-25 | Broward | Florida | 12011 | 4659 | 162 |
89971 | 89971 | 2020-04-26 | Broward | Florida | 12011 | 4729 | 170 |
92789 | 92789 | 2020-04-27 | Broward | Florida | 12011 | 4794 | 174 |
95621 | 95621 | 2020-04-28 | Broward | Florida | 12011 | 4847 | 179 |
98466 | 98466 | 2020-04-29 | Broward | Florida | 12011 | 4898 | 182 |
101316 | 101316 | 2020-04-30 | Broward | Florida | 12011 | 4953 | 185 |
104171 | 104171 | 2020-05-01 | Broward | Florida | 12011 | 5144 | 199 |
107036 | 107036 | 2020-05-02 | Broward | Florida | 12011 | 5257 | 204 |
109905 | 109905 | 2020-05-03 | Broward | Florida | 12011 | 5312 | 207 |
112780 | 112780 | 2020-05-04 | Broward | Florida | 12011 | 5383 | 208 |
115663 | 115663 | 2020-05-05 | Broward | Florida | 12011 | 5492 | 215 |
118623 | 118623 | 2020-05-06 | Broward | Florida | 12011 | 5553 | 219 |
121592 | 121592 | 2020-05-07 | Broward | Florida | 12011 | 5677 | 230 |
124571 | 124571 | 2020-05-08 | Broward | Florida | 12011 | 5688 | 248 |
127558 | 127558 | 2020-05-09 | Broward | Florida | 12011 | 5780 | 257 |
130549 | 130549 | 2020-05-10 | Broward | Florida | 12011 | 5858 | 257 |
133540 | 133540 | 2020-05-11 | Broward | Florida | 12011 | 5882 | 258 |
136529 | 136529 | 2020-05-12 | Broward | Florida | 12011 | 5973 | 258 |
139520 | 139520 | 2020-05-13 | Broward | Florida | 12011 | 5998 | 267 |
142516 | 142516 | 2020-05-14 | Broward | Florida | 12011 | 6057 | 267 |
145516 | 145516 | 2020-05-15 | Broward | Florida | 12011 | 6133 | 272 |
148519 | 148519 | 2020-05-16 | Broward | Florida | 12011 | 6201 | 278 |
151528 | 151528 | 2020-05-17 | Broward | Florida | 12011 | 6243 | 279 |
154540 | 154540 | 2020-05-18 | Broward | Florida | 12011 | 6322 | 281 |
157556 | 157556 | 2020-05-19 | Broward | Florida | 12011 | 6369 | 282 |
160582 | 160582 | 2020-05-20 | Broward | Florida | 12011 | 6407 | 285 |
163610 | 163610 | 2020-05-21 | Broward | Florida | 12011 | 6514 | 286 |
166643 | 166643 | 2020-05-22 | Broward | Florida | 12011 | 6580 | 286 |
169680 | 169680 | 2020-05-23 | Broward | Florida | 12011 | 6649 | 292 |
172721 | 172721 | 2020-05-24 | Broward | Florida | 12011 | 6697 | 292 |
175764 | 175764 | 2020-05-25 | Broward | Florida | 12011 | 6760 | 298 |
178808 | 178808 | 2020-05-26 | Broward | Florida | 12011 | 6799 | 300 |
181852 | 181852 | 2020-05-27 | Broward | Florida | 12011 | 6825 | 305 |
184906 | 184906 | 2020-05-28 | Broward | Florida | 12011 | 6870 | 307 |
187962 | 187962 | 2020-05-29 | Broward | Florida | 12011 | 6975 | 308 |
191027 | 191027 | 2020-05-30 | Broward | Florida | 12011 | 7067 | 313 |
194094 | 194094 | 2020-05-31 | Broward | Florida | 12011 | 7123 | 313 |
197164 | 197164 | 2020-06-01 | Broward | Florida | 12011 | 7196 | 314 |
200237 | 200237 | 2020-06-02 | Broward | Florida | 12011 | 7248 | 317 |
203313 | 203313 | 2020-06-03 | Broward | Florida | 12011 | 7339 | 318 |
206393 | 206393 | 2020-06-04 | Broward | Florida | 12011 | 7462 | 325 |
209474 | 209474 | 2020-06-05 | Broward | Florida | 12011 | 7572 | 327 |
212559 | 212559 | 2020-06-06 | Broward | Florida | 12011 | 7690 | 334 |
215646 | 215646 | 2020-06-07 | Broward | Florida | 12011 | 7804 | 339 |
218737 | 218737 | 2020-06-08 | Broward | Florida | 12011 | 7924 | 343 |
221832 | 221832 | 2020-06-09 | Broward | Florida | 12011 | 8035 | 346 |
224927 | 224927 | 2020-06-10 | Broward | Florida | 12011 | 8193 | 349 |
228029 | 228029 | 2020-06-11 | Broward | Florida | 12011 | 8337 | 351 |
231132 | 231132 | 2020-06-12 | Broward | Florida | 12011 | 8589 | 350 |
234238 | 234238 | 2020-06-13 | Broward | Florida | 12011 | 8864 | 357 |
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);