ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 29167 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 442 ✖
- 1 39
- 8040 35
- 2 16
- 3305 11
- 3325 11
- 4 7
- 3319 7
- 8064 7
- 10 6
- 3187 6
- 15 5
- 366 5
- 1729 5
- 2377 5
- 3300 5
- 3351 5
- 4016 5
- 4149 5
- 5300 5
- 7946 5
- 13 4
- 317 4
- 913 4
- 1457 4
- 2576 4
- 2937 4
- 3292 4
- 3438 4
- 3567 4
- 3681 4
- 3868 4
- 4260 4
- 4408 4
- 5754 4
- 5869 4
- 7833 4
- 7998 4
- 3 3
- 11 3
- 16 3
- 248 3
- 288 3
- 460 3
- 551 3
- 688 3
- 819 3
- 1039 3
- 1140 3
- 1232 3
- 1335 3
- 1622 3
- 1959 3
- 2281 3
- 2789 3
- 3021 3
- 3097 3
- 3154 3
- 3211 3
- 3225 3
- 3250 3
- 3268 3
- 3282 3
- 3303 3
- 3309 3
- 3341 3
- 3387 3
- 3517 3
- 3763 3
- 4983 3
- 6464 3
- 7985 3
- 8007 3
- 8013 3
- 8022 3
- 7 2
- 8 2
- 19 2
- 22 2
- 150 2
- 209 2
- 300 2
- 589 2
- 1415 2
- 2100 2
- 2125 2
- 2880 2
- 3263 2
- 3288 2
- 4361 2
- 5021 2
- 5063 2
- 5094 2
- 5097 2
- 5101 2
- 5168 2
- 5383 2
- 7995 2
- 8005 2
- 8010 2
- 9 1
- 12 1
- 17 1
- 20 1
- 21 1
- 23 1
- 25 1
- 26 1
- 55 1
- 85 1
- 93 1
- 114 1
- 125 1
- 137 1
- 144 1
- 153 1
- 170 1
- 184 1
- 186 1
- 187 1
- 189 1
- 191 1
- 192 1
- 194 1
- 196 1
- 200 1
- 208 1
- 210 1
- 213 1
- 219 1
- 242 1
- 258 1
- 271 1
- 275 1
- 281 1
- 302 1
- 307 1
- 347 1
- 351 1
- 407 1
- 443 1
- 447 1
- 494 1
- 519 1
- 528 1
- 535 1
- 629 1
- 675 1
- 733 1
- 747 1
- 769 1
- 805 1
- 850 1
- 863 1
- 874 1
- 893 1
- 973 1
- 995 1
- 1008 1
- 1079 1
- 1106 1
- 1119 1
- 1130 1
- 1178 1
- 1184 1
- 1203 1
- 1217 1
- 1265 1
- 1284 1
- 1297 1
- 1315 1
- 1386 1
- 1545 1
- 1575 1
- 1595 1
- 1608 1
- 1672 1
- 1694 1
- 1842 1
- 1871 1
- 1888 1
- 1903 1
- 2014 1
- 2058 1
- 2080 1
- 2163 1
- 2206 1
- 2231 1
- 2262 1
- 2332 1
- 2361 1
- 2450 1
- 2483 1
- 2505 1
- 2642 1
- 2685 1
- 2716 1
- 2754 1
- 2838 1
- 2927 1
- 2970 1
- 2986 1
- 3004 1
- 3059 1
- 3068 1
- 3075 1
- 3084 1
- 3110 1
- 3124 1
- 3132 1
- 3145 1
- 3171 1
- 3176 1
- 3179 1
- 3201 1
- 3207 1
- 3216 1
- 3217 1
- 3220 1
- 3224 1
- 3236 1
- 3240 1
- 3246 1
- 3248 1
- 3261 1
- 3265 1
- 3270 1
- 3274 1
- 3275 1
- 3278 1
- 3284 1
- 3289 1
- 3294 1
- 3302 1
- 3370 1
- 3381 1
- 3397 1
- 3412 1
- 3425 1
- 3433 1
- 3457 1
- 3484 1
- 3501 1
- 3527 1
- 3542 1
- 3553 1
- 3612 1
- 3624 1
- 3655 1
- 3666 1
- 3711 1
- 3726 1
- 3747 1
- 3790 1
- 3819 1
- 3840 1
- 3855 1
- 3921 1
- 3957 1
- 3989 1
- 4105 1
- 4133 1
- 4164 1
- 4190 1
- 4283 1
- 4421 1
- 4445 1
- 4470 1
- 4508 1
- 4511 1
- 4520 1
- 4523 1
- 4536 1
- 4558 1
- 4576 1
- 4587 1
- 4598 1
- 4600 1
- 4601 1
- 4630 1
- 4647 1
- 4670 1
- 4691 1
- 4713 1
- 4716 1
- 4718 1
- 4739 1
- 4749 1
- 4763 1
- 4775 1
- 4780 1
- 4782 1
- 4795 1
- 4796 1
- 4819 1
- 4829 1
- 4841 1
- 4849 1
- 4851 1
- 4852 1
- 4856 1
- 4873 1
- 4882 1
- 4887 1
- 4895 1
- 4896 1
- 4900 1
- 4911 1
- 4916 1
- 4926 1
- 4932 1
- 4941 1
- 4942 1
- 4948 1
- 4955 1
- 4959 1
- 4967 1
- 4971 1
- 4992 1
- 4997 1
- 5005 1
- 5015 1
- 5020 1
- 5033 1
- 5046 1
- 5050 1
- 5056 1
- 5061 1
- 5071 1
- 5078 1
- 5082 1
- 5085 1
- 5086 1
- 5087 1
- 5088 1
- 5100 1
- 5106 1
- 5112 1
- 5118 1
- 5123 1
- 5125 1
- 5126 1
- 5127 1
- 5135 1
- 5140 1
- 5141 1
- 5145 1
- 5151 1
- 5156 1
- 5157 1
- 5163 1
- 5182 1
- 5187 1
- 5189 1
- 5190 1
- 5205 1
- 5209 1
- 5254 1
- 5264 1
- 5269 1
- 5272 1
- 5273 1
- 5275 1
- 5319 1
- 5325 1
- 5360 1
- 5416 1
- 5431 1
- 5440 1
- 5453 1
- 5473 1
- 5487 1
- 5525 1
- 5542 1
- 5547 1
- 5552 1
- 5573 1
- 5601 1
- 5635 1
- 5658 1
- 5677 1
- 5679 1
- 5682 1
- 5707 1
- 5731 1
- 5809 1
- 5819 1
- 5844 1
- 5926 1
- 5950 1
- 6021 1
- 6071 1
- 6105 1
- 6139 1
- 6147 1
- 6155 1
- 6230 1
- 6284 1
- 6338 1
- 6393 1
- 6633 1
- 6739 1
- 6867 1
- 6975 1
- 7001 1
- 7022 1
- 7050 1
- 7142 1
- 7226 1
- 7306 1
- 7375 1
- 7432 1
- 7447 1
- 7450 1
- 7532 1
- 7590 1
- 7636 1
- 7662 1
- 7692 1
- 7696 1
- 7705 1
- 7743 1
- 7782 1
- 7891 1
- 7911 1
- 7927 1
- 7978 1
- 7983 1
- 7984 1
- 7997 1
- 8001 1
- 8006 1
- 8009 1
- 8012 1
- 8014 1
- 8016 1
- 8018 1
- 8019 1
- 8025 1
- 8030 1
- 8033 1
- 8051 1
- 8073 1
state 1
- Missouri · 767 ✖
fips 1
- 29167 · 767 ✖
county 1
- Polk 767
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501161 | 2501161 | 2022-05-13 | Polk | Missouri | 29167 | 8073 | 108 |
2497903 | 2497903 | 2022-05-12 | Polk | Missouri | 29167 | 8064 | 108 |
2494645 | 2494645 | 2022-05-11 | Polk | Missouri | 29167 | 8064 | 108 |
2491387 | 2491387 | 2022-05-10 | Polk | Missouri | 29167 | 8064 | 108 |
2488129 | 2488129 | 2022-05-09 | Polk | Missouri | 29167 | 8064 | 108 |
2484872 | 2484872 | 2022-05-08 | Polk | Missouri | 29167 | 8064 | 108 |
2481614 | 2481614 | 2022-05-07 | Polk | Missouri | 29167 | 8064 | 108 |
2478356 | 2478356 | 2022-05-06 | Polk | Missouri | 29167 | 8064 | 108 |
2475098 | 2475098 | 2022-05-05 | Polk | Missouri | 29167 | 8051 | 108 |
2471841 | 2471841 | 2022-05-04 | Polk | Missouri | 29167 | 8040 | 108 |
2468585 | 2468585 | 2022-05-03 | Polk | Missouri | 29167 | 8040 | 108 |
2465329 | 2465329 | 2022-05-02 | Polk | Missouri | 29167 | 8040 | 108 |
2462074 | 2462074 | 2022-05-01 | Polk | Missouri | 29167 | 8040 | 108 |
2458818 | 2458818 | 2022-04-30 | Polk | Missouri | 29167 | 8040 | 108 |
2455562 | 2455562 | 2022-04-29 | Polk | Missouri | 29167 | 8040 | 108 |
2452306 | 2452306 | 2022-04-28 | Polk | Missouri | 29167 | 8040 | 108 |
2449050 | 2449050 | 2022-04-27 | Polk | Missouri | 29167 | 8040 | 108 |
2445793 | 2445793 | 2022-04-26 | Polk | Missouri | 29167 | 8040 | 108 |
2442538 | 2442538 | 2022-04-25 | Polk | Missouri | 29167 | 8040 | 108 |
2439282 | 2439282 | 2022-04-24 | Polk | Missouri | 29167 | 8040 | 108 |
2436026 | 2436026 | 2022-04-23 | Polk | Missouri | 29167 | 8040 | 108 |
2432770 | 2432770 | 2022-04-22 | Polk | Missouri | 29167 | 8040 | 108 |
2429514 | 2429514 | 2022-04-21 | Polk | Missouri | 29167 | 8040 | 108 |
2426258 | 2426258 | 2022-04-20 | Polk | Missouri | 29167 | 8040 | 108 |
2423002 | 2423002 | 2022-04-19 | Polk | Missouri | 29167 | 8040 | 108 |
2419745 | 2419745 | 2022-04-18 | Polk | Missouri | 29167 | 8040 | 108 |
2416490 | 2416490 | 2022-04-17 | Polk | Missouri | 29167 | 8040 | 108 |
2413234 | 2413234 | 2022-04-16 | Polk | Missouri | 29167 | 8040 | 108 |
2409978 | 2409978 | 2022-04-15 | Polk | Missouri | 29167 | 8040 | 108 |
2406722 | 2406722 | 2022-04-14 | Polk | Missouri | 29167 | 8040 | 108 |
2403466 | 2403466 | 2022-04-13 | Polk | Missouri | 29167 | 8040 | 108 |
2400211 | 2400211 | 2022-04-12 | Polk | Missouri | 29167 | 8040 | 108 |
2396956 | 2396956 | 2022-04-11 | Polk | Missouri | 29167 | 8040 | 108 |
2393701 | 2393701 | 2022-04-10 | Polk | Missouri | 29167 | 8040 | 108 |
2390445 | 2390445 | 2022-04-09 | Polk | Missouri | 29167 | 8040 | 108 |
2387189 | 2387189 | 2022-04-08 | Polk | Missouri | 29167 | 8040 | 108 |
2383934 | 2383934 | 2022-04-07 | Polk | Missouri | 29167 | 8040 | 108 |
2380679 | 2380679 | 2022-04-06 | Polk | Missouri | 29167 | 8040 | 108 |
2377424 | 2377424 | 2022-04-05 | Polk | Missouri | 29167 | 8040 | 108 |
2374171 | 2374171 | 2022-04-04 | Polk | Missouri | 29167 | 8040 | 108 |
2370919 | 2370919 | 2022-04-03 | Polk | Missouri | 29167 | 8040 | 108 |
2367666 | 2367666 | 2022-04-02 | Polk | Missouri | 29167 | 8040 | 108 |
2364413 | 2364413 | 2022-04-01 | Polk | Missouri | 29167 | 8040 | 108 |
2361159 | 2361159 | 2022-03-31 | Polk | Missouri | 29167 | 8040 | 108 |
2357905 | 2357905 | 2022-03-30 | Polk | Missouri | 29167 | 8033 | 108 |
2354652 | 2354652 | 2022-03-29 | Polk | Missouri | 29167 | 8030 | 108 |
2351399 | 2351399 | 2022-03-28 | Polk | Missouri | 29167 | 8025 | 107 |
2348147 | 2348147 | 2022-03-27 | Polk | Missouri | 29167 | 8022 | 107 |
2344894 | 2344894 | 2022-03-26 | Polk | Missouri | 29167 | 8022 | 107 |
2341641 | 2341641 | 2022-03-25 | Polk | Missouri | 29167 | 8022 | 107 |
2338388 | 2338388 | 2022-03-24 | Polk | Missouri | 29167 | 8019 | 107 |
2335134 | 2335134 | 2022-03-23 | Polk | Missouri | 29167 | 8018 | 107 |
2331880 | 2331880 | 2022-03-22 | Polk | Missouri | 29167 | 8016 | 107 |
2328627 | 2328627 | 2022-03-21 | Polk | Missouri | 29167 | 8014 | 105 |
2325375 | 2325375 | 2022-03-20 | Polk | Missouri | 29167 | 8013 | 105 |
2322121 | 2322121 | 2022-03-19 | Polk | Missouri | 29167 | 8013 | 105 |
2318867 | 2318867 | 2022-03-18 | Polk | Missouri | 29167 | 8013 | 105 |
2315614 | 2315614 | 2022-03-17 | Polk | Missouri | 29167 | 8012 | 105 |
2312361 | 2312361 | 2022-03-16 | Polk | Missouri | 29167 | 8010 | 105 |
2309108 | 2309108 | 2022-03-15 | Polk | Missouri | 29167 | 8010 | 105 |
2305856 | 2305856 | 2022-03-14 | Polk | Missouri | 29167 | 8009 | 103 |
2302605 | 2302605 | 2022-03-13 | Polk | Missouri | 29167 | 8007 | 103 |
2299353 | 2299353 | 2022-03-12 | Polk | Missouri | 29167 | 8007 | 103 |
2296101 | 2296101 | 2022-03-11 | Polk | Missouri | 29167 | 8007 | 103 |
2292849 | 2292849 | 2022-03-10 | Polk | Missouri | 29167 | 8006 | 103 |
2289597 | 2289597 | 2022-03-09 | Polk | Missouri | 29167 | 8005 | 103 |
2286345 | 2286345 | 2022-03-08 | Polk | Missouri | 29167 | 8005 | 103 |
2283093 | 2283093 | 2022-03-07 | Polk | Missouri | 29167 | 8001 | 103 |
2279840 | 2279840 | 2022-03-06 | Polk | Missouri | 29167 | 7998 | 103 |
2276587 | 2276587 | 2022-03-05 | Polk | Missouri | 29167 | 7998 | 103 |
2273334 | 2273334 | 2022-03-04 | Polk | Missouri | 29167 | 7998 | 103 |
2270082 | 2270082 | 2022-03-03 | Polk | Missouri | 29167 | 7998 | 103 |
2266829 | 2266829 | 2022-03-02 | Polk | Missouri | 29167 | 7997 | 103 |
2263578 | 2263578 | 2022-03-01 | Polk | Missouri | 29167 | 7995 | 103 |
2260327 | 2260327 | 2022-02-28 | Polk | Missouri | 29167 | 7995 | 103 |
2257076 | 2257076 | 2022-02-27 | Polk | Missouri | 29167 | 7985 | 102 |
2253825 | 2253825 | 2022-02-26 | Polk | Missouri | 29167 | 7985 | 102 |
2250574 | 2250574 | 2022-02-25 | Polk | Missouri | 29167 | 7985 | 102 |
2247323 | 2247323 | 2022-02-24 | Polk | Missouri | 29167 | 7984 | 100 |
2244072 | 2244072 | 2022-02-23 | Polk | Missouri | 29167 | 7983 | 96 |
2240821 | 2240821 | 2022-02-22 | Polk | Missouri | 29167 | 7978 | 92 |
2237570 | 2237570 | 2022-02-21 | Polk | Missouri | 29167 | 7946 | 89 |
2234319 | 2234319 | 2022-02-20 | Polk | Missouri | 29167 | 7946 | 89 |
2231068 | 2231068 | 2022-02-19 | Polk | Missouri | 29167 | 7946 | 89 |
2227817 | 2227817 | 2022-02-18 | Polk | Missouri | 29167 | 7946 | 89 |
2224566 | 2224566 | 2022-02-17 | Polk | Missouri | 29167 | 7946 | 89 |
2221315 | 2221315 | 2022-02-16 | Polk | Missouri | 29167 | 7927 | 89 |
2218064 | 2218064 | 2022-02-15 | Polk | Missouri | 29167 | 7911 | 89 |
2214813 | 2214813 | 2022-02-14 | Polk | Missouri | 29167 | 7891 | 86 |
2211561 | 2211561 | 2022-02-13 | Polk | Missouri | 29167 | 7833 | 86 |
2208308 | 2208308 | 2022-02-12 | Polk | Missouri | 29167 | 7833 | 86 |
2205055 | 2205055 | 2022-02-11 | Polk | Missouri | 29167 | 7833 | 86 |
2201802 | 2201802 | 2022-02-10 | Polk | Missouri | 29167 | 7833 | 86 |
2198548 | 2198548 | 2022-02-09 | Polk | Missouri | 29167 | 7782 | 86 |
2195294 | 2195294 | 2022-02-08 | Polk | Missouri | 29167 | 7743 | 86 |
2192040 | 2192040 | 2022-02-07 | Polk | Missouri | 29167 | 7705 | 84 |
2188787 | 2188787 | 2022-02-06 | Polk | Missouri | 29167 | 7696 | 84 |
2185534 | 2185534 | 2022-02-05 | Polk | Missouri | 29167 | 7692 | 84 |
2182282 | 2182282 | 2022-02-04 | Polk | Missouri | 29167 | 7662 | 84 |
2179030 | 2179030 | 2022-02-03 | Polk | Missouri | 29167 | 7636 | 84 |
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);