participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
19,827 rows where station_code = "US000P" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5134110 | 5134110 | 20240916050716_2S6ow | US000P | 2024-09-19T12:17:21.574Z | 2024-09-19T12:17:21.574Z |
5134047 | 5134047 | 20240916043518_hAAPv | US000P | 2024-09-19T12:17:17.080Z | 2024-09-19T12:17:17.080Z |
5133740 | 5133740 | 20240916040148_Up4Tn | US000P | 2024-09-19T12:17:06.892Z | 2024-09-19T12:17:06.892Z |
5129433 | 5129433 | 20240917035553_2YPVQ | US000P | 2024-09-19T12:11:36.897Z | 2024-09-19T12:11:36.897Z |
5129425 | 5129425 | 20240917035529_oJRxD | US000P | 2024-09-19T12:11:36.012Z | 2024-09-19T12:11:36.012Z |
5126449 | 5126449 | 20240918115353_WHZhA | US000P | 2024-09-19T12:05:58.642Z | 2024-09-19T12:06:42.202Z |
5126009 | 5126009 | 20240918062948_h7Avd | US000P | 2024-09-19T12:04:44.407Z | 2024-09-19T12:06:42.124Z |
5125996 | 5125996 | 20240918061413_676jt | US000P | 2024-09-19T12:04:43.430Z | 2024-09-19T12:06:42.122Z |
5125944 | 5125944 | 20240918050554_EqkkA | US000P | 2024-09-19T12:04:36.426Z | 2024-09-19T12:06:42.113Z |
5125889 | 5125889 | 20240918042551_CusbN | US000P | 2024-09-19T12:04:29.199Z | 2024-09-19T12:06:42.102Z |
5125781 | 5125781 | 20240918035301_YIS0y | US000P | 2024-09-19T12:04:04.881Z | 2024-09-19T12:06:42.084Z |
5125611 | 5125611 | 20240918030844_itaKA | US000P | 2024-09-19T12:03:41.368Z | 2024-09-19T12:06:42.058Z |
5125494 | 5125494 | 20240918024921_nZiU0 | US000P | 2024-09-19T12:03:22.602Z | 2024-09-19T12:06:42.042Z |
5125368 | 5125368 | 20240918022122_ta3Fp | US000P | 2024-09-19T12:03:05.431Z | 2024-09-19T12:06:42.021Z |
5123712 | 5123712 | 20240914111239_RqFwM | US000P | 2024-09-18T12:11:54.688Z | 2024-09-19T12:20:14.211Z |
5123690 | 5123690 | 20240914110504_ns8pr | US000P | 2024-09-18T12:11:54.014Z | 2024-09-19T12:20:13.787Z |
5123595 | 5123595 | 20240914104115_bN2yh | US000P | 2024-09-18T12:11:51.803Z | 2024-09-19T12:20:13.098Z |
5123337 | 5123337 | 20240914094730_0J3LU | US000P | 2024-09-18T12:11:45.362Z | 2024-09-19T12:20:10.431Z |
5123264 | 5123264 | 20240914092758_yZG35 | US000P | 2024-09-18T12:11:43.660Z | 2024-09-19T12:20:09.210Z |
5123211 | 5123211 | 20240914091713_dJjku | US000P | 2024-09-18T12:11:42.468Z | 2024-09-19T12:20:08.964Z |
5123041 | 5123041 | 20240914084406_Nmo2j | US000P | 2024-09-18T12:11:38.838Z | 2024-09-19T12:20:07.447Z |
5122592 | 5122592 | 20240914071551_sw3Pu | US000P | 2024-09-18T12:11:24.263Z | 2024-09-19T12:20:05.222Z |
5122491 | 5122491 | 20240914064800_tcOnS | US000P | 2024-09-18T12:11:20.774Z | 2024-09-19T12:20:04.557Z |
5122372 | 5122372 | 20240914060144_02jZh | US000P | 2024-09-18T12:11:15.874Z | 2024-09-19T12:20:04.051Z |
5118574 | 5118574 | 20240915102111_SbM09 | US000P | 2024-09-18T12:08:51.496Z | 2024-09-19T12:19:23.958Z |
5118510 | 5118510 | 20240915100134_g3iW3 | US000P | 2024-09-18T12:08:49.146Z | 2024-09-19T12:19:23.493Z |
5118064 | 5118064 | 20240915082134_ncQXS | US000P | 2024-09-18T12:08:21.218Z | 2024-09-19T12:19:20.006Z |
5118009 | 5118009 | 20240915080750_2X4Hm | US000P | 2024-09-18T12:08:17.112Z | 2024-09-19T12:19:19.725Z |
5117910 | 5117910 | 20240915074346_IcJeh | US000P | 2024-09-18T12:08:06.598Z | 2024-09-19T12:19:18.910Z |
5117861 | 5117861 | 20240915072918_kYiuv | US000P | 2024-09-18T12:08:03.783Z | 2024-09-19T12:19:18.610Z |
5117743 | 5117743 | 20240915064135_nqT7M | US000P | 2024-09-18T12:07:54.774Z | 2024-09-19T12:19:17.420Z |
5117677 | 5117677 | 20240915061826_NJGg1 | US000P | 2024-09-18T12:07:51.828Z | 2024-09-19T12:19:16.906Z |
5117666 | 5117666 | 20240915061702_b2BGw | US000P | 2024-09-18T12:07:51.440Z | 2024-09-19T12:19:16.831Z |
5109964 | 5109964 | 20240913114144_7kVix | US000P | 2024-09-17T12:14:51.827Z | 2024-09-19T12:20:55.500Z |
5109761 | 5109761 | 20240913110344_4K8cI | US000P | 2024-09-17T12:14:45.520Z | 2024-09-19T12:20:54.713Z |
5109652 | 5109652 | 20240913104219_ydC5t | US000P | 2024-09-17T12:14:42.929Z | 2024-09-19T12:20:54.160Z |
5109609 | 5109609 | 20240913103558_MvYdy | US000P | 2024-09-17T12:14:42.035Z | 2024-09-19T12:20:53.815Z |
5109451 | 5109451 | 20240913095642_3ebA0 | US000P | 2024-09-17T12:14:38.381Z | 2024-09-19T12:20:53.357Z |
5109441 | 5109441 | 20240913095542_B38Z3 | US000P | 2024-09-17T12:14:38.153Z | 2024-09-19T12:20:53.341Z |
5109434 | 5109434 | 20240913095311_S76DW | US000P | 2024-09-17T12:14:37.986Z | 2024-09-19T12:20:53.304Z |
5109424 | 5109424 | 20240913095207_pXfFF | US000P | 2024-09-17T12:14:37.858Z | 2024-09-19T12:20:53.276Z |
5109392 | 5109392 | 20240913094646_yA56s | US000P | 2024-09-17T12:14:37.234Z | 2024-09-19T12:20:53.203Z |
5109288 | 5109288 | 20240913092721_mSmff | US000P | 2024-09-17T12:14:34.626Z | 2024-09-19T12:20:52.761Z |
5109024 | 5109024 | 20240913082706_lid6i | US000P | 2024-09-17T12:14:26.088Z | 2024-09-19T12:20:51.487Z |
5108976 | 5108976 | 20240913081543_c3OQ8 | US000P | 2024-09-17T12:14:23.145Z | 2024-09-19T12:20:51.339Z |
5108656 | 5108656 | 20240913065535_FVTbf | US000P | 2024-09-17T12:13:56.155Z | 2024-09-19T12:20:50.199Z |
5108602 | 5108602 | 20240913064034_FKTUL | US000P | 2024-09-17T12:13:52.979Z | 2024-09-19T12:20:49.727Z |
5108459 | 5108459 | 20240913054716_iibdF | US000P | 2024-09-17T12:13:45.330Z | 2024-09-19T12:20:48.881Z |
5096658 | 5096658 | 20240912112727_NSUSF | US000P | 2024-09-16T12:16:30.856Z | 2024-09-19T12:21:23.361Z |
5096074 | 5096074 | 20240912095217_CSR2A | US000P | 2024-09-16T12:16:08.443Z | 2024-09-19T12:21:21.253Z |
5095924 | 5095924 | 20240912092733_ialUi | US000P | 2024-09-16T12:16:02.078Z | 2024-09-19T12:21:20.662Z |
5095878 | 5095878 | 20240912092012_YaZiK | US000P | 2024-09-16T12:16:01.068Z | 2024-09-19T12:21:20.579Z |
5095759 | 5095759 | 20240912085513_bsNOH | US000P | 2024-09-16T12:15:56.477Z | 2024-09-19T12:21:20.046Z |
5095736 | 5095736 | 20240912085051_STshB | US000P | 2024-09-16T12:15:55.210Z | 2024-09-19T12:21:19.965Z |
5095606 | 5095606 | 20240912082557_Sna55 | US000P | 2024-09-16T12:15:50.735Z | 2024-09-19T12:21:19.238Z |
5095543 | 5095543 | 20240912080128_NRw0d | US000P | 2024-09-16T12:15:46.605Z | 2024-09-19T12:21:18.863Z |
5095440 | 5095440 | 20240912073124_xlPpG | US000P | 2024-09-16T12:15:40.168Z | 2024-09-19T12:21:18.535Z |
5095369 | 5095369 | 20240912072245_SWEvN | US000P | 2024-09-16T12:15:37.240Z | 2024-09-19T12:21:18.255Z |
5082788 | 5082788 | 20240911105719_9CPtZ | US000P | 2024-09-15T12:18:25.340Z | 2024-09-19T12:21:48.655Z |
5082768 | 5082768 | 20240911105621_0h3ur | US000P | 2024-09-15T12:18:25.099Z | 2024-09-19T12:21:48.651Z |
5082729 | 5082729 | 20240911105011_FkRlC | US000P | 2024-09-15T12:18:23.971Z | 2024-09-19T12:21:48.489Z |
5082337 | 5082337 | 20240911095541_XKOmi | US000P | 2024-09-15T12:18:11.533Z | 2024-09-19T12:21:47.801Z |
5082160 | 5082160 | 20240911092942_fZw0k | US000P | 2024-09-15T12:18:05.364Z | 2024-09-19T12:21:47.251Z |
5082030 | 5082030 | 20240911091424_O5818 | US000P | 2024-09-15T12:17:59.940Z | 2024-09-19T12:21:47.095Z |
5081995 | 5081995 | 20240911091035_78fp0 | US000P | 2024-09-15T12:17:57.488Z | 2024-09-19T12:21:46.959Z |
5081905 | 5081905 | 20240911090138_X3R9R | US000P | 2024-09-15T12:17:53.645Z | 2024-09-19T12:21:46.711Z |
5081699 | 5081699 | 20240911082802_Bu1lG | US000P | 2024-09-15T12:17:42.419Z | 2024-09-19T12:21:46.109Z |
5081048 | 5081048 | 20240911061413_YQIwI | US000P | 2024-09-15T12:17:21.654Z | 2024-09-19T12:21:44.453Z |
5068438 | 5068438 | 20240910113238_sRl6c | US000P | 2024-09-14T12:19:15.416Z | 2024-09-18T12:15:26.145Z |
5067872 | 5067872 | 20240910102301_77C4D | US000P | 2024-09-14T12:19:01.421Z | 2024-09-18T12:15:24.997Z |
5066037 | 5066037 | 20240910062633_3ct9F | US000P | 2024-09-14T12:17:36.171Z | 2024-09-18T12:15:21.018Z |
5066028 | 5066028 | 20240910062506_CL1a9 | US000P | 2024-09-14T12:17:35.734Z | 2024-09-18T12:15:21.014Z |
5065976 | 5065976 | 20240910061303_iEqDZ | US000P | 2024-09-14T12:17:32.582Z | 2024-09-18T12:15:20.938Z |
5065936 | 5065936 | 20240910060335_UZFsI | US000P | 2024-09-14T12:17:28.961Z | 2024-09-18T12:15:20.742Z |
5065611 | 5065611 | 20240910044913_r8wXH | US000P | 2024-09-14T12:17:14.070Z | 2024-09-18T12:15:19.937Z |
5056978 | 5056978 | 20240908114822_PfvJJ | US000P | 2024-09-13T12:17:42.278Z | 2024-09-16T12:21:28.236Z |
5056811 | 5056811 | 20240908112837_vTBou | US000P | 2024-09-13T12:17:39.648Z | 2024-09-16T12:21:27.422Z |
5056453 | 5056453 | 20240908103158_ZpBXo | US000P | 2024-09-13T12:17:32.301Z | 2024-09-16T12:21:25.475Z |
5056346 | 5056346 | 20240908101323_l75xy | US000P | 2024-09-13T12:17:30.536Z | 2024-09-16T12:21:24.519Z |
5056241 | 5056241 | 20240908095937_ucIvZ | US000P | 2024-09-13T12:17:28.774Z | 2024-09-16T12:21:23.911Z |
5056201 | 5056201 | 20240908095408_FDEy3 | US000P | 2024-09-13T12:17:28.417Z | 2024-09-16T12:21:23.790Z |
5056135 | 5056135 | 20240908094516_3vn8C | US000P | 2024-09-13T12:17:27.867Z | 2024-09-16T12:21:23.478Z |
5055870 | 5055870 | 20240908091213_utAI3 | US000P | 2024-09-13T12:17:24.422Z | 2024-09-16T12:21:22.315Z |
5055640 | 5055640 | 20240908083052_Kt3R2 | US000P | 2024-09-13T12:17:19.241Z | 2024-09-16T12:21:21.337Z |
5055106 | 5055106 | 20240908064435_isAWm | US000P | 2024-09-13T12:17:05.329Z | 2024-09-16T12:21:17.950Z |
5049567 | 5049567 | 20240909111237_OtsZ8 | US000P | 2024-09-13T12:12:18.355Z | 2024-09-17T12:19:10.883Z |
5048724 | 5048724 | 20240909085836_8vxaI | US000P | 2024-09-13T12:11:11.991Z | 2024-09-17T12:19:08.135Z |
5048597 | 5048597 | 20240909083446_u6T5K | US000P | 2024-09-13T12:10:57.086Z | 2024-09-17T12:19:07.622Z |
5048383 | 5048383 | 20240909075419_3rQr5 | US000P | 2024-09-13T12:10:31.292Z | 2024-09-17T12:19:06.689Z |
5048353 | 5048353 | 20240909075011_h6hID | US000P | 2024-09-13T12:10:29.659Z | 2024-09-17T12:19:06.598Z |
5048192 | 5048192 | 20240909072035_wzCq3 | US000P | 2024-09-13T12:10:20.068Z | 2024-09-17T12:19:06.047Z |
5048131 | 5048131 | 20240909070809_cSIMu | US000P | 2024-09-13T12:10:16.505Z | 2024-09-17T12:19:05.859Z |
5047892 | 5047892 | 20240909061919_xVSLX | US000P | 2024-09-13T12:09:55.433Z | 2024-09-17T12:19:04.903Z |
5047777 | 5047777 | 20240909055222_jiNO3 | US000P | 2024-09-13T12:09:40.209Z | 2024-09-17T12:19:04.261Z |
5047279 | 5047279 | 20240909032054_j3M9l | US000P | 2024-09-13T12:08:44.441Z | 2024-09-17T12:19:01.910Z |
5047252 | 5047252 | 20240909031418_nskPG | US000P | 2024-09-13T12:08:42.303Z | 2024-09-17T12:19:01.824Z |
5043436 | 5043436 | 20240907110215_vto3a | US000P | 2024-09-12T12:17:33.853Z | 2024-09-15T12:21:41.678Z |
5043400 | 5043400 | 20240907105657_aQ3C7 | US000P | 2024-09-12T12:17:32.765Z | 2024-09-15T12:21:41.580Z |
5041936 | 5041936 | 20240906092757_dUj4o | US000P | 2024-09-12T12:16:52.671Z | 2024-09-14T12:23:15.398Z |
5041727 | 5041727 | 20240906085657_M6VOH | US000P | 2024-09-12T12:16:47.817Z | 2024-09-14T12:23:14.424Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);