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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 381 ✖
- 1671 104
- 2737 18
- 0 14
- 2518 12
- 2448 8
- 2687 8
- 2760 8
- 3248 8
- 2339 7
- 2625 7
- 2702 7
- 2773 7
- 2778 7
- 2780 7
- 2793 7
- 2802 7
- 2839 7
- 2909 7
- 2994 7
- 3073 7
- 3147 7
- 3153 7
- 3195 7
- 3301 7
- 3315 7
- 3328 7
- 3334 7
- 3342 7
- 3351 7
- 2667 6
- 2753 6
- 3278 6
- 2719 5
- 1 4
- 5 4
- 16 4
- 75 4
- 95 4
- 102 4
- 831 4
- 1667 4
- 2203 4
- 14 3
- 24 3
- 82 3
- 701 3
- 744 3
- 816 3
- 1372 3
- 1481 3
- 1524 3
- 1559 3
- 1565 3
- 1639 3
- 1656 3
- 2576 3
- 3356 3
- 7 2
- 8 2
- 10 2
- 12 2
- 13 2
- 41 2
- 59 2
- 67 2
- 73 2
- 90 2
- 154 2
- 229 2
- 500 2
- 650 2
- 669 2
- 721 2
- 763 2
- 780 2
- 818 2
- 823 2
- 866 2
- 867 2
- 884 2
- 911 2
- 1013 2
- 1049 2
- 1371 2
- 1414 2
- 1501 2
- 1522 2
- 1543 2
- 1554 2
- 1555 2
- 1557 2
- 1578 2
- 1587 2
- 1592 2
- 1596 2
- 1609 2
- 1629 2
- 4 1
- 6 1
- 9 1
- 18 1
- 19 1
- 23 1
- 25 1
- 31 1
- 34 1
- 37 1
- 38 1
- 42 1
- 44 1
- 50 1
- 56 1
- 60 1
- 61 1
- 62 1
- 63 1
- 65 1
- 66 1
- 68 1
- 71 1
- 72 1
- 79 1
- 80 1
- 83 1
- 91 1
- 99 1
- 100 1
- 101 1
- 107 1
- 110 1
- 112 1
- 113 1
- 114 1
- 115 1
- 117 1
- 129 1
- 132 1
- 137 1
- 141 1
- 149 1
- 166 1
- 172 1
- 180 1
- 183 1
- 184 1
- 198 1
- 199 1
- 206 1
- 209 1
- 221 1
- 223 1
- 236 1
- 262 1
- 278 1
- 295 1
- 300 1
- 310 1
- 314 1
- 323 1
- 334 1
- 342 1
- 364 1
- 367 1
- 372 1
- 373 1
- 378 1
- 395 1
- 400 1
- 418 1
- 432 1
- 437 1
- 439 1
- 442 1
- 460 1
- 467 1
- 469 1
- 481 1
- 497 1
- 513 1
- 522 1
- 536 1
- 541 1
- 544 1
- 548 1
- 558 1
- 570 1
- 582 1
- 587 1
- 591 1
- 595 1
- 599 1
- 612 1
- 630 1
- 635 1
- 641 1
- 645 1
- 658 1
- 663 1
- 665 1
- 671 1
- 672 1
- 673 1
- 678 1
- 693 1
- 697 1
- 698 1
- 710 1
- 714 1
- 715 1
- 720 1
- 728 1
- 729 1
- 736 1
- 739 1
- 742 1
- 752 1
- 753 1
- 755 1
- 759 1
- 766 1
- 768 1
- 774 1
- 776 1
- 782 1
- 783 1
- 787 1
- 788 1
- 792 1
- 793 1
- 798 1
- 800 1
- 801 1
- 803 1
- 805 1
- 812 1
- 815 1
- 819 1
- 821 1
- 825 1
- 828 1
- 829 1
- 830 1
- 833 1
- 838 1
- 849 1
- 850 1
- 853 1
- 854 1
- 855 1
- 859 1
- 862 1
- 872 1
- 881 1
- 885 1
- 895 1
- 899 1
- 902 1
- 915 1
- 922 1
- 924 1
- 925 1
- 930 1
- 939 1
- 941 1
- 942 1
- 943 1
- 945 1
- 951 1
- 955 1
- 957 1
- 966 1
- 990 1
- 995 1
- 996 1
- 997 1
- 999 1
- 1000 1
- 1007 1
- 1020 1
- 1029 1
- 1035 1
- 1040 1
- 1045 1
- 1052 1
- 1066 1
- 1079 1
- 1086 1
- 1106 1
- 1114 1
- 1117 1
- 1121 1
- 1128 1
- 1129 1
- 1132 1
- 1149 1
- 1157 1
- 1169 1
- 1173 1
- 1175 1
- 1184 1
- 1202 1
- 1206 1
- 1208 1
- 1209 1
- 1220 1
- 1224 1
- 1252 1
- 1263 1
- 1269 1
- 1276 1
- 1288 1
- 1289 1
- 1290 1
- 1304 1
- 1305 1
- 1307 1
- 1312 1
- 1330 1
- 1331 1
- 1335 1
- 1344 1
- 1345 1
- 1357 1
- 1384 1
- 1385 1
- 1397 1
- 1411 1
- 1429 1
- 1430 1
- 1432 1
- 1433 1
- 1438 1
- 1440 1
- 1441 1
- 1451 1
- 1456 1
- 1463 1
- 1465 1
- 1472 1
- 1474 1
- 1480 1
- 1482 1
- 1487 1
- 1510 1
- 1520 1
- 1526 1
- 1529 1
- 1531 1
- 1536 1
- 1553 1
- 1560 1
- 1561 1
- 1563 1
- 1569 1
- 1570 1
- 1575 1
- 1576 1
- 1579 1
- 1580 1
- 1589 1
- 1598 1
- 1600 1
- 1608 1
- 1613 1
- 1618 1
- 1619 1
- 1623 1
- 1624 1
- 1633 1
- 1635 1
- 1638 1
- 1642 1
- 1646 1
- 1648 1
- 1649 1
- 1654 1
- 1655 1
- 1657 1
- 1661 1
- 1665 1
- 1670 1
state 1
- Florida 795
fips 1
- 12103 · 795 ✖
county 1
- Pinellas 795
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
1042 | 1042 | 2020-03-10 | Pinellas | Florida | 12103 | 2 | 0 |
1212 | 1212 | 2020-03-11 | Pinellas | Florida | 12103 | 2 | 0 |
1424 | 1424 | 2020-03-12 | Pinellas | Florida | 12103 | 2 | 0 |
1692 | 1692 | 2020-03-13 | Pinellas | Florida | 12103 | 2 | 0 |
2014 | 2014 | 2020-03-14 | Pinellas | Florida | 12103 | 2 | 0 |
2398 | 2398 | 2020-03-15 | Pinellas | Florida | 12103 | 2 | 0 |
2835 | 2835 | 2020-03-16 | Pinellas | Florida | 12103 | 4 | 0 |
3319 | 3319 | 2020-03-17 | Pinellas | Florida | 12103 | 4 | 0 |
3877 | 3877 | 2020-03-18 | Pinellas | Florida | 12103 | 12 | 0 |
4546 | 4546 | 2020-03-19 | Pinellas | Florida | 12103 | 16 | 0 |
5326 | 5326 | 2020-03-20 | Pinellas | Florida | 12103 | 22 | 0 |
6256 | 6256 | 2020-03-21 | Pinellas | Florida | 12103 | 29 | 0 |
7296 | 7296 | 2020-03-22 | Pinellas | Florida | 12103 | 38 | 0 |
8442 | 8442 | 2020-03-23 | Pinellas | Florida | 12103 | 41 | 0 |
9687 | 9687 | 2020-03-24 | Pinellas | Florida | 12103 | 45 | 1 |
11062 | 11062 | 2020-03-25 | Pinellas | Florida | 12103 | 54 | 1 |
12610 | 12610 | 2020-03-26 | Pinellas | Florida | 12103 | 65 | 1 |
14280 | 14280 | 2020-03-27 | Pinellas | Florida | 12103 | 82 | 1 |
16065 | 16065 | 2020-03-28 | Pinellas | Florida | 12103 | 111 | 4 |
17958 | 17958 | 2020-03-29 | Pinellas | Florida | 12103 | 116 | 5 |
19939 | 19939 | 2020-03-30 | Pinellas | Florida | 12103 | 129 | 5 |
22017 | 22017 | 2020-03-31 | Pinellas | Florida | 12103 | 167 | 5 |
24180 | 24180 | 2020-04-01 | Pinellas | Florida | 12103 | 233 | 5 |
26410 | 26410 | 2020-04-02 | Pinellas | Florida | 12103 | 273 | 6 |
28713 | 28713 | 2020-04-03 | Pinellas | Florida | 12103 | 318 | 7 |
31073 | 31073 | 2020-04-04 | Pinellas | Florida | 12103 | 342 | 7 |
33479 | 33479 | 2020-04-05 | Pinellas | Florida | 12103 | 359 | 8 |
35925 | 35925 | 2020-04-06 | Pinellas | Florida | 12103 | 372 | 8 |
38416 | 38416 | 2020-04-07 | Pinellas | Florida | 12103 | 387 | 9 |
40960 | 40960 | 2020-04-08 | Pinellas | Florida | 12103 | 395 | 10 |
43534 | 43534 | 2020-04-09 | Pinellas | Florida | 12103 | 422 | 10 |
46136 | 46136 | 2020-04-10 | Pinellas | Florida | 12103 | 431 | 12 |
48766 | 48766 | 2020-04-11 | Pinellas | Florida | 12103 | 446 | 12 |
51427 | 51427 | 2020-04-12 | Pinellas | Florida | 12103 | 455 | 13 |
54107 | 54107 | 2020-04-13 | Pinellas | Florida | 12103 | 479 | 13 |
56799 | 56799 | 2020-04-14 | Pinellas | Florida | 12103 | 494 | 14 |
59507 | 59507 | 2020-04-15 | Pinellas | Florida | 12103 | 513 | 14 |
62226 | 62226 | 2020-04-16 | Pinellas | Florida | 12103 | 530 | 14 |
64959 | 64959 | 2020-04-17 | Pinellas | Florida | 12103 | 565 | 16 |
67707 | 67707 | 2020-04-18 | Pinellas | Florida | 12103 | 587 | 16 |
70469 | 70469 | 2020-04-19 | Pinellas | Florida | 12103 | 592 | 16 |
73238 | 73238 | 2020-04-20 | Pinellas | Florida | 12103 | 607 | 16 |
76014 | 76014 | 2020-04-21 | Pinellas | Florida | 12103 | 632 | 18 |
78798 | 78798 | 2020-04-22 | Pinellas | Florida | 12103 | 638 | 19 |
81592 | 81592 | 2020-04-23 | Pinellas | Florida | 12103 | 656 | 23 |
84392 | 84392 | 2020-04-24 | Pinellas | Florida | 12103 | 673 | 24 |
87200 | 87200 | 2020-04-25 | Pinellas | Florida | 12103 | 677 | 24 |
90017 | 90017 | 2020-04-26 | Pinellas | Florida | 12103 | 687 | 24 |
92835 | 92835 | 2020-04-27 | Pinellas | Florida | 12103 | 698 | 25 |
95667 | 95667 | 2020-04-28 | Pinellas | Florida | 12103 | 709 | 31 |
98512 | 98512 | 2020-04-29 | Pinellas | Florida | 12103 | 718 | 34 |
101362 | 101362 | 2020-04-30 | Pinellas | Florida | 12103 | 729 | 37 |
104217 | 104217 | 2020-05-01 | Pinellas | Florida | 12103 | 748 | 38 |
107082 | 107082 | 2020-05-02 | Pinellas | Florida | 12103 | 757 | 41 |
109951 | 109951 | 2020-05-03 | Pinellas | Florida | 12103 | 766 | 41 |
112826 | 112826 | 2020-05-04 | Pinellas | Florida | 12103 | 784 | 42 |
115709 | 115709 | 2020-05-05 | Pinellas | Florida | 12103 | 788 | 44 |
118669 | 118669 | 2020-05-06 | Pinellas | Florida | 12103 | 801 | 50 |
121638 | 121638 | 2020-05-07 | Pinellas | Florida | 12103 | 820 | 56 |
124617 | 124617 | 2020-05-08 | Pinellas | Florida | 12103 | 828 | 59 |
127604 | 127604 | 2020-05-09 | Pinellas | Florida | 12103 | 848 | 59 |
130595 | 130595 | 2020-05-10 | Pinellas | Florida | 12103 | 861 | 60 |
133586 | 133586 | 2020-05-11 | Pinellas | Florida | 12103 | 876 | 61 |
136575 | 136575 | 2020-05-12 | Pinellas | Florida | 12103 | 909 | 62 |
139566 | 139566 | 2020-05-13 | Pinellas | Florida | 12103 | 923 | 63 |
142562 | 142562 | 2020-05-14 | Pinellas | Florida | 12103 | 962 | 65 |
145562 | 145562 | 2020-05-15 | Pinellas | Florida | 12103 | 997 | 66 |
148565 | 148565 | 2020-05-16 | Pinellas | Florida | 12103 | 1008 | 67 |
151574 | 151574 | 2020-05-17 | Pinellas | Florida | 12103 | 1022 | 67 |
154586 | 154586 | 2020-05-18 | Pinellas | Florida | 12103 | 1051 | 68 |
157602 | 157602 | 2020-05-19 | Pinellas | Florida | 12103 | 1062 | 71 |
160628 | 160628 | 2020-05-20 | Pinellas | Florida | 12103 | 1075 | 72 |
163656 | 163656 | 2020-05-21 | Pinellas | Florida | 12103 | 1109 | 73 |
166689 | 166689 | 2020-05-22 | Pinellas | Florida | 12103 | 1116 | 73 |
169726 | 169726 | 2020-05-23 | Pinellas | Florida | 12103 | 1153 | 75 |
172767 | 172767 | 2020-05-24 | Pinellas | Florida | 12103 | 1173 | 75 |
175810 | 175810 | 2020-05-25 | Pinellas | Florida | 12103 | 1187 | 75 |
178854 | 178854 | 2020-05-26 | Pinellas | Florida | 12103 | 1196 | 75 |
181898 | 181898 | 2020-05-27 | Pinellas | Florida | 12103 | 1205 | 79 |
184952 | 184952 | 2020-05-28 | Pinellas | Florida | 12103 | 1218 | 80 |
188008 | 188008 | 2020-05-29 | Pinellas | Florida | 12103 | 1238 | 82 |
191073 | 191073 | 2020-05-30 | Pinellas | Florida | 12103 | 1262 | 82 |
194140 | 194140 | 2020-05-31 | Pinellas | Florida | 12103 | 1297 | 82 |
197210 | 197210 | 2020-06-01 | Pinellas | Florida | 12103 | 1313 | 83 |
200283 | 200283 | 2020-06-02 | Pinellas | Florida | 12103 | 1335 | 90 |
203359 | 203359 | 2020-06-03 | Pinellas | Florida | 12103 | 1361 | 90 |
206439 | 206439 | 2020-06-04 | Pinellas | Florida | 12103 | 1397 | 91 |
209520 | 209520 | 2020-06-05 | Pinellas | Florida | 12103 | 1478 | 95 |
212605 | 212605 | 2020-06-06 | Pinellas | Florida | 12103 | 1532 | 95 |
215692 | 215692 | 2020-06-07 | Pinellas | Florida | 12103 | 1584 | 95 |
218783 | 218783 | 2020-06-08 | Pinellas | Florida | 12103 | 1638 | 95 |
221878 | 221878 | 2020-06-09 | Pinellas | Florida | 12103 | 1679 | 99 |
224973 | 224973 | 2020-06-10 | Pinellas | Florida | 12103 | 1746 | 100 |
228075 | 228075 | 2020-06-11 | Pinellas | Florida | 12103 | 1862 | 101 |
231178 | 231178 | 2020-06-12 | Pinellas | Florida | 12103 | 1941 | 102 |
234284 | 234284 | 2020-06-13 | Pinellas | Florida | 12103 | 2103 | 102 |
237391 | 237391 | 2020-06-14 | Pinellas | Florida | 12103 | 2235 | 102 |
240499 | 240499 | 2020-06-15 | Pinellas | Florida | 12103 | 2389 | 102 |
243610 | 243610 | 2020-06-16 | Pinellas | Florida | 12103 | 2523 | 107 |
246723 | 246723 | 2020-06-17 | Pinellas | Florida | 12103 | 2684 | 110 |
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);