ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 28067 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 186 ✖
- 0 38
- 169 29
- 163 26
- 248 26
- 167 24
- 250 22
- 289 21
- 84 20
- 81 16
- 243 16
- 49 15
- 291 14
- 287 13
- 161 12
- 295 12
- 165 10
- 247 10
- 160 9
- 88 8
- 251 8
- 290 8
- 57 7
- 87 7
- 90 7
- 241 7
- 246 7
- 76 6
- 78 6
- 79 6
- 91 6
- 142 6
- 154 6
- 174 6
- 293 6
- 1 5
- 2 5
- 44 5
- 48 5
- 53 5
- 69 5
- 75 5
- 98 5
- 159 5
- 164 5
- 171 5
- 227 5
- 242 5
- 244 5
- 282 5
- 36 4
- 56 4
- 58 4
- 72 4
- 82 4
- 85 4
- 86 4
- 120 4
- 139 4
- 146 4
- 148 4
- 152 4
- 153 4
- 156 4
- 168 4
- 180 4
- 194 4
- 218 4
- 238 4
- 4 3
- 5 3
- 12 3
- 52 3
- 62 3
- 95 3
- 96 3
- 97 3
- 108 3
- 112 3
- 132 3
- 147 3
- 188 3
- 209 3
- 232 3
- 259 3
- 266 3
- 275 3
- 285 3
- 6 2
- 7 2
- 9 2
- 13 2
- 25 2
- 28 2
- 33 2
- 34 2
- 38 2
- 47 2
- 54 2
- 59 2
- 65 2
- 66 2
- 74 2
- 77 2
- 80 2
- 89 2
- 92 2
- 93 2
- 94 2
- 100 2
- 110 2
- 114 2
- 118 2
- 123 2
- 124 2
- 136 2
- 145 2
- 149 2
- 179 2
- 191 2
- 207 2
- 215 2
- 230 2
- 236 2
- 277 2
- 280 2
- 284 2
- 8 1
- 10 1
- 15 1
- 18 1
- 19 1
- 22 1
- 31 1
- 32 1
- 37 1
- 39 1
- 43 1
- 50 1
- 51 1
- 64 1
- 67 1
- 68 1
- 71 1
- 73 1
- 101 1
- 102 1
- 103 1
- 106 1
- 109 1
- 122 1
- 125 1
- 127 1
- 138 1
- 140 1
- 144 1
- 150 1
- 157 1
- 158 1
- 166 1
- 173 1
- 176 1
- 178 1
- 184 1
- 185 1
- 187 1
- 193 1
- 203 1
- 205 1
- 213 1
- 221 1
- 222 1
- 223 1
- 226 1
- 233 1
- 235 1
- 240 1
- 256 1
- 261 1
- 262 1
- 264 1
- 265 1
- 267 1
- 270 1
- 272 1
- 274 1
- 286 1
state 1
- Mississippi 786
fips 1
- 28067 · 786 ✖
county 1
- Jones 786
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501026 | 2501026 | 2022-05-13 | Jones | Mississippi | 28067 | 21234 | 295 |
2497768 | 2497768 | 2022-05-12 | Jones | Mississippi | 28067 | 21234 | 295 |
2494510 | 2494510 | 2022-05-11 | Jones | Mississippi | 28067 | 21234 | 295 |
2491252 | 2491252 | 2022-05-10 | Jones | Mississippi | 28067 | 21234 | 295 |
2487995 | 2487995 | 2022-05-09 | Jones | Mississippi | 28067 | 21234 | 295 |
2484737 | 2484737 | 2022-05-08 | Jones | Mississippi | 28067 | 21214 | 295 |
2481479 | 2481479 | 2022-05-07 | Jones | Mississippi | 28067 | 21214 | 295 |
2478221 | 2478221 | 2022-05-06 | Jones | Mississippi | 28067 | 21214 | 295 |
2474963 | 2474963 | 2022-05-05 | Jones | Mississippi | 28067 | 21214 | 295 |
2471706 | 2471706 | 2022-05-04 | Jones | Mississippi | 28067 | 21214 | 295 |
2468450 | 2468450 | 2022-05-03 | Jones | Mississippi | 28067 | 21214 | 295 |
2465195 | 2465195 | 2022-05-02 | Jones | Mississippi | 28067 | 21214 | 295 |
2461939 | 2461939 | 2022-05-01 | Jones | Mississippi | 28067 | 21206 | 293 |
2458683 | 2458683 | 2022-04-30 | Jones | Mississippi | 28067 | 21206 | 293 |
2455427 | 2455427 | 2022-04-29 | Jones | Mississippi | 28067 | 21206 | 293 |
2452171 | 2452171 | 2022-04-28 | Jones | Mississippi | 28067 | 21206 | 293 |
2448915 | 2448915 | 2022-04-27 | Jones | Mississippi | 28067 | 21206 | 293 |
2445659 | 2445659 | 2022-04-26 | Jones | Mississippi | 28067 | 21206 | 293 |
2442403 | 2442403 | 2022-04-25 | Jones | Mississippi | 28067 | 21190 | 291 |
2439147 | 2439147 | 2022-04-24 | Jones | Mississippi | 28067 | 21190 | 291 |
2435891 | 2435891 | 2022-04-23 | Jones | Mississippi | 28067 | 21190 | 291 |
2432635 | 2432635 | 2022-04-22 | Jones | Mississippi | 28067 | 21190 | 291 |
2429379 | 2429379 | 2022-04-21 | Jones | Mississippi | 28067 | 21190 | 291 |
2426123 | 2426123 | 2022-04-20 | Jones | Mississippi | 28067 | 21190 | 291 |
2422867 | 2422867 | 2022-04-19 | Jones | Mississippi | 28067 | 21190 | 291 |
2419611 | 2419611 | 2022-04-18 | Jones | Mississippi | 28067 | 21190 | 291 |
2416355 | 2416355 | 2022-04-17 | Jones | Mississippi | 28067 | 21178 | 291 |
2413099 | 2413099 | 2022-04-16 | Jones | Mississippi | 28067 | 21178 | 291 |
2409843 | 2409843 | 2022-04-15 | Jones | Mississippi | 28067 | 21178 | 291 |
2406587 | 2406587 | 2022-04-14 | Jones | Mississippi | 28067 | 21178 | 291 |
2403331 | 2403331 | 2022-04-13 | Jones | Mississippi | 28067 | 21178 | 291 |
2400077 | 2400077 | 2022-04-12 | Jones | Mississippi | 28067 | 21178 | 291 |
2396821 | 2396821 | 2022-04-11 | Jones | Mississippi | 28067 | 21167 | 290 |
2393566 | 2393566 | 2022-04-10 | Jones | Mississippi | 28067 | 21167 | 290 |
2390310 | 2390310 | 2022-04-09 | Jones | Mississippi | 28067 | 21167 | 290 |
2387054 | 2387054 | 2022-04-08 | Jones | Mississippi | 28067 | 21167 | 290 |
2383799 | 2383799 | 2022-04-07 | Jones | Mississippi | 28067 | 21167 | 290 |
2380544 | 2380544 | 2022-04-06 | Jones | Mississippi | 28067 | 21167 | 290 |
2377289 | 2377289 | 2022-04-05 | Jones | Mississippi | 28067 | 21167 | 290 |
2374037 | 2374037 | 2022-04-04 | Jones | Mississippi | 28067 | 21167 | 290 |
2370784 | 2370784 | 2022-04-03 | Jones | Mississippi | 28067 | 21154 | 289 |
2367531 | 2367531 | 2022-04-02 | Jones | Mississippi | 28067 | 21154 | 289 |
2364278 | 2364278 | 2022-04-01 | Jones | Mississippi | 28067 | 21154 | 289 |
2361024 | 2361024 | 2022-03-31 | Jones | Mississippi | 28067 | 21154 | 289 |
2357770 | 2357770 | 2022-03-30 | Jones | Mississippi | 28067 | 21154 | 289 |
2354517 | 2354517 | 2022-03-29 | Jones | Mississippi | 28067 | 21154 | 289 |
2351265 | 2351265 | 2022-03-28 | Jones | Mississippi | 28067 | 21154 | 289 |
2348012 | 2348012 | 2022-03-27 | Jones | Mississippi | 28067 | 21146 | 289 |
2344759 | 2344759 | 2022-03-26 | Jones | Mississippi | 28067 | 21146 | 289 |
2341506 | 2341506 | 2022-03-25 | Jones | Mississippi | 28067 | 21146 | 289 |
2338253 | 2338253 | 2022-03-24 | Jones | Mississippi | 28067 | 21146 | 289 |
2334999 | 2334999 | 2022-03-23 | Jones | Mississippi | 28067 | 21146 | 289 |
2331745 | 2331745 | 2022-03-22 | Jones | Mississippi | 28067 | 21146 | 289 |
2328493 | 2328493 | 2022-03-21 | Jones | Mississippi | 28067 | 21146 | 289 |
2325240 | 2325240 | 2022-03-20 | Jones | Mississippi | 28067 | 21124 | 289 |
2321986 | 2321986 | 2022-03-19 | Jones | Mississippi | 28067 | 21124 | 289 |
2318732 | 2318732 | 2022-03-18 | Jones | Mississippi | 28067 | 21124 | 289 |
2315479 | 2315479 | 2022-03-17 | Jones | Mississippi | 28067 | 21124 | 289 |
2312226 | 2312226 | 2022-03-16 | Jones | Mississippi | 28067 | 21124 | 289 |
2308973 | 2308973 | 2022-03-15 | Jones | Mississippi | 28067 | 21124 | 289 |
2305722 | 2305722 | 2022-03-14 | Jones | Mississippi | 28067 | 21124 | 289 |
2302470 | 2302470 | 2022-03-13 | Jones | Mississippi | 28067 | 21107 | 287 |
2299218 | 2299218 | 2022-03-12 | Jones | Mississippi | 28067 | 21107 | 287 |
2295966 | 2295966 | 2022-03-11 | Jones | Mississippi | 28067 | 21107 | 287 |
2292714 | 2292714 | 2022-03-10 | Jones | Mississippi | 28067 | 21107 | 287 |
2289462 | 2289462 | 2022-03-09 | Jones | Mississippi | 28067 | 21107 | 287 |
2286211 | 2286211 | 2022-03-08 | Jones | Mississippi | 28067 | 21107 | 287 |
2282959 | 2282959 | 2022-03-07 | Jones | Mississippi | 28067 | 21106 | 287 |
2279706 | 2279706 | 2022-03-06 | Jones | Mississippi | 28067 | 21101 | 287 |
2276453 | 2276453 | 2022-03-05 | Jones | Mississippi | 28067 | 21101 | 287 |
2273200 | 2273200 | 2022-03-04 | Jones | Mississippi | 28067 | 21101 | 287 |
2269948 | 2269948 | 2022-03-03 | Jones | Mississippi | 28067 | 21097 | 287 |
2266695 | 2266695 | 2022-03-02 | Jones | Mississippi | 28067 | 21095 | 287 |
2263444 | 2263444 | 2022-03-01 | Jones | Mississippi | 28067 | 21094 | 287 |
2260193 | 2260193 | 2022-02-28 | Jones | Mississippi | 28067 | 21094 | 286 |
2256942 | 2256942 | 2022-02-27 | Jones | Mississippi | 28067 | 21082 | 285 |
2253691 | 2253691 | 2022-02-26 | Jones | Mississippi | 28067 | 21082 | 285 |
2250440 | 2250440 | 2022-02-25 | Jones | Mississippi | 28067 | 21082 | 285 |
2247189 | 2247189 | 2022-02-24 | Jones | Mississippi | 28067 | 21072 | 284 |
2243938 | 2243938 | 2022-02-23 | Jones | Mississippi | 28067 | 21063 | 284 |
2240687 | 2240687 | 2022-02-22 | Jones | Mississippi | 28067 | 21051 | 282 |
2237436 | 2237436 | 2022-02-21 | Jones | Mississippi | 28067 | 20993 | 282 |
2234185 | 2234185 | 2022-02-20 | Jones | Mississippi | 28067 | 20993 | 282 |
2230934 | 2230934 | 2022-02-19 | Jones | Mississippi | 28067 | 20993 | 282 |
2227683 | 2227683 | 2022-02-18 | Jones | Mississippi | 28067 | 20993 | 282 |
2224432 | 2224432 | 2022-02-17 | Jones | Mississippi | 28067 | 20970 | 280 |
2221181 | 2221181 | 2022-02-16 | Jones | Mississippi | 28067 | 20942 | 280 |
2217930 | 2217930 | 2022-02-15 | Jones | Mississippi | 28067 | 20917 | 277 |
2214679 | 2214679 | 2022-02-14 | Jones | Mississippi | 28067 | 20913 | 277 |
2211427 | 2211427 | 2022-02-13 | Jones | Mississippi | 28067 | 20827 | 275 |
2208174 | 2208174 | 2022-02-12 | Jones | Mississippi | 28067 | 20827 | 275 |
2204921 | 2204921 | 2022-02-11 | Jones | Mississippi | 28067 | 20827 | 275 |
2201668 | 2201668 | 2022-02-10 | Jones | Mississippi | 28067 | 20747 | 274 |
2198414 | 2198414 | 2022-02-09 | Jones | Mississippi | 28067 | 20688 | 272 |
2195160 | 2195160 | 2022-02-08 | Jones | Mississippi | 28067 | 20631 | 270 |
2191906 | 2191906 | 2022-02-07 | Jones | Mississippi | 28067 | 20604 | 267 |
2188653 | 2188653 | 2022-02-06 | Jones | Mississippi | 28067 | 20278 | 266 |
2185400 | 2185400 | 2022-02-05 | Jones | Mississippi | 28067 | 20278 | 266 |
2182148 | 2182148 | 2022-02-04 | Jones | Mississippi | 28067 | 20278 | 266 |
2178896 | 2178896 | 2022-02-03 | Jones | Mississippi | 28067 | 20101 | 265 |
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);