ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Pitt" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 616 ✖
- 52272 7
- 52313 7
- 52353 7
- 52475 7
- 52595 7
- 31585 6
- 30292 5
- 18228 4
- 20164 4
- 20514 4
- 24854 4
- 39709 4
- 10490 3
- 18120 3
- 18436 3
- 18704 3
- 19000 3
- 19269 3
- 19542 3
- 19824 3
- 19999 3
- 20284 3
- 20376 3
- 20436 3
- 20475 3
- 20613 3
- 20736 3
- 20936 3
- 21303 3
- 21744 3
- 22511 3
- 23198 3
- 23970 3
- 25706 3
- 26864 3
- 27769 3
- 28410 3
- 28711 3
- 29209 3
- 29448 3
- 29706 3
- 29871 3
- 30032 3
- 30195 3
- 30550 3
- 30942 3
- 31340 3
- 32746 3
- 35532 3
- 44600 3
- 48220 3
- 49775 3
- 51008 3
- 51681 3
- 51956 3
- 52129 3
- 52202 3
- 52251 3
- 52324 3
- 52352 3
- 52792 3
- 1 2
- 3 2
- 27 2
- 36 2
- 93 2
- 111 2
- 267 2
- 7599 2
- 11454 2
- 13913 2
- 15164 2
- 17466 2
- 17698 2
- 17822 2
- 17996 2
- 29970 2
- 52357 2
- 5 1
- 6 1
- 8 1
- 10 1
- 13 1
- 15 1
- 16 1
- 29 1
- 31 1
- 35 1
- 44 1
- 51 1
- 57 1
- 60 1
- 62 1
- 63 1
- 65 1
- 68 1
- 69 1
- 80 1
- 83 1
- 89 1
- 96 1
- 99 1
- 100 1
- 104 1
- 110 1
- 115 1
- 120 1
- 123 1
- 124 1
- 128 1
- 129 1
- 135 1
- 144 1
- 145 1
- 152 1
- 160 1
- 162 1
- 165 1
- 169 1
- 178 1
- 182 1
- 185 1
- 196 1
- 202 1
- 207 1
- 213 1
- 221 1
- 228 1
- 234 1
- 246 1
- 254 1
- 257 1
- 264 1
- 273 1
- 286 1
- 295 1
- 304 1
- 313 1
- 316 1
- 321 1
- 326 1
- 332 1
- 382 1
- 394 1
- 397 1
- 404 1
- 416 1
- 432 1
- 451 1
- 464 1
- 481 1
- 493 1
- 500 1
- 502 1
- 507 1
- 528 1
- 553 1
- 561 1
- 567 1
- 579 1
- 602 1
- 611 1
- 638 1
- 650 1
- 660 1
- 679 1
- 696 1
- 709 1
- 732 1
- 758 1
- 785 1
- 804 1
- 822 1
- 844 1
- 858 1
- 876 1
- 890 1
- 913 1
- 946 1
- 963 1
- 978 1
- 1000 1
- 1040 1
- 1079 1
- 1130 1
- 1173 1
- 1215 1
- 1239 1
- 1293 1
- 1313 1
- 1376 1
- 1421 1
- 1472 1
- 1519 1
- 1548 1
- 1579 1
- 1639 1
- 1699 1
- 1739 1
- 1766 1
- 1795 1
- 1802 1
- 1833 1
- 1875 1
- 1899 1
- 1962 1
- 2020 1
- 2036 1
- 2054 1
- 2105 1
- 2161 1
- 2205 1
- 2241 1
- 2278 1
- 2308 1
- 2341 1
- 2350 1
- 2404 1
- 2493 1
- 2572 1
- 2670 1
- 2766 1
- 2855 1
- 2934 1
- 3088 1
- 3229 1
- 3376 1
- 3490 1
- 3529 1
- 3617 1
- 3667 1
- 3761 1
- 3857 1
- 3953 1
- 4013 1
- 4044 1
- 4077 1
- 4103 1
- 4155 1
- 4211 1
- 4261 1
- 4294 1
- 4318 1
- 4345 1
- 4380 1
- 4428 1
- 4466 1
- 4498 1
- 4542 1
- 4572 1
- 4609 1
- 4640 1
- 4695 1
- 4852 1
- 4895 1
- 4918 1
- 4931 1
- 4945 1
- 4976 1
- 5019 1
- 5044 1
- 5073 1
- 5096 1
- 5133 1
- 5174 1
- 5281 1
- 5343 1
- 5389 1
- 5453 1
- 5490 1
- 5507 1
- 5537 1
- 5593 1
- 5655 1
- 5703 1
- 5772 1
- 5828 1
- 5837 1
- 5859 1
- 5902 1
- 5958 1
- 6007 1
- 6063 1
- 6090 1
- 6102 1
- 6113 1
- 6142 1
- 6196 1
- 6246 1
- 6300 1
- 6331 1
- 6332 1
- 6372 1
- 6445 1
- 6493 1
- 6549 1
- 6624 1
- 6660 1
- 6665 1
- 6693 1
- 6744 1
- 6800 1
- 6867 1
- 6958 1
- 7015 1
- 7041 1
- 7059 1
- 7101 1
- 7220 1
- 7285 1
- 7317 1
- 7457 1
- 7498 1
- 7531 1
- 7771 1
- 7816 1
- 7897 1
- 7935 1
- 7977 1
- 8057 1
- 8247 1
- 8383 1
- 8455 1
- 8641 1
- 8741 1
- 8791 1
- 8884 1
- 9038 1
- 9208 1
- 9331 1
- 9467 1
- 9551 1
- 9590 1
- 9674 1
- 9778 1
- 10001 1
- 10141 1
- 10267 1
- 10332 1
- 10385 1
- 10914 1
- 10929 1
- 11008 1
- 11051 1
- 11215 1
- 11902 1
- 12013 1
- 12124 1
- 12186 1
- 12327 1
- 12584 1
- 12791 1
- 12955 1
- 13084 1
- 13198 1
- 13247 1
- 13400 1
- 13546 1
- 13692 1
- 13814 1
- 14038 1
- 14201 1
- 14305 1
- 14457 1
- 14597 1
- 14714 1
- 14796 1
- 14822 1
- 14909 1
- 15037 1
- 15387 1
- 15450 1
- 15480 1
- 15718 1
- 15817 1
- 15877 1
- 16048 1
- 16143 1
- 16199 1
- 16233 1
- 16323 1
- 16422 1
- 16527 1
- 16633 1
- 16705 1
- 16736 1
- 16759 1
- 16823 1
- 16914 1
- 16996 1
- 17087 1
- 17117 1
- 17162 1
- 17183 1
- 17253 1
- 17321 1
- 17387 1
- 17534 1
- 17553 1
- 17600 1
- 17644 1
- 17665 1
- 17735 1
- 17745 1
- 17767 1
- 17796 1
- 17824 1
- 17883 1
- 17901 1
- 17920 1
- 17946 1
- 17974 1
- 18036 1
- 18042 1
- 18064 1
- 18088 1
- 18153 1
- 18156 1
- 18192 1
- 18304 1
- 18311 1
- 18350 1
- 18382 1
- 18548 1
- 18563 1
- 18606 1
- 18646 1
- 18844 1
- 18850 1
- 18898 1
- 18953 1
- 19129 1
- 19154 1
- 19183 1
- 19219 1
- 19377 1
- 19399 1
- 19430 1
- 19498 1
- 19653 1
- 19678 1
- 19742 1
- 19790 1
- 19888 1
- 19897 1
- 19924 1
- 19951 1
- 20065 1
- 20072 1
- 20088 1
- 20113 1
- 20241 1
- 20243 1
- 20261 1
- 20325 1
- 20347 1
- 20355 1
- 20366 1
- 20412 1
- 20414 1
- 20422 1
- 20429 1
- 20449 1
- 20455 1
- 20462 1
- 20472 1
- 20490 1
- 20491 1
- 20499 1
- 20504 1
- 20552 1
- 20560 1
- 20595 1
- 20655 1
- 20662 1
- 20687 1
- 20713 1
- 20799 1
- 20822 1
- 20850 1
- 20902 1
- 21050 1
- 21082 1
- 21149 1
- 21241 1
- 21457 1
- 21500 1
- 21579 1
- 21646 1
- 22066 1
- 22136 1
- 22232 1
- 22366 1
- 22800 1
- 22877 1
- 22978 1
- 23102 1
- 23482 1
- 23542 1
- 23635 1
- 23758 1
- 24302 1
- 24419 1
- 24527 1
- 24716 1
- 25401 1
- 25493 1
- 25671 1
- 26376 1
- 26461 1
- 26570 1
- 26669 1
- 27311 1
- 27382 1
- 27531 1
- 27651 1
- 28072 1
- 28132 1
- 28234 1
- 28322 1
- 28599 1
- 28620 1
- 28671 1
- 28694 1
- 29019 1
- 29036 1
- 29097 1
- 29150 1
- 29301 1
- 29316 1
- 29325 1
- 29390 1
- 29521 1
- 29550 1
- 29609 1
- 29672 1
- 29770 1
- 29786 1
- 29823 1
- 29846 1
- 29910 1
- 29913 1
- 30072 1
- 30086 1
- 30107 1
- 30147 1
- 30254 1
- 30267 1
- 30387 1
- 30407 1
- 30453 1
- 30499 1
- 30711 1
- 30758 1
- 30819 1
- 30892 1
- 31128 1
- 31153 1
- 31222 1
- 31282 1
- 31471 1
- 31509 1
- 31969 1
- 31976 1
- 32335 1
- 33681 1
- 33939 1
- 34421 1
- 34812 1
- 36996 1
- 37306 1
- 37879 1
- 38793 1
- 42347 1
- 42710 1
- 43547 1
- 46099 1
- 46822 1
- 47251 1
- 47679 1
- 48951 1
- 49056 1
- 49427 1
- 49686 1
- 50245 1
- 50263 1
- 50588 1
- 50795 1
- 51287 1
- 51323 1
- 51471 1
- 51574 1
- 51818 1
- 51828 1
- 51861 1
- 51918 1
- 52029 1
- 52034 1
- 52075 1
- 52108 1
- 52163 1
- 52168 1
- 52185 1
- 52196 1
- 52222 1
- 52223 1
- 52235 1
- 52240 1
- 52291 1
- 52298 1
- 52310 1
- 52318 1
- 52335 1
- 52336 1
- 52342 1
- 52347 1
state 1
- North Carolina 785
fips 1
- 37147 785
county 1
- Pitt · 785 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5773 | 5773 | 2020-03-20 | Pitt | North Carolina | 37147 | 1 | 0 |
6770 | 6770 | 2020-03-21 | Pitt | North Carolina | 37147 | 1 | 0 |
7873 | 7873 | 2020-03-22 | Pitt | North Carolina | 37147 | 3 | 0 |
9074 | 9074 | 2020-03-23 | Pitt | North Carolina | 37147 | 3 | 0 |
10383 | 10383 | 2020-03-24 | Pitt | North Carolina | 37147 | 5 | 0 |
11828 | 11828 | 2020-03-25 | Pitt | North Carolina | 37147 | 6 | 0 |
13432 | 13432 | 2020-03-26 | Pitt | North Carolina | 37147 | 8 | 0 |
15168 | 15168 | 2020-03-27 | Pitt | North Carolina | 37147 | 10 | 0 |
17001 | 17001 | 2020-03-28 | Pitt | North Carolina | 37147 | 13 | 0 |
18933 | 18933 | 2020-03-29 | Pitt | North Carolina | 37147 | 15 | 0 |
20973 | 20973 | 2020-03-30 | Pitt | North Carolina | 37147 | 16 | 0 |
23100 | 23100 | 2020-03-31 | Pitt | North Carolina | 37147 | 27 | 0 |
25294 | 25294 | 2020-04-01 | Pitt | North Carolina | 37147 | 27 | 0 |
27559 | 27559 | 2020-04-02 | Pitt | North Carolina | 37147 | 29 | 0 |
29886 | 29886 | 2020-04-03 | Pitt | North Carolina | 37147 | 31 | 0 |
32273 | 32273 | 2020-04-04 | Pitt | North Carolina | 37147 | 35 | 0 |
34705 | 34705 | 2020-04-05 | Pitt | North Carolina | 37147 | 36 | 0 |
37174 | 37174 | 2020-04-06 | Pitt | North Carolina | 37147 | 36 | 0 |
39689 | 39689 | 2020-04-07 | Pitt | North Carolina | 37147 | 44 | 0 |
42246 | 42246 | 2020-04-08 | Pitt | North Carolina | 37147 | 51 | 0 |
44830 | 44830 | 2020-04-09 | Pitt | North Carolina | 37147 | 57 | 0 |
47443 | 47443 | 2020-04-10 | Pitt | North Carolina | 37147 | 60 | 1 |
50098 | 50098 | 2020-04-11 | Pitt | North Carolina | 37147 | 62 | 1 |
52771 | 52771 | 2020-04-12 | Pitt | North Carolina | 37147 | 63 | 1 |
55455 | 55455 | 2020-04-13 | Pitt | North Carolina | 37147 | 65 | 1 |
58155 | 58155 | 2020-04-14 | Pitt | North Carolina | 37147 | 68 | 1 |
60869 | 60869 | 2020-04-15 | Pitt | North Carolina | 37147 | 69 | 1 |
63595 | 63595 | 2020-04-16 | Pitt | North Carolina | 37147 | 80 | 1 |
66338 | 66338 | 2020-04-17 | Pitt | North Carolina | 37147 | 83 | 1 |
69095 | 69095 | 2020-04-18 | Pitt | North Carolina | 37147 | 89 | 1 |
71861 | 71861 | 2020-04-19 | Pitt | North Carolina | 37147 | 93 | 1 |
74636 | 74636 | 2020-04-20 | Pitt | North Carolina | 37147 | 93 | 1 |
77417 | 77417 | 2020-04-21 | Pitt | North Carolina | 37147 | 96 | 1 |
80206 | 80206 | 2020-04-22 | Pitt | North Carolina | 37147 | 99 | 1 |
83005 | 83005 | 2020-04-23 | Pitt | North Carolina | 37147 | 100 | 2 |
85809 | 85809 | 2020-04-24 | Pitt | North Carolina | 37147 | 104 | 2 |
88622 | 88622 | 2020-04-25 | Pitt | North Carolina | 37147 | 111 | 2 |
91437 | 91437 | 2020-04-26 | Pitt | North Carolina | 37147 | 111 | 2 |
94263 | 94263 | 2020-04-27 | Pitt | North Carolina | 37147 | 110 | 2 |
97100 | 97100 | 2020-04-28 | Pitt | North Carolina | 37147 | 115 | 2 |
99948 | 99948 | 2020-04-29 | Pitt | North Carolina | 37147 | 120 | 2 |
102801 | 102801 | 2020-04-30 | Pitt | North Carolina | 37147 | 123 | 2 |
105663 | 105663 | 2020-05-01 | Pitt | North Carolina | 37147 | 124 | 2 |
108530 | 108530 | 2020-05-02 | Pitt | North Carolina | 37147 | 128 | 2 |
111403 | 111403 | 2020-05-03 | Pitt | North Carolina | 37147 | 129 | 2 |
114284 | 114284 | 2020-05-04 | Pitt | North Carolina | 37147 | 135 | 2 |
117164 | 117164 | 2020-05-05 | Pitt | North Carolina | 37147 | 144 | 2 |
120125 | 120125 | 2020-05-06 | Pitt | North Carolina | 37147 | 145 | 2 |
123100 | 123100 | 2020-05-07 | Pitt | North Carolina | 37147 | 152 | 2 |
126083 | 126083 | 2020-05-08 | Pitt | North Carolina | 37147 | 160 | 2 |
129072 | 129072 | 2020-05-09 | Pitt | North Carolina | 37147 | 162 | 2 |
132061 | 132061 | 2020-05-10 | Pitt | North Carolina | 37147 | 165 | 2 |
135052 | 135052 | 2020-05-11 | Pitt | North Carolina | 37147 | 169 | 2 |
138042 | 138042 | 2020-05-12 | Pitt | North Carolina | 37147 | 178 | 2 |
141038 | 141038 | 2020-05-13 | Pitt | North Carolina | 37147 | 182 | 2 |
144033 | 144033 | 2020-05-14 | Pitt | North Carolina | 37147 | 185 | 2 |
147034 | 147034 | 2020-05-15 | Pitt | North Carolina | 37147 | 196 | 2 |
150041 | 150041 | 2020-05-16 | Pitt | North Carolina | 37147 | 202 | 2 |
153051 | 153051 | 2020-05-17 | Pitt | North Carolina | 37147 | 207 | 2 |
156068 | 156068 | 2020-05-18 | Pitt | North Carolina | 37147 | 213 | 2 |
159087 | 159087 | 2020-05-19 | Pitt | North Carolina | 37147 | 221 | 2 |
162114 | 162114 | 2020-05-20 | Pitt | North Carolina | 37147 | 228 | 2 |
165143 | 165143 | 2020-05-21 | Pitt | North Carolina | 37147 | 234 | 2 |
168178 | 168178 | 2020-05-22 | Pitt | North Carolina | 37147 | 246 | 2 |
171217 | 171217 | 2020-05-23 | Pitt | North Carolina | 37147 | 254 | 2 |
174259 | 174259 | 2020-05-24 | Pitt | North Carolina | 37147 | 257 | 2 |
177303 | 177303 | 2020-05-25 | Pitt | North Carolina | 37147 | 264 | 2 |
180346 | 180346 | 2020-05-26 | Pitt | North Carolina | 37147 | 267 | 2 |
183394 | 183394 | 2020-05-27 | Pitt | North Carolina | 37147 | 267 | 2 |
186451 | 186451 | 2020-05-28 | Pitt | North Carolina | 37147 | 273 | 2 |
189511 | 189511 | 2020-05-29 | Pitt | North Carolina | 37147 | 286 | 2 |
192575 | 192575 | 2020-05-30 | Pitt | North Carolina | 37147 | 295 | 2 |
195645 | 195645 | 2020-05-31 | Pitt | North Carolina | 37147 | 304 | 2 |
198718 | 198718 | 2020-06-01 | Pitt | North Carolina | 37147 | 313 | 2 |
201792 | 201792 | 2020-06-02 | Pitt | North Carolina | 37147 | 316 | 2 |
204869 | 204869 | 2020-06-03 | Pitt | North Carolina | 37147 | 321 | 2 |
207950 | 207950 | 2020-06-04 | Pitt | North Carolina | 37147 | 326 | 2 |
211032 | 211032 | 2020-06-05 | Pitt | North Carolina | 37147 | 332 | 2 |
214116 | 214116 | 2020-06-06 | Pitt | North Carolina | 37147 | 382 | 2 |
217206 | 217206 | 2020-06-07 | Pitt | North Carolina | 37147 | 394 | 2 |
220298 | 220298 | 2020-06-08 | Pitt | North Carolina | 37147 | 397 | 2 |
223392 | 223392 | 2020-06-09 | Pitt | North Carolina | 37147 | 404 | 2 |
226492 | 226492 | 2020-06-10 | Pitt | North Carolina | 37147 | 416 | 2 |
229596 | 229596 | 2020-06-11 | Pitt | North Carolina | 37147 | 432 | 2 |
232701 | 232701 | 2020-06-12 | Pitt | North Carolina | 37147 | 451 | 2 |
235806 | 235806 | 2020-06-13 | Pitt | North Carolina | 37147 | 464 | 2 |
238914 | 238914 | 2020-06-14 | Pitt | North Carolina | 37147 | 481 | 2 |
242023 | 242023 | 2020-06-15 | Pitt | North Carolina | 37147 | 493 | 2 |
245135 | 245135 | 2020-06-16 | Pitt | North Carolina | 37147 | 500 | 2 |
248248 | 248248 | 2020-06-17 | Pitt | North Carolina | 37147 | 502 | 3 |
251363 | 251363 | 2020-06-18 | Pitt | North Carolina | 37147 | 507 | 3 |
254478 | 254478 | 2020-06-19 | Pitt | North Carolina | 37147 | 528 | 3 |
257601 | 257601 | 2020-06-20 | Pitt | North Carolina | 37147 | 553 | 4 |
260728 | 260728 | 2020-06-21 | Pitt | North Carolina | 37147 | 561 | 4 |
263856 | 263856 | 2020-06-22 | Pitt | North Carolina | 37147 | 567 | 4 |
266984 | 266984 | 2020-06-23 | Pitt | North Carolina | 37147 | 579 | 4 |
270118 | 270118 | 2020-06-24 | Pitt | North Carolina | 37147 | 602 | 5 |
273257 | 273257 | 2020-06-25 | Pitt | North Carolina | 37147 | 611 | 5 |
276403 | 276403 | 2020-06-26 | Pitt | North Carolina | 37147 | 638 | 5 |
279551 | 279551 | 2020-06-27 | Pitt | North Carolina | 37147 | 650 | 5 |
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);