ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Orange" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534791 | 534791 | 2020-09-15 | Orange | Florida | 12095 | 38146 | 411 |
531556 | 531556 | 2020-09-14 | Orange | Florida | 12095 | 38012 | 408 |
528319 | 528319 | 2020-09-13 | Orange | Florida | 12095 | 37938 | 408 |
525083 | 525083 | 2020-09-12 | Orange | Florida | 12095 | 37845 | 408 |
521847 | 521847 | 2020-09-11 | Orange | Florida | 12095 | 37700 | 404 |
518610 | 518610 | 2020-09-10 | Orange | Florida | 12095 | 37472 | 400 |
515375 | 515375 | 2020-09-09 | Orange | Florida | 12095 | 37365 | 393 |
512142 | 512142 | 2020-09-08 | Orange | Florida | 12095 | 37246 | 386 |
508909 | 508909 | 2020-09-07 | Orange | Florida | 12095 | 37151 | 386 |
505677 | 505677 | 2020-09-06 | Orange | Florida | 12095 | 37073 | 386 |
502443 | 502443 | 2020-09-05 | Orange | Florida | 12095 | 36965 | 386 |
499209 | 499209 | 2020-09-04 | Orange | Florida | 12095 | 36826 | 385 |
495976 | 495976 | 2020-09-03 | Orange | Florida | 12095 | 36667 | 385 |
492742 | 492742 | 2020-09-02 | Orange | Florida | 12095 | 36487 | 382 |
489509 | 489509 | 2020-09-01 | Orange | Florida | 12095 | 36399 | 377 |
486276 | 486276 | 2020-08-31 | Orange | Florida | 12095 | 35901 | 376 |
483041 | 483041 | 2020-08-30 | Orange | Florida | 12095 | 35769 | 375 |
479807 | 479807 | 2020-08-29 | Orange | Florida | 12095 | 35612 | 375 |
476574 | 476574 | 2020-08-28 | Orange | Florida | 12095 | 35448 | 369 |
473341 | 473341 | 2020-08-27 | Orange | Florida | 12095 | 35244 | 368 |
470109 | 470109 | 2020-08-26 | Orange | Florida | 12095 | 35082 | 364 |
466880 | 466880 | 2020-08-25 | Orange | Florida | 12095 | 34909 | 363 |
463651 | 463651 | 2020-08-24 | Orange | Florida | 12095 | 34780 | 360 |
460422 | 460422 | 2020-08-23 | Orange | Florida | 12095 | 34661 | 360 |
457195 | 457195 | 2020-08-22 | Orange | Florida | 12095 | 34537 | 360 |
453967 | 453967 | 2020-08-21 | Orange | Florida | 12095 | 34320 | 357 |
450739 | 450739 | 2020-08-20 | Orange | Florida | 12095 | 34134 | 358 |
447511 | 447511 | 2020-08-19 | Orange | Florida | 12095 | 33945 | 355 |
444284 | 444284 | 2020-08-18 | Orange | Florida | 12095 | 33708 | 351 |
441058 | 441058 | 2020-08-17 | Orange | Florida | 12095 | 33485 | 350 |
437832 | 437832 | 2020-08-16 | Orange | Florida | 12095 | 33381 | 350 |
434606 | 434606 | 2020-08-15 | Orange | Florida | 12095 | 33179 | 350 |
431381 | 431381 | 2020-08-14 | Orange | Florida | 12095 | 32860 | 334 |
428153 | 428153 | 2020-08-13 | Orange | Florida | 12095 | 32574 | 329 |
424929 | 424929 | 2020-08-12 | Orange | Florida | 12095 | 32340 | 324 |
421708 | 421708 | 2020-08-11 | Orange | Florida | 12095 | 32041 | 314 |
418487 | 418487 | 2020-08-10 | Orange | Florida | 12095 | 31850 | 297 |
415266 | 415266 | 2020-08-09 | Orange | Florida | 12095 | 31718 | 297 |
412046 | 412046 | 2020-08-08 | Orange | Florida | 12095 | 31394 | 296 |
408827 | 408827 | 2020-08-07 | Orange | Florida | 12095 | 31025 | 286 |
405607 | 405607 | 2020-08-06 | Orange | Florida | 12095 | 30775 | 274 |
402389 | 402389 | 2020-08-05 | Orange | Florida | 12095 | 30424 | 249 |
399173 | 399173 | 2020-08-04 | Orange | Florida | 12095 | 30139 | 240 |
395957 | 395957 | 2020-08-03 | Orange | Florida | 12095 | 29926 | 238 |
392741 | 392741 | 2020-08-02 | Orange | Florida | 12095 | 29698 | 233 |
389524 | 389524 | 2020-08-01 | Orange | Florida | 12095 | 29465 | 231 |
386307 | 386307 | 2020-07-31 | Orange | Florida | 12095 | 29010 | 215 |
383089 | 383089 | 2020-07-30 | Orange | Florida | 12095 | 28590 | 211 |
379872 | 379872 | 2020-07-29 | Orange | Florida | 12095 | 28190 | 202 |
376655 | 376655 | 2020-07-28 | Orange | Florida | 12095 | 27819 | 178 |
373441 | 373441 | 2020-07-27 | Orange | Florida | 12095 | 27392 | 173 |
370229 | 370229 | 2020-07-26 | Orange | Florida | 12095 | 26979 | 172 |
367019 | 367019 | 2020-07-25 | Orange | Florida | 12095 | 26558 | 172 |
363812 | 363812 | 2020-07-24 | Orange | Florida | 12095 | 25951 | 163 |
360605 | 360605 | 2020-07-23 | Orange | Florida | 12095 | 25253 | 155 |
357400 | 357400 | 2020-07-22 | Orange | Florida | 12095 | 24699 | 137 |
354197 | 354197 | 2020-07-21 | Orange | Florida | 12095 | 24010 | 123 |
350995 | 350995 | 2020-07-20 | Orange | Florida | 12095 | 23583 | 118 |
347794 | 347794 | 2020-07-19 | Orange | Florida | 12095 | 23258 | 119 |
344594 | 344594 | 2020-07-18 | Orange | Florida | 12095 | 22517 | 116 |
341395 | 341395 | 2020-07-17 | Orange | Florida | 12095 | 22048 | 102 |
338198 | 338198 | 2020-07-16 | Orange | Florida | 12095 | 21298 | 101 |
335003 | 335003 | 2020-07-15 | Orange | Florida | 12095 | 19908 | 93 |
331810 | 331810 | 2020-07-14 | Orange | Florida | 12095 | 19376 | 84 |
328623 | 328623 | 2020-07-13 | Orange | Florida | 12095 | 18936 | 82 |
325437 | 325437 | 2020-07-12 | Orange | Florida | 12095 | 18000 | 79 |
322256 | 322256 | 2020-07-11 | Orange | Florida | 12095 | 16629 | 79 |
319077 | 319077 | 2020-07-10 | Orange | Florida | 12095 | 16147 | 77 |
315904 | 315904 | 2020-07-09 | Orange | Florida | 12095 | 15594 | 68 |
312729 | 312729 | 2020-07-08 | Orange | Florida | 12095 | 15193 | 62 |
309559 | 309559 | 2020-07-07 | Orange | Florida | 12095 | 14767 | 60 |
306391 | 306391 | 2020-07-06 | Orange | Florida | 12095 | 14406 | 60 |
303227 | 303227 | 2020-07-05 | Orange | Florida | 12095 | 14031 | 58 |
300063 | 300063 | 2020-07-04 | Orange | Florida | 12095 | 13261 | 58 |
296901 | 296901 | 2020-07-03 | Orange | Florida | 12095 | 12077 | 58 |
293745 | 293745 | 2020-07-02 | Orange | Florida | 12095 | 11457 | 58 |
290591 | 290591 | 2020-07-01 | Orange | Florida | 12095 | 10873 | 57 |
287440 | 287440 | 2020-06-30 | Orange | Florida | 12095 | 10313 | 57 |
284294 | 284294 | 2020-06-29 | Orange | Florida | 12095 | 10013 | 55 |
281148 | 281148 | 2020-06-28 | Orange | Florida | 12095 | 9670 | 55 |
278001 | 278001 | 2020-06-27 | Orange | Florida | 12095 | 8836 | 55 |
274853 | 274853 | 2020-06-26 | Orange | Florida | 12095 | 7847 | 55 |
271713 | 271713 | 2020-06-25 | Orange | Florida | 12095 | 6785 | 54 |
268577 | 268577 | 2020-06-24 | Orange | Florida | 12095 | 6055 | 52 |
265447 | 265447 | 2020-06-23 | Orange | Florida | 12095 | 5501 | 50 |
262319 | 262319 | 2020-06-22 | Orange | Florida | 12095 | 5156 | 48 |
259192 | 259192 | 2020-06-21 | Orange | Florida | 12095 | 4913 | 47 |
256065 | 256065 | 2020-06-20 | Orange | Florida | 12095 | 4568 | 47 |
252946 | 252946 | 2020-06-19 | Orange | Florida | 12095 | 4273 | 47 |
249831 | 249831 | 2020-06-18 | Orange | Florida | 12095 | 3899 | 47 |
246719 | 246719 | 2020-06-17 | Orange | Florida | 12095 | 3583 | 47 |
243606 | 243606 | 2020-06-16 | Orange | Florida | 12095 | 3436 | 46 |
240495 | 240495 | 2020-06-15 | Orange | Florida | 12095 | 3281 | 45 |
237387 | 237387 | 2020-06-14 | Orange | Florida | 12095 | 3129 | 45 |
234280 | 234280 | 2020-06-13 | Orange | Florida | 12095 | 2936 | 45 |
231174 | 231174 | 2020-06-12 | Orange | Florida | 12095 | 2772 | 45 |
228071 | 228071 | 2020-06-11 | Orange | Florida | 12095 | 2677 | 45 |
224969 | 224969 | 2020-06-10 | Orange | Florida | 12095 | 2541 | 45 |
221874 | 221874 | 2020-06-09 | Orange | Florida | 12095 | 2448 | 44 |
218779 | 218779 | 2020-06-08 | Orange | Florida | 12095 | 2377 | 44 |
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);