ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where fips = 29161 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 126 ✖
- 0 152
- 240 37
- 130 27
- 131 24
- 1 17
- 121 17
- 127 17
- 184 15
- 128 14
- 171 14
- 107 13
- 129 11
- 178 11
- 192 11
- 237 11
- 12 9
- 243 9
- 19 7
- 117 7
- 123 7
- 124 7
- 139 7
- 159 7
- 197 7
- 224 7
- 225 7
- 8 6
- 38 6
- 82 6
- 93 6
- 103 6
- 115 6
- 126 6
- 135 6
- 137 6
- 165 6
- 185 6
- 195 6
- 198 6
- 213 6
- 231 6
- 15 5
- 30 5
- 42 5
- 76 5
- 163 5
- 193 5
- 201 5
- 229 5
- 235 5
- 27 4
- 34 4
- 86 4
- 134 4
- 140 4
- 155 4
- 176 4
- 182 4
- 205 4
- 209 4
- 212 4
- 216 4
- 21 3
- 33 3
- 50 3
- 54 3
- 85 3
- 89 3
- 114 3
- 141 3
- 145 3
- 172 3
- 177 3
- 196 3
- 199 3
- 207 3
- 24 2
- 31 2
- 40 2
- 51 2
- 60 2
- 119 2
- 132 2
- 143 2
- 144 2
- 154 2
- 164 2
- 169 2
- 173 2
- 180 2
- 186 2
- 204 2
- 211 2
- 214 2
- 222 2
- 234 2
- 236 2
- 5 1
- 7 1
- 18 1
- 20 1
- 22 1
- 29 1
- 37 1
- 48 1
- 49 1
- 53 1
- 59 1
- 64 1
- 74 1
- 79 1
- 125 1
- 136 1
- 152 1
- 158 1
- 162 1
- 170 1
- 174 1
- 179 1
- 194 1
- 202 1
- 208 1
- 226 1
- 228 1
- 230 1
- 239 1
state 1
- Missouri · 768 ✖
fips 1
- 29161 · 768 ✖
county 1
- Phelps 768
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501158 | 2501158 | 2022-05-13 | Phelps | Missouri | 29161 | 10317 | 243 |
2497900 | 2497900 | 2022-05-12 | Phelps | Missouri | 29161 | 10268 | 243 |
2494642 | 2494642 | 2022-05-11 | Phelps | Missouri | 29161 | 10268 | 243 |
2491384 | 2491384 | 2022-05-10 | Phelps | Missouri | 29161 | 10268 | 243 |
2488126 | 2488126 | 2022-05-09 | Phelps | Missouri | 29161 | 10268 | 243 |
2484869 | 2484869 | 2022-05-08 | Phelps | Missouri | 29161 | 10268 | 243 |
2481611 | 2481611 | 2022-05-07 | Phelps | Missouri | 29161 | 10268 | 243 |
2478353 | 2478353 | 2022-05-06 | Phelps | Missouri | 29161 | 10268 | 243 |
2475095 | 2475095 | 2022-05-05 | Phelps | Missouri | 29161 | 10244 | 243 |
2471838 | 2471838 | 2022-05-04 | Phelps | Missouri | 29161 | 10185 | 240 |
2468582 | 2468582 | 2022-05-03 | Phelps | Missouri | 29161 | 10185 | 240 |
2465326 | 2465326 | 2022-05-02 | Phelps | Missouri | 29161 | 10185 | 240 |
2462071 | 2462071 | 2022-05-01 | Phelps | Missouri | 29161 | 10185 | 240 |
2458815 | 2458815 | 2022-04-30 | Phelps | Missouri | 29161 | 10185 | 240 |
2455559 | 2455559 | 2022-04-29 | Phelps | Missouri | 29161 | 10185 | 240 |
2452303 | 2452303 | 2022-04-28 | Phelps | Missouri | 29161 | 10185 | 240 |
2449047 | 2449047 | 2022-04-27 | Phelps | Missouri | 29161 | 10185 | 240 |
2445790 | 2445790 | 2022-04-26 | Phelps | Missouri | 29161 | 10185 | 240 |
2442535 | 2442535 | 2022-04-25 | Phelps | Missouri | 29161 | 10185 | 240 |
2439279 | 2439279 | 2022-04-24 | Phelps | Missouri | 29161 | 10185 | 240 |
2436023 | 2436023 | 2022-04-23 | Phelps | Missouri | 29161 | 10185 | 240 |
2432767 | 2432767 | 2022-04-22 | Phelps | Missouri | 29161 | 10185 | 240 |
2429511 | 2429511 | 2022-04-21 | Phelps | Missouri | 29161 | 10185 | 240 |
2426255 | 2426255 | 2022-04-20 | Phelps | Missouri | 29161 | 10185 | 240 |
2422999 | 2422999 | 2022-04-19 | Phelps | Missouri | 29161 | 10185 | 240 |
2419742 | 2419742 | 2022-04-18 | Phelps | Missouri | 29161 | 10185 | 240 |
2416487 | 2416487 | 2022-04-17 | Phelps | Missouri | 29161 | 10185 | 240 |
2413231 | 2413231 | 2022-04-16 | Phelps | Missouri | 29161 | 10185 | 240 |
2409975 | 2409975 | 2022-04-15 | Phelps | Missouri | 29161 | 10185 | 240 |
2406719 | 2406719 | 2022-04-14 | Phelps | Missouri | 29161 | 10185 | 240 |
2403463 | 2403463 | 2022-04-13 | Phelps | Missouri | 29161 | 10185 | 240 |
2400208 | 2400208 | 2022-04-12 | Phelps | Missouri | 29161 | 10185 | 240 |
2396953 | 2396953 | 2022-04-11 | Phelps | Missouri | 29161 | 10185 | 240 |
2393698 | 2393698 | 2022-04-10 | Phelps | Missouri | 29161 | 10185 | 240 |
2390442 | 2390442 | 2022-04-09 | Phelps | Missouri | 29161 | 10185 | 240 |
2387186 | 2387186 | 2022-04-08 | Phelps | Missouri | 29161 | 10185 | 240 |
2383931 | 2383931 | 2022-04-07 | Phelps | Missouri | 29161 | 10185 | 240 |
2380676 | 2380676 | 2022-04-06 | Phelps | Missouri | 29161 | 10185 | 240 |
2377421 | 2377421 | 2022-04-05 | Phelps | Missouri | 29161 | 10185 | 240 |
2374168 | 2374168 | 2022-04-04 | Phelps | Missouri | 29161 | 10185 | 240 |
2370916 | 2370916 | 2022-04-03 | Phelps | Missouri | 29161 | 10185 | 240 |
2367663 | 2367663 | 2022-04-02 | Phelps | Missouri | 29161 | 10185 | 240 |
2364410 | 2364410 | 2022-04-01 | Phelps | Missouri | 29161 | 10185 | 240 |
2361156 | 2361156 | 2022-03-31 | Phelps | Missouri | 29161 | 10185 | 240 |
2357902 | 2357902 | 2022-03-30 | Phelps | Missouri | 29161 | 10180 | 240 |
2354649 | 2354649 | 2022-03-29 | Phelps | Missouri | 29161 | 10178 | 240 |
2351396 | 2351396 | 2022-03-28 | Phelps | Missouri | 29161 | 10173 | 239 |
2348144 | 2348144 | 2022-03-27 | Phelps | Missouri | 29161 | 10158 | 237 |
2344891 | 2344891 | 2022-03-26 | Phelps | Missouri | 29161 | 10158 | 237 |
2341638 | 2341638 | 2022-03-25 | Phelps | Missouri | 29161 | 10158 | 237 |
2338385 | 2338385 | 2022-03-24 | Phelps | Missouri | 29161 | 10153 | 237 |
2335131 | 2335131 | 2022-03-23 | Phelps | Missouri | 29161 | 10137 | 237 |
2331877 | 2331877 | 2022-03-22 | Phelps | Missouri | 29161 | 10131 | 236 |
2328624 | 2328624 | 2022-03-21 | Phelps | Missouri | 29161 | 10127 | 237 |
2325372 | 2325372 | 2022-03-20 | Phelps | Missouri | 29161 | 10115 | 237 |
2322118 | 2322118 | 2022-03-19 | Phelps | Missouri | 29161 | 10115 | 237 |
2318864 | 2318864 | 2022-03-18 | Phelps | Missouri | 29161 | 10115 | 237 |
2315611 | 2315611 | 2022-03-17 | Phelps | Missouri | 29161 | 10110 | 237 |
2312358 | 2312358 | 2022-03-16 | Phelps | Missouri | 29161 | 10104 | 237 |
2309105 | 2309105 | 2022-03-15 | Phelps | Missouri | 29161 | 10082 | 236 |
2305853 | 2305853 | 2022-03-14 | Phelps | Missouri | 29161 | 10070 | 235 |
2302602 | 2302602 | 2022-03-13 | Phelps | Missouri | 29161 | 10060 | 235 |
2299350 | 2299350 | 2022-03-12 | Phelps | Missouri | 29161 | 10060 | 235 |
2296098 | 2296098 | 2022-03-11 | Phelps | Missouri | 29161 | 10060 | 235 |
2292846 | 2292846 | 2022-03-10 | Phelps | Missouri | 29161 | 10050 | 235 |
2289594 | 2289594 | 2022-03-09 | Phelps | Missouri | 29161 | 10026 | 234 |
2286342 | 2286342 | 2022-03-08 | Phelps | Missouri | 29161 | 10021 | 234 |
2283090 | 2283090 | 2022-03-07 | Phelps | Missouri | 29161 | 10015 | 231 |
2279837 | 2279837 | 2022-03-06 | Phelps | Missouri | 29161 | 9987 | 231 |
2276584 | 2276584 | 2022-03-05 | Phelps | Missouri | 29161 | 9987 | 231 |
2273331 | 2273331 | 2022-03-04 | Phelps | Missouri | 29161 | 9987 | 231 |
2270079 | 2270079 | 2022-03-03 | Phelps | Missouri | 29161 | 9977 | 231 |
2266826 | 2266826 | 2022-03-02 | Phelps | Missouri | 29161 | 9964 | 231 |
2263575 | 2263575 | 2022-03-01 | Phelps | Missouri | 29161 | 9962 | 230 |
2260324 | 2260324 | 2022-02-28 | Phelps | Missouri | 29161 | 9951 | 229 |
2257073 | 2257073 | 2022-02-27 | Phelps | Missouri | 29161 | 9938 | 229 |
2253822 | 2253822 | 2022-02-26 | Phelps | Missouri | 29161 | 9938 | 229 |
2250571 | 2250571 | 2022-02-25 | Phelps | Missouri | 29161 | 9938 | 229 |
2247320 | 2247320 | 2022-02-24 | Phelps | Missouri | 29161 | 9929 | 229 |
2244069 | 2244069 | 2022-02-23 | Phelps | Missouri | 29161 | 9918 | 228 |
2240818 | 2240818 | 2022-02-22 | Phelps | Missouri | 29161 | 9889 | 226 |
2237567 | 2237567 | 2022-02-21 | Phelps | Missouri | 29161 | 9857 | 225 |
2234316 | 2234316 | 2022-02-20 | Phelps | Missouri | 29161 | 9857 | 225 |
2231065 | 2231065 | 2022-02-19 | Phelps | Missouri | 29161 | 9857 | 225 |
2227814 | 2227814 | 2022-02-18 | Phelps | Missouri | 29161 | 9857 | 225 |
2224563 | 2224563 | 2022-02-17 | Phelps | Missouri | 29161 | 9854 | 225 |
2221312 | 2221312 | 2022-02-16 | Phelps | Missouri | 29161 | 9830 | 225 |
2218061 | 2218061 | 2022-02-15 | Phelps | Missouri | 29161 | 9810 | 225 |
2214810 | 2214810 | 2022-02-14 | Phelps | Missouri | 29161 | 9785 | 224 |
2211558 | 2211558 | 2022-02-13 | Phelps | Missouri | 29161 | 9741 | 224 |
2208305 | 2208305 | 2022-02-12 | Phelps | Missouri | 29161 | 9741 | 224 |
2205052 | 2205052 | 2022-02-11 | Phelps | Missouri | 29161 | 9741 | 224 |
2201799 | 2201799 | 2022-02-10 | Phelps | Missouri | 29161 | 9741 | 224 |
2198545 | 2198545 | 2022-02-09 | Phelps | Missouri | 29161 | 9706 | 224 |
2195291 | 2195291 | 2022-02-08 | Phelps | Missouri | 29161 | 9686 | 224 |
2192037 | 2192037 | 2022-02-07 | Phelps | Missouri | 29161 | 9659 | 222 |
2188784 | 2188784 | 2022-02-06 | Phelps | Missouri | 29161 | 9647 | 222 |
2185531 | 2185531 | 2022-02-05 | Phelps | Missouri | 29161 | 9621 | 216 |
2182279 | 2182279 | 2022-02-04 | Phelps | Missouri | 29161 | 9596 | 216 |
2179027 | 2179027 | 2022-02-03 | Phelps | Missouri | 29161 | 9584 | 216 |
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);