ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 12103 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
249835 | 249835 | 2020-06-18 | Pinellas | Florida | 12103 | 2887 | 112 |
252950 | 252950 | 2020-06-19 | Pinellas | Florida | 12103 | 3153 | 113 |
256069 | 256069 | 2020-06-20 | Pinellas | Florida | 12103 | 3438 | 114 |
259196 | 259196 | 2020-06-21 | Pinellas | Florida | 12103 | 3667 | 115 |
262323 | 262323 | 2020-06-22 | Pinellas | Florida | 12103 | 3854 | 117 |
265451 | 265451 | 2020-06-23 | Pinellas | Florida | 12103 | 4033 | 129 |
268581 | 268581 | 2020-06-24 | Pinellas | Florida | 12103 | 4387 | 132 |
271717 | 271717 | 2020-06-25 | Pinellas | Florida | 12103 | 4669 | 137 |
274857 | 274857 | 2020-06-26 | Pinellas | Florida | 12103 | 5099 | 141 |
278005 | 278005 | 2020-06-27 | Pinellas | Florida | 12103 | 5713 | 149 |
281152 | 281152 | 2020-06-28 | Pinellas | Florida | 12103 | 6020 | 154 |
284298 | 284298 | 2020-06-29 | Pinellas | Florida | 12103 | 6260 | 154 |
287444 | 287444 | 2020-06-30 | Pinellas | Florida | 12103 | 6487 | 166 |
290595 | 290595 | 2020-07-01 | Pinellas | Florida | 12103 | 6861 | 172 |
293749 | 293749 | 2020-07-02 | Pinellas | Florida | 12103 | 7249 | 180 |
296905 | 296905 | 2020-07-03 | Pinellas | Florida | 12103 | 7697 | 183 |
300067 | 300067 | 2020-07-04 | Pinellas | Florida | 12103 | 8116 | 184 |
303231 | 303231 | 2020-07-05 | Pinellas | Florida | 12103 | 8533 | 198 |
306395 | 306395 | 2020-07-06 | Pinellas | Florida | 12103 | 8759 | 199 |
309563 | 309563 | 2020-07-07 | Pinellas | Florida | 12103 | 9032 | 206 |
312733 | 312733 | 2020-07-08 | Pinellas | Florida | 12103 | 9395 | 209 |
315908 | 315908 | 2020-07-09 | Pinellas | Florida | 12103 | 9826 | 221 |
319081 | 319081 | 2020-07-10 | Pinellas | Florida | 12103 | 10293 | 223 |
322260 | 322260 | 2020-07-11 | Pinellas | Florida | 12103 | 10596 | 229 |
325441 | 325441 | 2020-07-12 | Pinellas | Florida | 12103 | 10844 | 229 |
328627 | 328627 | 2020-07-13 | Pinellas | Florida | 12103 | 11442 | 236 |
331814 | 331814 | 2020-07-14 | Pinellas | Florida | 12103 | 11754 | 262 |
335007 | 335007 | 2020-07-15 | Pinellas | Florida | 12103 | 12080 | 278 |
338202 | 338202 | 2020-07-16 | Pinellas | Florida | 12103 | 12368 | 295 |
341399 | 341399 | 2020-07-17 | Pinellas | Florida | 12103 | 12714 | 300 |
344598 | 344598 | 2020-07-18 | Pinellas | Florida | 12103 | 13019 | 310 |
347798 | 347798 | 2020-07-19 | Pinellas | Florida | 12103 | 13482 | 314 |
350999 | 350999 | 2020-07-20 | Pinellas | Florida | 12103 | 13705 | 323 |
354201 | 354201 | 2020-07-21 | Pinellas | Florida | 12103 | 13925 | 334 |
357404 | 357404 | 2020-07-22 | Pinellas | Florida | 12103 | 14191 | 342 |
360609 | 360609 | 2020-07-23 | Pinellas | Florida | 12103 | 14371 | 364 |
363816 | 363816 | 2020-07-24 | Pinellas | Florida | 12103 | 14726 | 367 |
367023 | 367023 | 2020-07-25 | Pinellas | Florida | 12103 | 14985 | 372 |
370233 | 370233 | 2020-07-26 | Pinellas | Florida | 12103 | 15147 | 373 |
373445 | 373445 | 2020-07-27 | Pinellas | Florida | 12103 | 15339 | 378 |
376659 | 376659 | 2020-07-28 | Pinellas | Florida | 12103 | 15541 | 395 |
379876 | 379876 | 2020-07-29 | Pinellas | Florida | 12103 | 15800 | 400 |
383093 | 383093 | 2020-07-30 | Pinellas | Florida | 12103 | 16114 | 418 |
386311 | 386311 | 2020-07-31 | Pinellas | Florida | 12103 | 16356 | 432 |
389528 | 389528 | 2020-08-01 | Pinellas | Florida | 12103 | 16604 | 437 |
392745 | 392745 | 2020-08-02 | Pinellas | Florida | 12103 | 16774 | 439 |
395961 | 395961 | 2020-08-03 | Pinellas | Florida | 12103 | 16886 | 442 |
399177 | 399177 | 2020-08-04 | Pinellas | Florida | 12103 | 17047 | 460 |
402393 | 402393 | 2020-08-05 | Pinellas | Florida | 12103 | 17202 | 467 |
405611 | 405611 | 2020-08-06 | Pinellas | Florida | 12103 | 17358 | 469 |
408831 | 408831 | 2020-08-07 | Pinellas | Florida | 12103 | 17541 | 481 |
412050 | 412050 | 2020-08-08 | Pinellas | Florida | 12103 | 17725 | 497 |
415270 | 415270 | 2020-08-09 | Pinellas | Florida | 12103 | 17879 | 500 |
418491 | 418491 | 2020-08-10 | Pinellas | Florida | 12103 | 17941 | 500 |
421712 | 421712 | 2020-08-11 | Pinellas | Florida | 12103 | 18103 | 513 |
424933 | 424933 | 2020-08-12 | Pinellas | Florida | 12103 | 18217 | 522 |
428157 | 428157 | 2020-08-13 | Pinellas | Florida | 12103 | 18329 | 536 |
431385 | 431385 | 2020-08-14 | Pinellas | Florida | 12103 | 18466 | 541 |
434610 | 434610 | 2020-08-15 | Pinellas | Florida | 12103 | 18660 | 544 |
437836 | 437836 | 2020-08-16 | Pinellas | Florida | 12103 | 18730 | 548 |
441062 | 441062 | 2020-08-17 | Pinellas | Florida | 12103 | 18774 | 558 |
444288 | 444288 | 2020-08-18 | Pinellas | Florida | 12103 | 18876 | 570 |
447515 | 447515 | 2020-08-19 | Pinellas | Florida | 12103 | 18994 | 582 |
450743 | 450743 | 2020-08-20 | Pinellas | Florida | 12103 | 19087 | 587 |
453971 | 453971 | 2020-08-21 | Pinellas | Florida | 12103 | 19247 | 591 |
457199 | 457199 | 2020-08-22 | Pinellas | Florida | 12103 | 19352 | 595 |
460426 | 460426 | 2020-08-23 | Pinellas | Florida | 12103 | 19431 | 599 |
463655 | 463655 | 2020-08-24 | Pinellas | Florida | 12103 | 19478 | 612 |
466884 | 466884 | 2020-08-25 | Pinellas | Florida | 12103 | 19522 | 630 |
470113 | 470113 | 2020-08-26 | Pinellas | Florida | 12103 | 19605 | 635 |
473345 | 473345 | 2020-08-27 | Pinellas | Florida | 12103 | 19681 | 641 |
476578 | 476578 | 2020-08-28 | Pinellas | Florida | 12103 | 19740 | 645 |
479811 | 479811 | 2020-08-29 | Pinellas | Florida | 12103 | 19813 | 650 |
483045 | 483045 | 2020-08-30 | Pinellas | Florida | 12103 | 19888 | 650 |
486280 | 486280 | 2020-08-31 | Pinellas | Florida | 12103 | 19929 | 658 |
489513 | 489513 | 2020-09-01 | Pinellas | Florida | 12103 | 20026 | 663 |
492746 | 492746 | 2020-09-02 | Pinellas | Florida | 12103 | 20080 | 665 |
495980 | 495980 | 2020-09-03 | Pinellas | Florida | 12103 | 20177 | 669 |
499213 | 499213 | 2020-09-04 | Pinellas | Florida | 12103 | 20259 | 669 |
502447 | 502447 | 2020-09-05 | Pinellas | Florida | 12103 | 20355 | 671 |
505681 | 505681 | 2020-09-06 | Pinellas | Florida | 12103 | 20425 | 672 |
508913 | 508913 | 2020-09-07 | Pinellas | Florida | 12103 | 20474 | 673 |
512146 | 512146 | 2020-09-08 | Pinellas | Florida | 12103 | 20526 | 678 |
515379 | 515379 | 2020-09-09 | Pinellas | Florida | 12103 | 20588 | 693 |
518614 | 518614 | 2020-09-10 | Pinellas | Florida | 12103 | 20655 | 697 |
521851 | 521851 | 2020-09-11 | Pinellas | Florida | 12103 | 20795 | 698 |
525087 | 525087 | 2020-09-12 | Pinellas | Florida | 12103 | 20872 | 701 |
528323 | 528323 | 2020-09-13 | Pinellas | Florida | 12103 | 20922 | 701 |
531560 | 531560 | 2020-09-14 | Pinellas | Florida | 12103 | 20988 | 701 |
534795 | 534795 | 2020-09-15 | Pinellas | Florida | 12103 | 21081 | 710 |
538031 | 538031 | 2020-09-16 | Pinellas | Florida | 12103 | 21152 | 714 |
541268 | 541268 | 2020-09-17 | Pinellas | Florida | 12103 | 21254 | 715 |
544504 | 544504 | 2020-09-18 | Pinellas | Florida | 12103 | 21359 | 720 |
547742 | 547742 | 2020-09-19 | Pinellas | Florida | 12103 | 21440 | 721 |
550981 | 550981 | 2020-09-20 | Pinellas | Florida | 12103 | 21498 | 721 |
554220 | 554220 | 2020-09-21 | Pinellas | Florida | 12103 | 21561 | 728 |
557457 | 557457 | 2020-09-22 | Pinellas | Florida | 12103 | 21620 | 729 |
560693 | 560693 | 2020-09-23 | Pinellas | Florida | 12103 | 21701 | 736 |
563933 | 563933 | 2020-09-24 | Pinellas | Florida | 12103 | 21765 | 739 |
567173 | 567173 | 2020-09-25 | Pinellas | Florida | 12103 | 21845 | 742 |
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);