ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 29183 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 687 ✖
- 47778 5
- 28036 4
- 37829 4
- 41956 4
- 69693 4
- 3 3
- 39134 3
- 40201 3
- 41108 3
- 42448 3
- 42955 3
- 43364 3
- 43739 3
- 44193 3
- 44618 3
- 45033 3
- 45488 3
- 45911 3
- 47241 3
- 47470 3
- 55975 3
- 63789 3
- 64542 3
- 68551 3
- 73141 3
- 87630 3
- 102039 3
- 102346 3
- 103236 3
- 1 2
- 4 2
- 95 2
- 688 2
- 879 2
- 1020 2
- 3857 2
- 8947 2
- 27417 2
- 29669 2
- 43548 2
- 48419 2
- 48712 2
- 50472 2
- 52966 2
- 58006 2
- 58883 2
- 61851 2
- 62443 2
- 63056 2
- 65749 2
- 67107 2
- 80357 2
- 93748 2
- 97244 2
- 98943 2
- 99984 2
- 100431 2
- 100836 2
- 101084 2
- 101246 2
- 101393 2
- 101538 2
- 101684 2
- 101846 2
- 102726 2
- 18 1
- 22 1
- 32 1
- 37 1
- 43 1
- 56 1
- 105 1
- 132 1
- 143 1
- 157 1
- 188 1
- 221 1
- 254 1
- 274 1
- 298 1
- 320 1
- 328 1
- 346 1
- 368 1
- 392 1
- 405 1
- 417 1
- 426 1
- 435 1
- 447 1
- 458 1
- 467 1
- 476 1
- 502 1
- 513 1
- 526 1
- 543 1
- 555 1
- 560 1
- 566 1
- 577 1
- 596 1
- 612 1
- 624 1
- 626 1
- 639 1
- 646 1
- 663 1
- 668 1
- 670 1
- 680 1
- 681 1
- 684 1
- 695 1
- 701 1
- 705 1
- 712 1
- 714 1
- 715 1
- 726 1
- 730 1
- 741 1
- 743 1
- 748 1
- 755 1
- 763 1
- 768 1
- 775 1
- 780 1
- 787 1
- 799 1
- 809 1
- 821 1
- 835 1
- 838 1
- 844 1
- 851 1
- 867 1
- 888 1
- 895 1
- 909 1
- 918 1
- 924 1
- 934 1
- 939 1
- 945 1
- 951 1
- 954 1
- 959 1
- 974 1
- 997 1
- 1011 1
- 1045 1
- 1073 1
- 1078 1
- 1095 1
- 1135 1
- 1163 1
- 1183 1
- 1204 1
- 1239 1
- 1288 1
- 1355 1
- 1456 1
- 1526 1
- 1599 1
- 1691 1
- 1760 1
- 1882 1
- 1988 1
- 2070 1
- 2137 1
- 2223 1
- 2296 1
- 2468 1
- 2612 1
- 2693 1
- 2761 1
- 2843 1
- 2866 1
- 2998 1
- 3134 1
- 3263 1
- 3360 1
- 3456 1
- 3543 1
- 3590 1
- 3679 1
- 3702 1
- 3978 1
- 4036 1
- 4085 1
- 4110 1
- 4168 1
- 4258 1
- 4316 1
- 4449 1
- 4520 1
- 4610 1
- 4649 1
- 4760 1
- 4877 1
- 4961 1
- 5052 1
- 5086 1
- 5159 1
- 5219 1
- 5296 1
- 5338 1
- 5431 1
- 5491 1
- 5561 1
- 5643 1
- 5693 1
- 5771 1
- 5843 1
- 5903 1
- 5976 1
- 6002 1
- 6076 1
- 6146 1
- 6229 1
- 6319 1
- 6393 1
- 6486 1
- 6570 1
- 6660 1
- 6702 1
- 6840 1
- 6924 1
- 6978 1
- 7014 1
- 7127 1
- 7165 1
- 7258 1
- 7375 1
- 7441 1
- 7494 1
- 7563 1
- 7620 1
- 7670 1
- 7733 1
- 7901 1
- 8039 1
- 8078 1
- 8142 1
- 8228 1
- 8296 1
- 8369 1
- 8497 1
- 8554 1
- 8660 1
- 8796 1
- 8859 1
- 9195 1
- 9288 1
- 9502 1
- 9665 1
- 9817 1
- 9939 1
- 10072 1
- 10256 1
- 10334 1
- 10449 1
- 10509 1
- 10817 1
- 10877 1
- 10883 1
- 11197 1
- 11364 1
- 11511 1
- 11741 1
- 11948 1
- 12051 1
- 12476 1
- 12590 1
- 12856 1
- 13100 1
- 13155 1
- 13745 1
- 13970 1
- 14251 1
- 14532 1
- 14913 1
- 15170 1
- 15525 1
- 16268 1
- 16358 1
- 16792 1
- 17327 1
- 17809 1
- 18259 1
- 18590 1
- 18993 1
- 19231 1
- 19632 1
- 20042 1
- 20394 1
- 20757 1
- 20830 1
- 21221 1
- 21470 1
- 21726 1
- 22095 1
- 22134 1
- 22695 1
- 22851 1
- 22989 1
- 23457 1
- 23903 1
- 23956 1
- 24435 1
- 24593 1
- 24747 1
- 25174 1
- 25659 1
- 25841 1
- 25953 1
- 26355 1
- 26562 1
- 26917 1
- 27196 1
- 27286 1
- 28005 1
- 28811 1
- 28845 1
- 28961 1
- 29235 1
- 29978 1
- 30121 1
- 30294 1
- 30353 1
- 30799 1
- 30810 1
- 31306 1
- 31535 1
- 31660 1
- 36835 1
- 37093 1
- 37352 1
- 37597 1
- 38505 1
- 38612 1
- 38880 1
- 39537 1
- 39697 1
- 39907 1
- 40047 1
- 40511 1
- 40609 1
- 40868 1
- 40971 1
- 41415 1
- 41539 1
- 41712 1
- 41826 1
- 42212 1
- 42286 1
- 42335 1
- 42606 1
- 42750 1
- 42839 1
- 42929 1
- 43132 1
- 43182 1
- 43234 1
- 43299 1
- 43494 1
- 43706 1
- 43916 1
- 44027 1
- 44099 1
- 44173 1
- 44352 1
- 44391 1
- 44462 1
- 44546 1
- 44774 1
- 44836 1
- 44907 1
- 44977 1
- 45188 1
- 45259 1
- 45342 1
- 45430 1
- 45632 1
- 45676 1
- 45763 1
- 45852 1
- 46052 1
- 46118 1
- 46167 1
- 46234 1
- 46365 1
- 46399 1
- 46438 1
- 46477 1
- 46530 1
- 46589 1
- 46650 1
- 46703 1
- 46787 1
- 46792 1
- 46852 1
- 46904 1
- 46937 1
- 46985 1
- 47026 1
- 47056 1
- 47085 1
- 47122 1
- 47161 1
- 47199 1
- 47245 1
- 47337 1
- 47365 1
- 47384 1
- 47423 1
- 47491 1
- 47521 1
- 47567 1
- 47600 1
- 47633 1
- 47679 1
- 47712 1
- 47713 1
- 47729 1
- 47739 1
- 47765 1
- 47813 1
- 47832 1
- 47855 1
- 47882 1
- 47891 1
- 47916 1
- 47952 1
- 47986 1
- 48012 1
- 48032 1
- 48047 1
- 48048 1
- 48053 1
- 48067 1
- 48091 1
- 48098 1
- 48138 1
- 48168 1
- 48173 1
- 48208 1
- 48251 1
- 48289 1
- 48325 1
- 48342 1
- 48360 1
- 48421 1
- 48502 1
- 48588 1
- 48765 1
- 48855 1
- 48934 1
- 49019 1
- 49037 1
- 49181 1
- 49249 1
- 49252 1
- 49305 1
- 49478 1
- 49615 1
- 49747 1
- 49849 1
- 49850 1
- 50032 1
- 50137 1
- 50141 1
- 50669 1
- 50822 1
- 51009 1
- 51175 1
- 51179 1
- 51313 1
- 51551 1
- 51770 1
- 51888 1
- 52043 1
- 52157 1
- 52399 1
- 52401 1
- 52650 1
- 53177 1
- 53275 1
- 53337 1
- 53480 1
- 53811 1
- 53953 1
- 53963 1
- 54147 1
- 54360 1
- 54480 1
- 54672 1
- 54851 1
- 55026 1
- 55048 1
- 55141 1
- 55303 1
- 55465 1
- 55663 1
- 55791 1
- 55965 1
- 56371 1
- 56514 1
- 56678 1
- 56867 1
- 56889 1
- 57047 1
- 57229 1
- 57410 1
- 57562 1
- 57709 1
- 57879 1
- 58155 1
- 58263 1
- 58420 1
- 58545 1
- 58726 1
- 59006 1
- 59137 1
- 59297 1
- 59418 1
- 59512 1
- 59513 1
- 59699 1
- 59782 1
- 59902 1
- 60027 1
- 60154 1
- 60244 1
- 60261 1
- 60401 1
- 60499 1
- 60605 1
- 60716 1
- 60804 1
- 60905 1
- 60911 1
- 61015 1
- 61105 1
- 61188 1
- 61265 1
- 61339 1
- 61409 1
- 61422 1
- 61490 1
- 61566 1
- 61631 1
- 61707 1
- 61772 1
- 61967 1
- 62127 1
- 62242 1
- 62255 1
- 62285 1
- 62439 1
- 62646 1
- 62752 1
- 62854 1
- 62953 1
- 63046 1
- 63312 1
- 63431 1
- 63569 1
- 63665 1
- 64081 1
- 64252 1
- 64390 1
- 64393 1
- 64866 1
- 65075 1
- 65309 1
- 65521 1
- 65725 1
- 66183 1
- 66396 1
- 66615 1
- 66811 1
- 67105 1
- 67575 1
- 67817 1
- 68052 1
- 68263 1
- 69059 1
- 69358 1
- 69689 1
- 70864 1
- 71547 1
- 72250 1
- 72302 1
- 75496 1
- 75646 1
- 77648 1
- 79316 1
- 80340 1
- 82784 1
- 83889 1
- 85411 1
- 86715 1
- 87575 1
- 90837 1
- 91930 1
- 92714 1
- 93724 1
- 95132 1
- 95694 1
- 96249 1
- 96737 1
- 97232 1
- 98013 1
- 98350 1
- 98715 1
- 98845 1
- 98941 1
- 99326 1
- 99557 1
- 99689 1
- 99876 1
- 99985 1
- 100149 1
- 100271 1
- 100329 1
- 100417 1
- 100428 1
- 100432 1
- 100629 1
- 100708 1
- 100780 1
- 100832 1
- 100923 1
- 100974 1
- 101022 1
- 101054 1
- 101085 1
- 101140 1
- 101180 1
- 101202 1
- 101229 1
- 101247 1
- 101286 1
- 101323 1
- 101348 1
- 101368 1
- 101390 1
- 101443 1
- 101477 1
- 101496 1
- 101512 1
- 101539 1
- 101590 1
- 101614 1
- 101647 1
- 101663 1
- 101686 1
- 101728 1
- 101754 1
- 101783 1
- 101839 1
- 101847 1
- 101898 1
- 101931 1
- 101966 1
- 101993 1
- 102126 1
- 102169 1
- 102219 1
- 102285 1
- 102474 1
- 102534 1
- 102603 1
- 102666 1
- 102725 1
- 102835 1
- 102962 1
- 103068 1
- 103144 1
- 103460 1
- 103598 1
- 103716 1
- 103835 1
- 103932 1
state 1
- Missouri 787
fips 1
- 29183 · 787 ✖
county 1
- St. Charles 787
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4088 | 4088 | 2020-03-18 | St. Charles | Missouri | 29183 | 1 | 0 |
4807 | 4807 | 2020-03-19 | St. Charles | Missouri | 29183 | 1 | 0 |
5645 | 5645 | 2020-03-20 | St. Charles | Missouri | 29183 | 3 | 0 |
6635 | 6635 | 2020-03-21 | St. Charles | Missouri | 29183 | 3 | 0 |
7724 | 7724 | 2020-03-22 | St. Charles | Missouri | 29183 | 3 | 0 |
8915 | 8915 | 2020-03-23 | St. Charles | Missouri | 29183 | 4 | 0 |
10217 | 10217 | 2020-03-24 | St. Charles | Missouri | 29183 | 4 | 0 |
11646 | 11646 | 2020-03-25 | St. Charles | Missouri | 29183 | 18 | 1 |
13244 | 13244 | 2020-03-26 | St. Charles | Missouri | 29183 | 22 | 1 |
14972 | 14972 | 2020-03-27 | St. Charles | Missouri | 29183 | 32 | 1 |
16797 | 16797 | 2020-03-28 | St. Charles | Missouri | 29183 | 37 | 2 |
18719 | 18719 | 2020-03-29 | St. Charles | Missouri | 29183 | 43 | 2 |
20752 | 20752 | 2020-03-30 | St. Charles | Missouri | 29183 | 56 | 2 |
22871 | 22871 | 2020-03-31 | St. Charles | Missouri | 29183 | 95 | 3 |
25059 | 25059 | 2020-04-01 | St. Charles | Missouri | 29183 | 95 | 3 |
27316 | 27316 | 2020-04-02 | St. Charles | Missouri | 29183 | 105 | 5 |
29638 | 29638 | 2020-04-03 | St. Charles | Missouri | 29183 | 132 | 5 |
32019 | 32019 | 2020-04-04 | St. Charles | Missouri | 29183 | 143 | 7 |
34447 | 34447 | 2020-04-05 | St. Charles | Missouri | 29183 | 157 | 7 |
36913 | 36913 | 2020-04-06 | St. Charles | Missouri | 29183 | 188 | 7 |
39429 | 39429 | 2020-04-07 | St. Charles | Missouri | 29183 | 221 | 9 |
41983 | 41983 | 2020-04-08 | St. Charles | Missouri | 29183 | 254 | 10 |
44560 | 44560 | 2020-04-09 | St. Charles | Missouri | 29183 | 274 | 11 |
47169 | 47169 | 2020-04-10 | St. Charles | Missouri | 29183 | 298 | 11 |
49817 | 49817 | 2020-04-11 | St. Charles | Missouri | 29183 | 320 | 11 |
52490 | 52490 | 2020-04-12 | St. Charles | Missouri | 29183 | 328 | 11 |
55172 | 55172 | 2020-04-13 | St. Charles | Missouri | 29183 | 346 | 14 |
57870 | 57870 | 2020-04-14 | St. Charles | Missouri | 29183 | 368 | 16 |
60584 | 60584 | 2020-04-15 | St. Charles | Missouri | 29183 | 392 | 17 |
63306 | 63306 | 2020-04-16 | St. Charles | Missouri | 29183 | 405 | 17 |
66046 | 66046 | 2020-04-17 | St. Charles | Missouri | 29183 | 417 | 17 |
68800 | 68800 | 2020-04-18 | St. Charles | Missouri | 29183 | 426 | 18 |
71567 | 71567 | 2020-04-19 | St. Charles | Missouri | 29183 | 435 | 19 |
74340 | 74340 | 2020-04-20 | St. Charles | Missouri | 29183 | 447 | 23 |
77121 | 77121 | 2020-04-21 | St. Charles | Missouri | 29183 | 458 | 24 |
79908 | 79908 | 2020-04-22 | St. Charles | Missouri | 29183 | 467 | 25 |
82704 | 82704 | 2020-04-23 | St. Charles | Missouri | 29183 | 476 | 26 |
85508 | 85508 | 2020-04-24 | St. Charles | Missouri | 29183 | 502 | 26 |
88318 | 88318 | 2020-04-25 | St. Charles | Missouri | 29183 | 513 | 29 |
91134 | 91134 | 2020-04-26 | St. Charles | Missouri | 29183 | 526 | 31 |
93955 | 93955 | 2020-04-27 | St. Charles | Missouri | 29183 | 543 | 31 |
96791 | 96791 | 2020-04-28 | St. Charles | Missouri | 29183 | 555 | 34 |
99637 | 99637 | 2020-04-29 | St. Charles | Missouri | 29183 | 560 | 34 |
102489 | 102489 | 2020-04-30 | St. Charles | Missouri | 29183 | 566 | 34 |
105350 | 105350 | 2020-05-01 | St. Charles | Missouri | 29183 | 577 | 35 |
108215 | 108215 | 2020-05-02 | St. Charles | Missouri | 29183 | 596 | 41 |
111087 | 111087 | 2020-05-03 | St. Charles | Missouri | 29183 | 612 | 41 |
113966 | 113966 | 2020-05-04 | St. Charles | Missouri | 29183 | 624 | 42 |
116848 | 116848 | 2020-05-05 | St. Charles | Missouri | 29183 | 626 | 43 |
119808 | 119808 | 2020-05-06 | St. Charles | Missouri | 29183 | 639 | 45 |
122782 | 122782 | 2020-05-07 | St. Charles | Missouri | 29183 | 646 | 46 |
125764 | 125764 | 2020-05-08 | St. Charles | Missouri | 29183 | 663 | 46 |
128752 | 128752 | 2020-05-09 | St. Charles | Missouri | 29183 | 668 | 46 |
131742 | 131742 | 2020-05-10 | St. Charles | Missouri | 29183 | 670 | 47 |
134733 | 134733 | 2020-05-11 | St. Charles | Missouri | 29183 | 684 | 50 |
137723 | 137723 | 2020-05-12 | St. Charles | Missouri | 29183 | 680 | 50 |
140717 | 140717 | 2020-05-13 | St. Charles | Missouri | 29183 | 681 | 50 |
143712 | 143712 | 2020-05-14 | St. Charles | Missouri | 29183 | 688 | 52 |
146713 | 146713 | 2020-05-15 | St. Charles | Missouri | 29183 | 688 | 52 |
149719 | 149719 | 2020-05-16 | St. Charles | Missouri | 29183 | 695 | 52 |
152730 | 152730 | 2020-05-17 | St. Charles | Missouri | 29183 | 701 | 52 |
155744 | 155744 | 2020-05-18 | St. Charles | Missouri | 29183 | 705 | 53 |
158762 | 158762 | 2020-05-19 | St. Charles | Missouri | 29183 | 712 | 53 |
161788 | 161788 | 2020-05-20 | St. Charles | Missouri | 29183 | 715 | 55 |
164817 | 164817 | 2020-05-21 | St. Charles | Missouri | 29183 | 714 | 54 |
167853 | 167853 | 2020-05-22 | St. Charles | Missouri | 29183 | 726 | 54 |
170892 | 170892 | 2020-05-23 | St. Charles | Missouri | 29183 | 730 | 54 |
173934 | 173934 | 2020-05-24 | St. Charles | Missouri | 29183 | 741 | 54 |
176977 | 176977 | 2020-05-25 | St. Charles | Missouri | 29183 | 743 | 54 |
180021 | 180021 | 2020-05-26 | St. Charles | Missouri | 29183 | 748 | 54 |
183069 | 183069 | 2020-05-27 | St. Charles | Missouri | 29183 | 755 | 55 |
186125 | 186125 | 2020-05-28 | St. Charles | Missouri | 29183 | 763 | 55 |
189183 | 189183 | 2020-05-29 | St. Charles | Missouri | 29183 | 768 | 57 |
192247 | 192247 | 2020-05-30 | St. Charles | Missouri | 29183 | 775 | 58 |
195317 | 195317 | 2020-05-31 | St. Charles | Missouri | 29183 | 780 | 59 |
198388 | 198388 | 2020-06-01 | St. Charles | Missouri | 29183 | 787 | 60 |
201461 | 201461 | 2020-06-02 | St. Charles | Missouri | 29183 | 799 | 61 |
204538 | 204538 | 2020-06-03 | St. Charles | Missouri | 29183 | 809 | 61 |
207619 | 207619 | 2020-06-04 | St. Charles | Missouri | 29183 | 821 | 62 |
210700 | 210700 | 2020-06-05 | St. Charles | Missouri | 29183 | 835 | 62 |
213784 | 213784 | 2020-06-06 | St. Charles | Missouri | 29183 | 838 | 62 |
216873 | 216873 | 2020-06-07 | St. Charles | Missouri | 29183 | 844 | 62 |
219965 | 219965 | 2020-06-08 | St. Charles | Missouri | 29183 | 851 | 63 |
223060 | 223060 | 2020-06-09 | St. Charles | Missouri | 29183 | 867 | 63 |
226159 | 226159 | 2020-06-10 | St. Charles | Missouri | 29183 | 879 | 63 |
229262 | 229262 | 2020-06-11 | St. Charles | Missouri | 29183 | 879 | 63 |
232366 | 232366 | 2020-06-12 | St. Charles | Missouri | 29183 | 888 | 64 |
235472 | 235472 | 2020-06-13 | St. Charles | Missouri | 29183 | 895 | 67 |
238579 | 238579 | 2020-06-14 | St. Charles | Missouri | 29183 | 909 | 67 |
241689 | 241689 | 2020-06-15 | St. Charles | Missouri | 29183 | 918 | 67 |
244800 | 244800 | 2020-06-16 | St. Charles | Missouri | 29183 | 924 | 67 |
247913 | 247913 | 2020-06-17 | St. Charles | Missouri | 29183 | 934 | 67 |
251026 | 251026 | 2020-06-18 | St. Charles | Missouri | 29183 | 939 | 72 |
254141 | 254141 | 2020-06-19 | St. Charles | Missouri | 29183 | 945 | 72 |
257262 | 257262 | 2020-06-20 | St. Charles | Missouri | 29183 | 951 | 72 |
260388 | 260388 | 2020-06-21 | St. Charles | Missouri | 29183 | 954 | 72 |
263516 | 263516 | 2020-06-22 | St. Charles | Missouri | 29183 | 959 | 72 |
266642 | 266642 | 2020-06-23 | St. Charles | Missouri | 29183 | 974 | 73 |
269775 | 269775 | 2020-06-24 | St. Charles | Missouri | 29183 | 997 | 73 |
272914 | 272914 | 2020-06-25 | St. Charles | Missouri | 29183 | 1011 | 73 |
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);