ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Florida" and state = "Puerto Rico" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-05-05 1
- 2020-05-06 1
- 2020-05-07 1
- 2020-05-08 1
- 2020-05-09 1
- 2020-05-10 1
- 2020-05-11 1
- 2020-05-12 1
- 2020-05-13 1
- 2020-05-14 1
- 2020-05-15 1
- 2020-05-16 1
- 2020-05-17 1
- 2020-05-18 1
- 2020-05-19 1
- 2020-05-20 1
- 2020-05-21 1
- 2020-05-22 1
- 2020-05-23 1
- 2020-05-24 1
- 2020-05-25 1
- 2020-05-26 1
- 2020-05-27 1
- 2020-05-28 1
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- …
state 1
- Puerto Rico · 739 ✖
fips 1
- 72054 739
county 1
- Florida · 739 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
117513 | 117513 | 2020-05-05 | Florida | Puerto Rico | 72054 | 4 | |
120475 | 120475 | 2020-05-06 | Florida | Puerto Rico | 72054 | 3 | |
123452 | 123452 | 2020-05-07 | Florida | Puerto Rico | 72054 | 5 | |
126435 | 126435 | 2020-05-08 | Florida | Puerto Rico | 72054 | 5 | |
129424 | 129424 | 2020-05-09 | Florida | Puerto Rico | 72054 | 5 | |
132413 | 132413 | 2020-05-10 | Florida | Puerto Rico | 72054 | 5 | |
135404 | 135404 | 2020-05-11 | Florida | Puerto Rico | 72054 | 5 | |
138394 | 138394 | 2020-05-12 | Florida | Puerto Rico | 72054 | 7 | |
141390 | 141390 | 2020-05-13 | Florida | Puerto Rico | 72054 | 7 | |
144386 | 144386 | 2020-05-14 | Florida | Puerto Rico | 72054 | 7 | |
147387 | 147387 | 2020-05-15 | Florida | Puerto Rico | 72054 | 7 | |
150394 | 150394 | 2020-05-16 | Florida | Puerto Rico | 72054 | 7 | |
153405 | 153405 | 2020-05-17 | Florida | Puerto Rico | 72054 | 7 | |
156422 | 156422 | 2020-05-18 | Florida | Puerto Rico | 72054 | 8 | |
159443 | 159443 | 2020-05-19 | Florida | Puerto Rico | 72054 | 8 | |
162470 | 162470 | 2020-05-20 | Florida | Puerto Rico | 72054 | 8 | |
165499 | 165499 | 2020-05-21 | Florida | Puerto Rico | 72054 | 8 | |
168535 | 168535 | 2020-05-22 | Florida | Puerto Rico | 72054 | 8 | |
171574 | 171574 | 2020-05-23 | Florida | Puerto Rico | 72054 | 10 | |
174616 | 174616 | 2020-05-24 | Florida | Puerto Rico | 72054 | 13 | |
177660 | 177660 | 2020-05-25 | Florida | Puerto Rico | 72054 | 13 | |
180703 | 180703 | 2020-05-26 | Florida | Puerto Rico | 72054 | 13 | |
183753 | 183753 | 2020-05-27 | Florida | Puerto Rico | 72054 | 13 | |
186810 | 186810 | 2020-05-28 | Florida | Puerto Rico | 72054 | 13 | |
189872 | 189872 | 2020-05-29 | Florida | Puerto Rico | 72054 | 13 | |
192937 | 192937 | 2020-05-30 | Florida | Puerto Rico | 72054 | 14 | |
196006 | 196006 | 2020-05-31 | Florida | Puerto Rico | 72054 | 14 | |
199079 | 199079 | 2020-06-01 | Florida | Puerto Rico | 72054 | 14 | |
202154 | 202154 | 2020-06-02 | Florida | Puerto Rico | 72054 | 14 | |
205231 | 205231 | 2020-06-03 | Florida | Puerto Rico | 72054 | 14 | |
208312 | 208312 | 2020-06-04 | Florida | Puerto Rico | 72054 | 21 | |
211394 | 211394 | 2020-06-05 | Florida | Puerto Rico | 72054 | 21 | |
214480 | 214480 | 2020-06-06 | Florida | Puerto Rico | 72054 | 21 | |
217570 | 217570 | 2020-06-07 | Florida | Puerto Rico | 72054 | 22 | |
220662 | 220662 | 2020-06-08 | Florida | Puerto Rico | 72054 | 22 | |
223757 | 223757 | 2020-06-09 | Florida | Puerto Rico | 72054 | 23 | |
226857 | 226857 | 2020-06-10 | Florida | Puerto Rico | 72054 | 26 | |
229961 | 229961 | 2020-06-11 | Florida | Puerto Rico | 72054 | 26 | |
233066 | 233066 | 2020-06-12 | Florida | Puerto Rico | 72054 | 26 | |
236171 | 236171 | 2020-06-13 | Florida | Puerto Rico | 72054 | 26 | |
239279 | 239279 | 2020-06-14 | Florida | Puerto Rico | 72054 | 26 | |
242388 | 242388 | 2020-06-15 | Florida | Puerto Rico | 72054 | 26 | |
245500 | 245500 | 2020-06-16 | Florida | Puerto Rico | 72054 | 26 | |
248613 | 248613 | 2020-06-17 | Florida | Puerto Rico | 72054 | 26 | |
251728 | 251728 | 2020-06-18 | Florida | Puerto Rico | 72054 | 27 | |
254843 | 254843 | 2020-06-19 | Florida | Puerto Rico | 72054 | 28 | |
257969 | 257969 | 2020-06-20 | Florida | Puerto Rico | 72054 | 32 | |
261096 | 261096 | 2020-06-21 | Florida | Puerto Rico | 72054 | 31 | |
264224 | 264224 | 2020-06-22 | Florida | Puerto Rico | 72054 | 31 | |
267352 | 267352 | 2020-06-23 | Florida | Puerto Rico | 72054 | 31 | |
270486 | 270486 | 2020-06-24 | Florida | Puerto Rico | 72054 | 31 | |
273625 | 273625 | 2020-06-25 | Florida | Puerto Rico | 72054 | 32 | |
276772 | 276772 | 2020-06-26 | Florida | Puerto Rico | 72054 | 33 | |
279920 | 279920 | 2020-06-27 | Florida | Puerto Rico | 72054 | 33 | |
283066 | 283066 | 2020-06-28 | Florida | Puerto Rico | 72054 | 33 | |
286211 | 286211 | 2020-06-29 | Florida | Puerto Rico | 72054 | 35 | |
289362 | 289362 | 2020-06-30 | Florida | Puerto Rico | 72054 | 37 | |
292514 | 292514 | 2020-07-01 | Florida | Puerto Rico | 72054 | 37 | |
295670 | 295670 | 2020-07-02 | Florida | Puerto Rico | 72054 | 38 | |
298829 | 298829 | 2020-07-03 | Florida | Puerto Rico | 72054 | 40 | |
301993 | 301993 | 2020-07-04 | Florida | Puerto Rico | 72054 | 41 | |
305156 | 305156 | 2020-07-05 | Florida | Puerto Rico | 72054 | 44 | |
308323 | 308323 | 2020-07-06 | Florida | Puerto Rico | 72054 | 50 | |
311492 | 311492 | 2020-07-07 | Florida | Puerto Rico | 72054 | 51 | |
314664 | 314664 | 2020-07-08 | Florida | Puerto Rico | 72054 | 51 | |
317837 | 317837 | 2020-07-09 | Florida | Puerto Rico | 72054 | 54 | |
321015 | 321015 | 2020-07-10 | Florida | Puerto Rico | 72054 | 54 | |
324195 | 324195 | 2020-07-11 | Florida | Puerto Rico | 72054 | 54 | |
327380 | 327380 | 2020-07-12 | Florida | Puerto Rico | 72054 | 54 | |
330566 | 330566 | 2020-07-13 | Florida | Puerto Rico | 72054 | 58 | |
333758 | 333758 | 2020-07-14 | Florida | Puerto Rico | 72054 | 58 | |
336952 | 336952 | 2020-07-15 | Florida | Puerto Rico | 72054 | 60 | |
340149 | 340149 | 2020-07-16 | Florida | Puerto Rico | 72054 | 60 | |
343347 | 343347 | 2020-07-17 | Florida | Puerto Rico | 72054 | 61 | |
346547 | 346547 | 2020-07-18 | Florida | Puerto Rico | 72054 | 61 | |
349747 | 349747 | 2020-07-19 | Florida | Puerto Rico | 72054 | 64 | |
352950 | 352950 | 2020-07-20 | Florida | Puerto Rico | 72054 | 64 | |
356153 | 356153 | 2020-07-21 | Florida | Puerto Rico | 72054 | 85 | |
359357 | 359357 | 2020-07-22 | Florida | Puerto Rico | 72054 | 88 | |
362563 | 362563 | 2020-07-23 | Florida | Puerto Rico | 72054 | 100 | |
365769 | 365769 | 2020-07-24 | Florida | Puerto Rico | 72054 | 102 | |
368978 | 368978 | 2020-07-25 | Florida | Puerto Rico | 72054 | 103 | |
372190 | 372190 | 2020-07-26 | Florida | Puerto Rico | 72054 | 104 | |
375403 | 375403 | 2020-07-27 | Florida | Puerto Rico | 72054 | 104 | |
378619 | 378619 | 2020-07-28 | Florida | Puerto Rico | 72054 | 120 | |
381836 | 381836 | 2020-07-29 | Florida | Puerto Rico | 72054 | 125 | |
385054 | 385054 | 2020-07-30 | Florida | Puerto Rico | 72054 | 130 | |
388271 | 388271 | 2020-07-31 | Florida | Puerto Rico | 72054 | 136 | |
391488 | 391488 | 2020-08-01 | Florida | Puerto Rico | 72054 | 141 | |
394704 | 394704 | 2020-08-02 | Florida | Puerto Rico | 72054 | 152 | |
397921 | 397921 | 2020-08-03 | Florida | Puerto Rico | 72054 | 157 | |
401136 | 401136 | 2020-08-04 | Florida | Puerto Rico | 72054 | 158 | |
404354 | 404354 | 2020-08-05 | Florida | Puerto Rico | 72054 | 170 | |
407573 | 407573 | 2020-08-06 | Florida | Puerto Rico | 72054 | 171 | |
410793 | 410793 | 2020-08-07 | Florida | Puerto Rico | 72054 | 173 | |
414013 | 414013 | 2020-08-08 | Florida | Puerto Rico | 72054 | 173 | |
417234 | 417234 | 2020-08-09 | Florida | Puerto Rico | 72054 | 175 | |
420454 | 420454 | 2020-08-10 | Florida | Puerto Rico | 72054 | 178 | |
423677 | 423677 | 2020-08-11 | Florida | Puerto Rico | 72054 | 188 | |
426900 | 426900 | 2020-08-12 | Florida | Puerto Rico | 72054 | 188 |
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);