ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,553 rows where county = "Johnston" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2338762 | 2338762 | 2022-03-24 | Johnston | North Carolina | 37101 | 58943 | 432 |
2338993 | 2338993 | 2022-03-24 | Johnston | Oklahoma | 40069 | 3030 | 53 |
2335508 | 2335508 | 2022-03-23 | Johnston | North Carolina | 37101 | 58920 | 432 |
2335739 | 2335739 | 2022-03-23 | Johnston | Oklahoma | 40069 | 3028 | 52 |
2332254 | 2332254 | 2022-03-22 | Johnston | North Carolina | 37101 | 58885 | 432 |
2332485 | 2332485 | 2022-03-22 | Johnston | Oklahoma | 40069 | 3028 | 52 |
2329001 | 2329001 | 2022-03-21 | Johnston | North Carolina | 37101 | 58853 | 432 |
2329232 | 2329232 | 2022-03-21 | Johnston | Oklahoma | 40069 | 3028 | 52 |
2325749 | 2325749 | 2022-03-20 | Johnston | North Carolina | 37101 | 58806 | 432 |
2325980 | 2325980 | 2022-03-20 | Johnston | Oklahoma | 40069 | 3028 | 52 |
2322496 | 2322496 | 2022-03-19 | Johnston | North Carolina | 37101 | 58806 | 432 |
2322727 | 2322727 | 2022-03-19 | Johnston | Oklahoma | 40069 | 3028 | 52 |
2319242 | 2319242 | 2022-03-18 | Johnston | North Carolina | 37101 | 58806 | 432 |
2319473 | 2319473 | 2022-03-18 | Johnston | Oklahoma | 40069 | 3028 | 52 |
2315988 | 2315988 | 2022-03-17 | Johnston | North Carolina | 37101 | 58791 | 432 |
2316219 | 2316219 | 2022-03-17 | Johnston | Oklahoma | 40069 | 3028 | 52 |
2312735 | 2312735 | 2022-03-16 | Johnston | North Carolina | 37101 | 58757 | 430 |
2312966 | 2312966 | 2022-03-16 | Johnston | Oklahoma | 40069 | 3024 | 52 |
2309482 | 2309482 | 2022-03-15 | Johnston | North Carolina | 37101 | 58683 | 429 |
2309713 | 2309713 | 2022-03-15 | Johnston | Oklahoma | 40069 | 3024 | 52 |
2306229 | 2306229 | 2022-03-14 | Johnston | North Carolina | 37101 | 58661 | 427 |
2306460 | 2306460 | 2022-03-14 | Johnston | Oklahoma | 40069 | 3024 | 52 |
2302978 | 2302978 | 2022-03-13 | Johnston | North Carolina | 37101 | 58574 | 427 |
2303209 | 2303209 | 2022-03-13 | Johnston | Oklahoma | 40069 | 3024 | 52 |
2299726 | 2299726 | 2022-03-12 | Johnston | North Carolina | 37101 | 58574 | 427 |
2299957 | 2299957 | 2022-03-12 | Johnston | Oklahoma | 40069 | 3024 | 52 |
2296474 | 2296474 | 2022-03-11 | Johnston | North Carolina | 37101 | 58574 | 427 |
2296705 | 2296705 | 2022-03-11 | Johnston | Oklahoma | 40069 | 3024 | 52 |
2293222 | 2293222 | 2022-03-10 | Johnston | North Carolina | 37101 | 58517 | 427 |
2293453 | 2293453 | 2022-03-10 | Johnston | Oklahoma | 40069 | 3024 | 52 |
2289970 | 2289970 | 2022-03-09 | Johnston | North Carolina | 37101 | 58466 | 427 |
2290201 | 2290201 | 2022-03-09 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2286718 | 2286718 | 2022-03-08 | Johnston | North Carolina | 37101 | 58421 | 426 |
2286949 | 2286949 | 2022-03-08 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2283466 | 2283466 | 2022-03-07 | Johnston | North Carolina | 37101 | 58398 | 426 |
2283697 | 2283697 | 2022-03-07 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2280214 | 2280214 | 2022-03-06 | Johnston | North Carolina | 37101 | 58286 | 426 |
2280445 | 2280445 | 2022-03-06 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2276961 | 2276961 | 2022-03-05 | Johnston | North Carolina | 37101 | 58286 | 426 |
2277192 | 2277192 | 2022-03-05 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2273708 | 2273708 | 2022-03-04 | Johnston | North Carolina | 37101 | 58286 | 426 |
2273939 | 2273939 | 2022-03-04 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2270455 | 2270455 | 2022-03-03 | Johnston | North Carolina | 37101 | 58166 | 426 |
2270686 | 2270686 | 2022-03-03 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2267203 | 2267203 | 2022-03-02 | Johnston | North Carolina | 37101 | 58108 | 427 |
2267434 | 2267434 | 2022-03-02 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2263951 | 2263951 | 2022-03-01 | Johnston | North Carolina | 37101 | 58055 | 426 |
2264181 | 2264181 | 2022-03-01 | Johnston | Oklahoma | 40069 | 2981 | 49 |
2260700 | 2260700 | 2022-02-28 | Johnston | North Carolina | 37101 | 58025 | 423 |
2260931 | 2260931 | 2022-02-28 | Johnston | Oklahoma | 40069 | 2981 | 49 |
2257449 | 2257449 | 2022-02-27 | Johnston | North Carolina | 37101 | 57864 | 423 |
2257680 | 2257680 | 2022-02-27 | Johnston | Oklahoma | 40069 | 2981 | 49 |
2254198 | 2254198 | 2022-02-26 | Johnston | North Carolina | 37101 | 57864 | 423 |
2254429 | 2254429 | 2022-02-26 | Johnston | Oklahoma | 40069 | 2981 | 49 |
2250947 | 2250947 | 2022-02-25 | Johnston | North Carolina | 37101 | 57864 | 423 |
2251178 | 2251178 | 2022-02-25 | Johnston | Oklahoma | 40069 | 2981 | 49 |
2247696 | 2247696 | 2022-02-24 | Johnston | North Carolina | 37101 | 57774 | 422 |
2247927 | 2247927 | 2022-02-24 | Johnston | Oklahoma | 40069 | 2981 | 49 |
2244445 | 2244445 | 2022-02-23 | Johnston | North Carolina | 37101 | 57661 | 421 |
2244676 | 2244676 | 2022-02-23 | Johnston | Oklahoma | 40069 | 2981 | 49 |
2241194 | 2241194 | 2022-02-22 | Johnston | North Carolina | 37101 | 57579 | 421 |
2241425 | 2241425 | 2022-02-22 | Johnston | Oklahoma | 40069 | 2943 | 49 |
2237943 | 2237943 | 2022-02-21 | Johnston | North Carolina | 37101 | 57553 | 415 |
2238174 | 2238174 | 2022-02-21 | Johnston | Oklahoma | 40069 | 2943 | 49 |
2234692 | 2234692 | 2022-02-20 | Johnston | North Carolina | 37101 | 57267 | 414 |
2234923 | 2234923 | 2022-02-20 | Johnston | Oklahoma | 40069 | 2943 | 49 |
2231441 | 2231441 | 2022-02-19 | Johnston | North Carolina | 37101 | 57267 | 414 |
2231672 | 2231672 | 2022-02-19 | Johnston | Oklahoma | 40069 | 2943 | 49 |
2228190 | 2228190 | 2022-02-18 | Johnston | North Carolina | 37101 | 57267 | 414 |
2228421 | 2228421 | 2022-02-18 | Johnston | Oklahoma | 40069 | 2943 | 49 |
2224939 | 2224939 | 2022-02-17 | Johnston | North Carolina | 37101 | 57094 | 408 |
2225170 | 2225170 | 2022-02-17 | Johnston | Oklahoma | 40069 | 2943 | 49 |
2221688 | 2221688 | 2022-02-16 | Johnston | North Carolina | 37101 | 56881 | 403 |
2221919 | 2221919 | 2022-02-16 | Johnston | Oklahoma | 40069 | 2943 | 49 |
2218437 | 2218437 | 2022-02-15 | Johnston | North Carolina | 37101 | 56650 | 402 |
2218668 | 2218668 | 2022-02-15 | Johnston | Oklahoma | 40069 | 2913 | 49 |
2215186 | 2215186 | 2022-02-14 | Johnston | North Carolina | 37101 | 56578 | 402 |
2215417 | 2215417 | 2022-02-14 | Johnston | Oklahoma | 40069 | 2913 | 49 |
2211935 | 2211935 | 2022-02-13 | Johnston | North Carolina | 37101 | 56259 | 399 |
2212166 | 2212166 | 2022-02-13 | Johnston | Oklahoma | 40069 | 2913 | 49 |
2208682 | 2208682 | 2022-02-12 | Johnston | North Carolina | 37101 | 56259 | 399 |
2208913 | 2208913 | 2022-02-12 | Johnston | Oklahoma | 40069 | 2913 | 49 |
2205429 | 2205429 | 2022-02-11 | Johnston | North Carolina | 37101 | 56259 | 399 |
2205660 | 2205660 | 2022-02-11 | Johnston | Oklahoma | 40069 | 2913 | 49 |
2202176 | 2202176 | 2022-02-10 | Johnston | North Carolina | 37101 | 56130 | 398 |
2202407 | 2202407 | 2022-02-10 | Johnston | Oklahoma | 40069 | 2913 | 49 |
2198922 | 2198922 | 2022-02-09 | Johnston | North Carolina | 37101 | 55904 | 389 |
2199153 | 2199153 | 2022-02-09 | Johnston | Oklahoma | 40069 | 2913 | 49 |
2195668 | 2195668 | 2022-02-08 | Johnston | North Carolina | 37101 | 55706 | 387 |
2195899 | 2195899 | 2022-02-08 | Johnston | Oklahoma | 40069 | 2859 | 49 |
2192414 | 2192414 | 2022-02-07 | Johnston | North Carolina | 37101 | 55590 | 387 |
2192645 | 2192645 | 2022-02-07 | Johnston | Oklahoma | 40069 | 2859 | 49 |
2189160 | 2189160 | 2022-02-06 | Johnston | North Carolina | 37101 | 55086 | 384 |
2189391 | 2189391 | 2022-02-06 | Johnston | Oklahoma | 40069 | 2859 | 49 |
2185907 | 2185907 | 2022-02-05 | Johnston | North Carolina | 37101 | 55086 | 384 |
2186138 | 2186138 | 2022-02-05 | Johnston | Oklahoma | 40069 | 2859 | 49 |
2182655 | 2182655 | 2022-02-04 | Johnston | North Carolina | 37101 | 55086 | 384 |
2182886 | 2182886 | 2022-02-04 | Johnston | Oklahoma | 40069 | 2859 | 49 |
2179403 | 2179403 | 2022-02-03 | Johnston | North Carolina | 37101 | 54729 | 380 |
2179634 | 2179634 | 2022-02-03 | Johnston | Oklahoma | 40069 | 2859 | 49 |
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);