ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Pearl River" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 184 ✖
- 275 54
- 244 42
- 32 37
- 146 36
- 148 24
- 0 22
- 31 21
- 237 14
- 248 12
- 48 11
- 49 11
- 54 11
- 132 11
- 53 10
- 60 10
- 139 10
- 149 10
- 245 10
- 142 9
- 67 8
- 133 8
- 27 7
- 145 7
- 147 7
- 240 7
- 241 7
- 272 7
- 73 6
- 137 6
- 243 6
- 262 6
- 269 6
- 8 5
- 10 5
- 20 5
- 24 5
- 26 5
- 50 5
- 62 5
- 79 5
- 160 5
- 236 5
- 242 5
- 34 4
- 36 4
- 37 4
- 40 4
- 45 4
- 64 4
- 65 4
- 117 4
- 123 4
- 126 4
- 127 4
- 141 4
- 143 4
- 152 4
- 185 4
- 221 4
- 246 4
- 268 4
- 14 3
- 35 3
- 55 3
- 56 3
- 59 3
- 66 3
- 68 3
- 71 3
- 75 3
- 77 3
- 80 3
- 89 3
- 106 3
- 128 3
- 130 3
- 144 3
- 156 3
- 169 3
- 178 3
- 196 3
- 209 3
- 230 3
- 238 3
- 250 3
- 251 3
- 259 3
- 265 3
- 266 3
- 1 2
- 3 2
- 4 2
- 25 2
- 39 2
- 41 2
- 42 2
- 44 2
- 61 2
- 70 2
- 72 2
- 81 2
- 82 2
- 87 2
- 91 2
- 99 2
- 105 2
- 109 2
- 111 2
- 121 2
- 138 2
- 150 2
- 155 2
- 158 2
- 166 2
- 174 2
- 187 2
- 208 2
- 229 2
- 235 2
- 258 2
- 261 2
- 263 2
- 2 1
- 6 1
- 7 1
- 11 1
- 13 1
- 15 1
- 18 1
- 19 1
- 21 1
- 30 1
- 38 1
- 46 1
- 52 1
- 58 1
- 69 1
- 74 1
- 83 1
- 85 1
- 88 1
- 90 1
- 92 1
- 95 1
- 100 1
- 103 1
- 104 1
- 107 1
- 110 1
- 113 1
- 115 1
- 116 1
- 122 1
- 129 1
- 131 1
- 134 1
- 135 1
- 136 1
- 151 1
- 153 1
- 154 1
- 165 1
- 167 1
- 170 1
- 175 1
- 179 1
- 180 1
- 183 1
- 191 1
- 197 1
- 199 1
- 203 1
- 213 1
- 216 1
- 217 1
- 219 1
- 226 1
- 231 1
- 247 1
- 249 1
- 253 1
- 256 1
- 260 1
- 267 1
state 1
- Mississippi 792
fips 1
- 28109 792
county 1
- Pearl River · 792 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501047 | 2501047 | 2022-05-13 | Pearl River | Mississippi | 28109 | 15151 | 275 |
2497789 | 2497789 | 2022-05-12 | Pearl River | Mississippi | 28109 | 15151 | 275 |
2494531 | 2494531 | 2022-05-11 | Pearl River | Mississippi | 28109 | 15151 | 275 |
2491273 | 2491273 | 2022-05-10 | Pearl River | Mississippi | 28109 | 15151 | 275 |
2488016 | 2488016 | 2022-05-09 | Pearl River | Mississippi | 28109 | 15151 | 275 |
2484758 | 2484758 | 2022-05-08 | Pearl River | Mississippi | 28109 | 15093 | 275 |
2481500 | 2481500 | 2022-05-07 | Pearl River | Mississippi | 28109 | 15093 | 275 |
2478242 | 2478242 | 2022-05-06 | Pearl River | Mississippi | 28109 | 15093 | 275 |
2474984 | 2474984 | 2022-05-05 | Pearl River | Mississippi | 28109 | 15093 | 275 |
2471727 | 2471727 | 2022-05-04 | Pearl River | Mississippi | 28109 | 15093 | 275 |
2468471 | 2468471 | 2022-05-03 | Pearl River | Mississippi | 28109 | 15093 | 275 |
2465216 | 2465216 | 2022-05-02 | Pearl River | Mississippi | 28109 | 15093 | 275 |
2461960 | 2461960 | 2022-05-01 | Pearl River | Mississippi | 28109 | 15079 | 275 |
2458704 | 2458704 | 2022-04-30 | Pearl River | Mississippi | 28109 | 15079 | 275 |
2455448 | 2455448 | 2022-04-29 | Pearl River | Mississippi | 28109 | 15079 | 275 |
2452192 | 2452192 | 2022-04-28 | Pearl River | Mississippi | 28109 | 15079 | 275 |
2448936 | 2448936 | 2022-04-27 | Pearl River | Mississippi | 28109 | 15079 | 275 |
2445680 | 2445680 | 2022-04-26 | Pearl River | Mississippi | 28109 | 15079 | 275 |
2442424 | 2442424 | 2022-04-25 | Pearl River | Mississippi | 28109 | 15065 | 275 |
2439168 | 2439168 | 2022-04-24 | Pearl River | Mississippi | 28109 | 15065 | 275 |
2435912 | 2435912 | 2022-04-23 | Pearl River | Mississippi | 28109 | 15065 | 275 |
2432656 | 2432656 | 2022-04-22 | Pearl River | Mississippi | 28109 | 15065 | 275 |
2429400 | 2429400 | 2022-04-21 | Pearl River | Mississippi | 28109 | 15065 | 275 |
2426144 | 2426144 | 2022-04-20 | Pearl River | Mississippi | 28109 | 15065 | 275 |
2422888 | 2422888 | 2022-04-19 | Pearl River | Mississippi | 28109 | 15065 | 275 |
2419632 | 2419632 | 2022-04-18 | Pearl River | Mississippi | 28109 | 15065 | 275 |
2416376 | 2416376 | 2022-04-17 | Pearl River | Mississippi | 28109 | 15049 | 275 |
2413120 | 2413120 | 2022-04-16 | Pearl River | Mississippi | 28109 | 15049 | 275 |
2409864 | 2409864 | 2022-04-15 | Pearl River | Mississippi | 28109 | 15049 | 275 |
2406608 | 2406608 | 2022-04-14 | Pearl River | Mississippi | 28109 | 15049 | 275 |
2403352 | 2403352 | 2022-04-13 | Pearl River | Mississippi | 28109 | 15049 | 275 |
2400098 | 2400098 | 2022-04-12 | Pearl River | Mississippi | 28109 | 15049 | 275 |
2396842 | 2396842 | 2022-04-11 | Pearl River | Mississippi | 28109 | 15014 | 275 |
2393587 | 2393587 | 2022-04-10 | Pearl River | Mississippi | 28109 | 15014 | 275 |
2390331 | 2390331 | 2022-04-09 | Pearl River | Mississippi | 28109 | 15014 | 275 |
2387075 | 2387075 | 2022-04-08 | Pearl River | Mississippi | 28109 | 15014 | 275 |
2383820 | 2383820 | 2022-04-07 | Pearl River | Mississippi | 28109 | 15014 | 275 |
2380565 | 2380565 | 2022-04-06 | Pearl River | Mississippi | 28109 | 15014 | 275 |
2377310 | 2377310 | 2022-04-05 | Pearl River | Mississippi | 28109 | 15014 | 275 |
2374058 | 2374058 | 2022-04-04 | Pearl River | Mississippi | 28109 | 15014 | 275 |
2370805 | 2370805 | 2022-04-03 | Pearl River | Mississippi | 28109 | 14995 | 275 |
2367552 | 2367552 | 2022-04-02 | Pearl River | Mississippi | 28109 | 14995 | 275 |
2364299 | 2364299 | 2022-04-01 | Pearl River | Mississippi | 28109 | 14995 | 275 |
2361045 | 2361045 | 2022-03-31 | Pearl River | Mississippi | 28109 | 14995 | 275 |
2357791 | 2357791 | 2022-03-30 | Pearl River | Mississippi | 28109 | 14995 | 275 |
2354538 | 2354538 | 2022-03-29 | Pearl River | Mississippi | 28109 | 14995 | 275 |
2351286 | 2351286 | 2022-03-28 | Pearl River | Mississippi | 28109 | 14995 | 275 |
2348033 | 2348033 | 2022-03-27 | Pearl River | Mississippi | 28109 | 14986 | 275 |
2344780 | 2344780 | 2022-03-26 | Pearl River | Mississippi | 28109 | 14986 | 275 |
2341527 | 2341527 | 2022-03-25 | Pearl River | Mississippi | 28109 | 14986 | 275 |
2338274 | 2338274 | 2022-03-24 | Pearl River | Mississippi | 28109 | 14986 | 275 |
2335020 | 2335020 | 2022-03-23 | Pearl River | Mississippi | 28109 | 14986 | 275 |
2331766 | 2331766 | 2022-03-22 | Pearl River | Mississippi | 28109 | 14986 | 275 |
2328514 | 2328514 | 2022-03-21 | Pearl River | Mississippi | 28109 | 14986 | 275 |
2325261 | 2325261 | 2022-03-20 | Pearl River | Mississippi | 28109 | 14982 | 272 |
2322007 | 2322007 | 2022-03-19 | Pearl River | Mississippi | 28109 | 14982 | 272 |
2318753 | 2318753 | 2022-03-18 | Pearl River | Mississippi | 28109 | 14982 | 272 |
2315500 | 2315500 | 2022-03-17 | Pearl River | Mississippi | 28109 | 14982 | 272 |
2312247 | 2312247 | 2022-03-16 | Pearl River | Mississippi | 28109 | 14982 | 272 |
2308994 | 2308994 | 2022-03-15 | Pearl River | Mississippi | 28109 | 14982 | 272 |
2305743 | 2305743 | 2022-03-14 | Pearl River | Mississippi | 28109 | 14982 | 272 |
2302491 | 2302491 | 2022-03-13 | Pearl River | Mississippi | 28109 | 14979 | 269 |
2299239 | 2299239 | 2022-03-12 | Pearl River | Mississippi | 28109 | 14979 | 269 |
2295987 | 2295987 | 2022-03-11 | Pearl River | Mississippi | 28109 | 14979 | 269 |
2292735 | 2292735 | 2022-03-10 | Pearl River | Mississippi | 28109 | 14979 | 269 |
2289483 | 2289483 | 2022-03-09 | Pearl River | Mississippi | 28109 | 14979 | 269 |
2286232 | 2286232 | 2022-03-08 | Pearl River | Mississippi | 28109 | 14979 | 269 |
2282980 | 2282980 | 2022-03-07 | Pearl River | Mississippi | 28109 | 14978 | 268 |
2279727 | 2279727 | 2022-03-06 | Pearl River | Mississippi | 28109 | 14973 | 268 |
2276474 | 2276474 | 2022-03-05 | Pearl River | Mississippi | 28109 | 14973 | 268 |
2273221 | 2273221 | 2022-03-04 | Pearl River | Mississippi | 28109 | 14973 | 268 |
2269969 | 2269969 | 2022-03-03 | Pearl River | Mississippi | 28109 | 14971 | 267 |
2266716 | 2266716 | 2022-03-02 | Pearl River | Mississippi | 28109 | 14967 | 266 |
2263465 | 2263465 | 2022-03-01 | Pearl River | Mississippi | 28109 | 14964 | 266 |
2260214 | 2260214 | 2022-02-28 | Pearl River | Mississippi | 28109 | 14962 | 266 |
2256963 | 2256963 | 2022-02-27 | Pearl River | Mississippi | 28109 | 14954 | 265 |
2253712 | 2253712 | 2022-02-26 | Pearl River | Mississippi | 28109 | 14954 | 265 |
2250461 | 2250461 | 2022-02-25 | Pearl River | Mississippi | 28109 | 14954 | 265 |
2247210 | 2247210 | 2022-02-24 | Pearl River | Mississippi | 28109 | 14949 | 263 |
2243959 | 2243959 | 2022-02-23 | Pearl River | Mississippi | 28109 | 14939 | 263 |
2240708 | 2240708 | 2022-02-22 | Pearl River | Mississippi | 28109 | 14926 | 262 |
2237457 | 2237457 | 2022-02-21 | Pearl River | Mississippi | 28109 | 14900 | 262 |
2234206 | 2234206 | 2022-02-20 | Pearl River | Mississippi | 28109 | 14900 | 262 |
2230955 | 2230955 | 2022-02-19 | Pearl River | Mississippi | 28109 | 14900 | 262 |
2227704 | 2227704 | 2022-02-18 | Pearl River | Mississippi | 28109 | 14900 | 262 |
2224453 | 2224453 | 2022-02-17 | Pearl River | Mississippi | 28109 | 14881 | 262 |
2221202 | 2221202 | 2022-02-16 | Pearl River | Mississippi | 28109 | 14867 | 261 |
2217951 | 2217951 | 2022-02-15 | Pearl River | Mississippi | 28109 | 14848 | 261 |
2214700 | 2214700 | 2022-02-14 | Pearl River | Mississippi | 28109 | 14831 | 260 |
2211448 | 2211448 | 2022-02-13 | Pearl River | Mississippi | 28109 | 14776 | 259 |
2208195 | 2208195 | 2022-02-12 | Pearl River | Mississippi | 28109 | 14776 | 259 |
2204942 | 2204942 | 2022-02-11 | Pearl River | Mississippi | 28109 | 14776 | 259 |
2201689 | 2201689 | 2022-02-10 | Pearl River | Mississippi | 28109 | 14742 | 258 |
2198435 | 2198435 | 2022-02-09 | Pearl River | Mississippi | 28109 | 14706 | 258 |
2195181 | 2195181 | 2022-02-08 | Pearl River | Mississippi | 28109 | 14654 | 256 |
2191927 | 2191927 | 2022-02-07 | Pearl River | Mississippi | 28109 | 14613 | 253 |
2188674 | 2188674 | 2022-02-06 | Pearl River | Mississippi | 28109 | 14228 | 251 |
2185421 | 2185421 | 2022-02-05 | Pearl River | Mississippi | 28109 | 14228 | 251 |
2182169 | 2182169 | 2022-02-04 | Pearl River | Mississippi | 28109 | 14228 | 251 |
2178917 | 2178917 | 2022-02-03 | Pearl River | Mississippi | 28109 | 14140 | 250 |
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);