ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
765 rows where county = "Jones" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501537 | 2501537 | 2022-05-13 | Jones | North Carolina | 37103 | 2235 | 39 |
2498279 | 2498279 | 2022-05-12 | Jones | North Carolina | 37103 | 2235 | 39 |
2495021 | 2495021 | 2022-05-11 | Jones | North Carolina | 37103 | 2235 | 39 |
2491763 | 2491763 | 2022-05-10 | Jones | North Carolina | 37103 | 2225 | 39 |
2488505 | 2488505 | 2022-05-09 | Jones | North Carolina | 37103 | 2225 | 39 |
2485248 | 2485248 | 2022-05-08 | Jones | North Carolina | 37103 | 2225 | 39 |
2481990 | 2481990 | 2022-05-07 | Jones | North Carolina | 37103 | 2225 | 39 |
2478732 | 2478732 | 2022-05-06 | Jones | North Carolina | 37103 | 2225 | 39 |
2475474 | 2475474 | 2022-05-05 | Jones | North Carolina | 37103 | 2225 | 39 |
2472217 | 2472217 | 2022-05-04 | Jones | North Carolina | 37103 | 2225 | 39 |
2468961 | 2468961 | 2022-05-03 | Jones | North Carolina | 37103 | 2219 | 38 |
2465705 | 2465705 | 2022-05-02 | Jones | North Carolina | 37103 | 2219 | 38 |
2462450 | 2462450 | 2022-05-01 | Jones | North Carolina | 37103 | 2219 | 38 |
2459194 | 2459194 | 2022-04-30 | Jones | North Carolina | 37103 | 2219 | 38 |
2455938 | 2455938 | 2022-04-29 | Jones | North Carolina | 37103 | 2219 | 38 |
2452682 | 2452682 | 2022-04-28 | Jones | North Carolina | 37103 | 2219 | 38 |
2449426 | 2449426 | 2022-04-27 | Jones | North Carolina | 37103 | 2219 | 38 |
2446169 | 2446169 | 2022-04-26 | Jones | North Carolina | 37103 | 2216 | 38 |
2442914 | 2442914 | 2022-04-25 | Jones | North Carolina | 37103 | 2216 | 38 |
2439658 | 2439658 | 2022-04-24 | Jones | North Carolina | 37103 | 2216 | 38 |
2436402 | 2436402 | 2022-04-23 | Jones | North Carolina | 37103 | 2216 | 38 |
2433146 | 2433146 | 2022-04-22 | Jones | North Carolina | 37103 | 2216 | 38 |
2429890 | 2429890 | 2022-04-21 | Jones | North Carolina | 37103 | 2216 | 38 |
2426634 | 2426634 | 2022-04-20 | Jones | North Carolina | 37103 | 2216 | 38 |
2423378 | 2423378 | 2022-04-19 | Jones | North Carolina | 37103 | 2212 | 38 |
2420121 | 2420121 | 2022-04-18 | Jones | North Carolina | 37103 | 2212 | 38 |
2416866 | 2416866 | 2022-04-17 | Jones | North Carolina | 37103 | 2212 | 38 |
2413610 | 2413610 | 2022-04-16 | Jones | North Carolina | 37103 | 2212 | 38 |
2410354 | 2410354 | 2022-04-15 | Jones | North Carolina | 37103 | 2212 | 38 |
2407098 | 2407098 | 2022-04-14 | Jones | North Carolina | 37103 | 2212 | 38 |
2403842 | 2403842 | 2022-04-13 | Jones | North Carolina | 37103 | 2212 | 38 |
2400587 | 2400587 | 2022-04-12 | Jones | North Carolina | 37103 | 2210 | 38 |
2397332 | 2397332 | 2022-04-11 | Jones | North Carolina | 37103 | 2210 | 38 |
2394077 | 2394077 | 2022-04-10 | Jones | North Carolina | 37103 | 2210 | 38 |
2390821 | 2390821 | 2022-04-09 | Jones | North Carolina | 37103 | 2210 | 38 |
2387565 | 2387565 | 2022-04-08 | Jones | North Carolina | 37103 | 2210 | 38 |
2384310 | 2384310 | 2022-04-07 | Jones | North Carolina | 37103 | 2210 | 38 |
2381055 | 2381055 | 2022-04-06 | Jones | North Carolina | 37103 | 2210 | 38 |
2377800 | 2377800 | 2022-04-05 | Jones | North Carolina | 37103 | 2208 | 38 |
2374547 | 2374547 | 2022-04-04 | Jones | North Carolina | 37103 | 2208 | 38 |
2371295 | 2371295 | 2022-04-03 | Jones | North Carolina | 37103 | 2208 | 38 |
2368042 | 2368042 | 2022-04-02 | Jones | North Carolina | 37103 | 2208 | 38 |
2364789 | 2364789 | 2022-04-01 | Jones | North Carolina | 37103 | 2208 | 38 |
2361535 | 2361535 | 2022-03-31 | Jones | North Carolina | 37103 | 2208 | 38 |
2358281 | 2358281 | 2022-03-30 | Jones | North Carolina | 37103 | 2208 | 38 |
2355027 | 2355027 | 2022-03-29 | Jones | North Carolina | 37103 | 2209 | 38 |
2351774 | 2351774 | 2022-03-28 | Jones | North Carolina | 37103 | 2209 | 38 |
2348522 | 2348522 | 2022-03-27 | Jones | North Carolina | 37103 | 2207 | 38 |
2345269 | 2345269 | 2022-03-26 | Jones | North Carolina | 37103 | 2207 | 38 |
2342016 | 2342016 | 2022-03-25 | Jones | North Carolina | 37103 | 2207 | 38 |
2338763 | 2338763 | 2022-03-24 | Jones | North Carolina | 37103 | 2206 | 38 |
2335509 | 2335509 | 2022-03-23 | Jones | North Carolina | 37103 | 2206 | 38 |
2332255 | 2332255 | 2022-03-22 | Jones | North Carolina | 37103 | 2206 | 38 |
2329002 | 2329002 | 2022-03-21 | Jones | North Carolina | 37103 | 2206 | 38 |
2325750 | 2325750 | 2022-03-20 | Jones | North Carolina | 37103 | 2205 | 38 |
2322497 | 2322497 | 2022-03-19 | Jones | North Carolina | 37103 | 2205 | 38 |
2319243 | 2319243 | 2022-03-18 | Jones | North Carolina | 37103 | 2205 | 38 |
2315989 | 2315989 | 2022-03-17 | Jones | North Carolina | 37103 | 2202 | 38 |
2312736 | 2312736 | 2022-03-16 | Jones | North Carolina | 37103 | 2202 | 38 |
2309483 | 2309483 | 2022-03-15 | Jones | North Carolina | 37103 | 2200 | 38 |
2306230 | 2306230 | 2022-03-14 | Jones | North Carolina | 37103 | 2200 | 38 |
2302979 | 2302979 | 2022-03-13 | Jones | North Carolina | 37103 | 2199 | 38 |
2299727 | 2299727 | 2022-03-12 | Jones | North Carolina | 37103 | 2199 | 38 |
2296475 | 2296475 | 2022-03-11 | Jones | North Carolina | 37103 | 2199 | 38 |
2293223 | 2293223 | 2022-03-10 | Jones | North Carolina | 37103 | 2198 | 38 |
2289971 | 2289971 | 2022-03-09 | Jones | North Carolina | 37103 | 2197 | 38 |
2286719 | 2286719 | 2022-03-08 | Jones | North Carolina | 37103 | 2196 | 38 |
2283467 | 2283467 | 2022-03-07 | Jones | North Carolina | 37103 | 2195 | 38 |
2280215 | 2280215 | 2022-03-06 | Jones | North Carolina | 37103 | 2191 | 38 |
2276962 | 2276962 | 2022-03-05 | Jones | North Carolina | 37103 | 2191 | 38 |
2273709 | 2273709 | 2022-03-04 | Jones | North Carolina | 37103 | 2191 | 38 |
2270456 | 2270456 | 2022-03-03 | Jones | North Carolina | 37103 | 2191 | 38 |
2267204 | 2267204 | 2022-03-02 | Jones | North Carolina | 37103 | 2190 | 38 |
2263952 | 2263952 | 2022-03-01 | Jones | North Carolina | 37103 | 2190 | 38 |
2260701 | 2260701 | 2022-02-28 | Jones | North Carolina | 37103 | 2191 | 38 |
2257450 | 2257450 | 2022-02-27 | Jones | North Carolina | 37103 | 2186 | 38 |
2254199 | 2254199 | 2022-02-26 | Jones | North Carolina | 37103 | 2186 | 38 |
2250948 | 2250948 | 2022-02-25 | Jones | North Carolina | 37103 | 2186 | 38 |
2247697 | 2247697 | 2022-02-24 | Jones | North Carolina | 37103 | 2184 | 38 |
2244446 | 2244446 | 2022-02-23 | Jones | North Carolina | 37103 | 2175 | 38 |
2241195 | 2241195 | 2022-02-22 | Jones | North Carolina | 37103 | 2166 | 38 |
2237944 | 2237944 | 2022-02-21 | Jones | North Carolina | 37103 | 2168 | 38 |
2234693 | 2234693 | 2022-02-20 | Jones | North Carolina | 37103 | 2159 | 38 |
2231442 | 2231442 | 2022-02-19 | Jones | North Carolina | 37103 | 2159 | 38 |
2228191 | 2228191 | 2022-02-18 | Jones | North Carolina | 37103 | 2159 | 38 |
2224940 | 2224940 | 2022-02-17 | Jones | North Carolina | 37103 | 2159 | 38 |
2221689 | 2221689 | 2022-02-16 | Jones | North Carolina | 37103 | 2156 | 38 |
2218438 | 2218438 | 2022-02-15 | Jones | North Carolina | 37103 | 2145 | 38 |
2215187 | 2215187 | 2022-02-14 | Jones | North Carolina | 37103 | 2148 | 38 |
2211936 | 2211936 | 2022-02-13 | Jones | North Carolina | 37103 | 2133 | 38 |
2208683 | 2208683 | 2022-02-12 | Jones | North Carolina | 37103 | 2133 | 38 |
2205430 | 2205430 | 2022-02-11 | Jones | North Carolina | 37103 | 2133 | 38 |
2202177 | 2202177 | 2022-02-10 | Jones | North Carolina | 37103 | 2124 | 38 |
2198923 | 2198923 | 2022-02-09 | Jones | North Carolina | 37103 | 2119 | 38 |
2195669 | 2195669 | 2022-02-08 | Jones | North Carolina | 37103 | 2110 | 38 |
2192415 | 2192415 | 2022-02-07 | Jones | North Carolina | 37103 | 2111 | 38 |
2189161 | 2189161 | 2022-02-06 | Jones | North Carolina | 37103 | 2079 | 38 |
2185908 | 2185908 | 2022-02-05 | Jones | North Carolina | 37103 | 2079 | 38 |
2182656 | 2182656 | 2022-02-04 | Jones | North Carolina | 37103 | 2079 | 38 |
2179404 | 2179404 | 2022-02-03 | Jones | North Carolina | 37103 | 2065 | 38 |
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);