participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,509 rows where station_code = "US0021" 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 |
---|---|---|---|---|---|
5126405 | 5126405 | 20240918113216_ondh3 | US0021 | 2024-09-19T12:05:54.696Z | 2024-09-19T12:06:42.195Z |
5118414 | 5118414 | 20240915093914_cs3pX | US0021 | 2024-09-18T12:08:43.055Z | 2024-09-19T12:19:22.622Z |
5110093 | 5110093 | 20240913120318_wF5tw | US0021 | 2024-09-17T12:14:56.874Z | 2024-09-19T12:20:55.752Z |
5109610 | 5109610 | 20240913103604_3efFK | US0021 | 2024-09-17T12:14:42.056Z | 2024-09-19T12:20:53.819Z |
5096805 | 5096805 | 20240912114919_2ZNMu | US0021 | 2024-09-16T12:16:35.096Z | 2024-09-19T12:21:23.891Z |
5096568 | 5096568 | 20240912111319_F9ufE | US0021 | 2024-09-16T12:16:27.587Z | 2024-09-19T12:21:22.803Z |
5096541 | 5096541 | 20240912110954_31vUq | US0021 | 2024-09-16T12:16:27.009Z | 2024-09-19T12:21:22.714Z |
5096294 | 5096294 | 20240912102904_IjTF7 | US0021 | 2024-09-16T12:16:19.093Z | 2024-09-19T12:21:22.035Z |
5095840 | 5095840 | 20240912091425_hC6yO | US0021 | 2024-09-16T12:16:00.197Z | 2024-09-19T12:21:20.504Z |
5083040 | 5083040 | 20240911115058_VR66c | US0021 | 2024-09-15T12:18:34.298Z | 2024-09-19T12:21:49.162Z |
5082822 | 5082822 | 20240911110545_VuAnl | US0021 | 2024-09-15T12:18:26.399Z | 2024-09-19T12:21:48.735Z |
5081842 | 5081842 | 20240911085024_spDP8 | US0021 | 2024-09-15T12:17:50.779Z | 2024-09-19T12:21:46.564Z |
5081664 | 5081664 | 20240911081919_PfcwQ | US0021 | 2024-09-15T12:17:40.357Z | 2024-09-19T12:21:45.988Z |
5081621 | 5081621 | 20240911081016_9eZyD | US0021 | 2024-09-15T12:17:38.940Z | 2024-09-19T12:21:45.873Z |
5081573 | 5081573 | 20240911080430_MG6sE | US0021 | 2024-09-15T12:17:38.167Z | 2024-09-19T12:21:45.790Z |
5081314 | 5081314 | 20240911072031_7qHHK | US0021 | 2024-09-15T12:17:30.104Z | 2024-09-19T12:21:45.073Z |
5080475 | 5080475 | 20240911040150_3t43R | US0021 | 2024-09-15T12:17:04.790Z | 2024-09-19T12:21:43.311Z |
5068712 | 5068712 | 20240910120814_T6Gv2 | US0021 | 2024-09-14T12:19:20.626Z | 2024-09-18T12:15:26.531Z |
5068491 | 5068491 | 20240910114200_htKo0 | US0021 | 2024-09-14T12:19:16.620Z | 2024-09-18T12:15:26.222Z |
5068039 | 5068039 | 20240910104612_PL0BN | US0021 | 2024-09-14T12:19:07.498Z | 2024-09-18T12:15:25.418Z |
5067852 | 5067852 | 20240910102029_MyQjK | US0021 | 2024-09-14T12:19:00.657Z | 2024-09-18T12:15:24.976Z |
5067748 | 5067748 | 20240910100850_GaHsp | US0021 | 2024-09-14T12:18:55.998Z | 2024-09-18T12:15:24.835Z |
5067594 | 5067594 | 20240910094905_3fVx9 | US0021 | 2024-09-14T12:18:50.396Z | 2024-09-18T12:15:24.519Z |
5067258 | 5067258 | 20240910091319_Jf9BX | US0021 | 2024-09-14T12:18:37.561Z | 2024-09-18T12:15:23.694Z |
5066795 | 5066795 | 20240910081827_FeiwA | US0021 | 2024-09-14T12:18:12.723Z | 2024-09-18T12:15:22.760Z |
5066775 | 5066775 | 20240910081541_zJbHH | US0021 | 2024-09-14T12:18:12.186Z | 2024-09-18T12:15:22.748Z |
5065860 | 5065860 | 20240910055124_IeKQ1 | US0021 | 2024-09-14T12:17:26.101Z | 2024-09-18T12:15:20.572Z |
5065689 | 5065689 | 20240910051259_FbjRY | US0021 | 2024-09-14T12:17:19.090Z | 2024-09-18T12:15:20.157Z |
5056962 | 5056962 | 20240908114637_JvNYM | US0021 | 2024-09-13T12:17:41.939Z | 2024-09-16T12:21:27.999Z |
5056734 | 5056734 | 20240908111647_RF2wg | US0021 | 2024-09-13T12:17:38.674Z | 2024-09-16T12:21:26.983Z |
5056711 | 5056711 | 20240908111215_PymAU | US0021 | 2024-09-13T12:17:38.106Z | 2024-09-16T12:21:26.827Z |
5056389 | 5056389 | 20240908102134_DS5jy | US0021 | 2024-09-13T12:17:31.190Z | 2024-09-16T12:21:24.836Z |
5056192 | 5056192 | 20240908095337_EtTP3 | US0021 | 2024-09-13T12:17:28.355Z | 2024-09-16T12:21:23.781Z |
5056154 | 5056154 | 20240908094748_zMwOM | US0021 | 2024-09-13T12:17:28.014Z | 2024-09-16T12:21:23.598Z |
5056129 | 5056129 | 20240908094441_UV3Yp | US0021 | 2024-09-13T12:17:27.827Z | 2024-09-16T12:21:23.454Z |
5055952 | 5055952 | 20240908092500_oHQeW | US0021 | 2024-09-13T12:17:25.912Z | 2024-09-16T12:21:22.666Z |
5055816 | 5055816 | 20240908090635_uytTj | US0021 | 2024-09-13T12:17:22.518Z | 2024-09-16T12:21:22.121Z |
5055555 | 5055555 | 20240908082326_zJxxQ | US0021 | 2024-09-13T12:17:17.143Z | 2024-09-16T12:21:20.365Z |
5055287 | 5055287 | 20240908074304_PO2x7 | US0021 | 2024-09-13T12:17:09.104Z | 2024-09-16T12:21:18.587Z |
5049725 | 5049725 | 20240909113143_KmWuX | US0021 | 2024-09-13T12:12:24.212Z | 2024-09-17T12:19:11.315Z |
5049098 | 5049098 | 20240909100610_6C9Qh | US0021 | 2024-09-13T12:11:33.899Z | 2024-09-17T12:19:09.160Z |
5048809 | 5048809 | 20240909091404_Nh8PK | US0021 | 2024-09-13T12:11:16.735Z | 2024-09-17T12:19:08.408Z |
5048749 | 5048749 | 20240909090356_16BzI | US0021 | 2024-09-13T12:11:13.326Z | 2024-09-17T12:19:08.206Z |
5048665 | 5048665 | 20240909085024_fK5xx | US0021 | 2024-09-13T12:11:08.619Z | 2024-09-17T12:19:07.866Z |
5048152 | 5048152 | 20240909071232_n1SlQ | US0021 | 2024-09-13T12:10:18.136Z | 2024-09-17T12:19:05.958Z |
5048147 | 5048147 | 20240909071204_xtkrR | US0021 | 2024-09-13T12:10:17.800Z | 2024-09-17T12:19:05.946Z |
5047883 | 5047883 | 20240909061827_rgYIb | US0021 | 2024-09-13T12:09:54.635Z | 2024-09-17T12:19:04.851Z |
5047742 | 5047742 | 20240909054413_l333G | US0021 | 2024-09-13T12:09:37.766Z | 2024-09-17T12:19:04.149Z |
5047601 | 5047601 | 20240909045721_NeCFZ | US0021 | 2024-09-13T12:09:27.608Z | 2024-09-17T12:19:03.660Z |
5047594 | 5047594 | 20240909045423_26Yhg | US0021 | 2024-09-13T12:09:27.054Z | 2024-09-17T12:19:03.645Z |
5042428 | 5042428 | 20240907113716_IU1E0 | US0021 | 2024-09-12T12:17:10.998Z | 2024-09-16T12:20:52.764Z |
5042153 | 5042153 | 20240906100411_SJsBG | US0021 | 2024-09-12T12:16:56.360Z | 2024-09-14T12:23:16.262Z |
5042144 | 5042144 | 20240906100256_dh37y | US0021 | 2024-09-12T12:16:56.169Z | 2024-09-14T12:23:16.167Z |
5041100 | 5041100 | 20240906072055_9GZ01 | US0021 | 2024-09-12T12:16:33.894Z | 2024-09-14T12:23:11.780Z |
5040924 | 5040924 | 20240906062843_8cdqP | US0021 | 2024-09-12T12:16:28.426Z | 2024-09-14T12:23:11.014Z |
5035336 | 5035336 | 20240907092006_39lWi | US0021 | 2024-09-12T12:12:00.895Z | 2024-09-15T12:21:39.362Z |
5034993 | 5034993 | 20240907082803_WdWu2 | US0021 | 2024-09-12T12:11:48.385Z | 2024-09-15T12:21:37.847Z |
5028223 | 5028223 | 20240905091627_EEXY6 | US0021 | 2024-09-11T12:15:01.783Z | 2024-09-13T12:20:05.768Z |
5028083 | 5028083 | 20240905090203_bBcUh | US0021 | 2024-09-11T12:14:50.742Z | 2024-09-13T12:20:05.244Z |
5027790 | 5027790 | 20240905082317_nYGKy | US0021 | 2024-09-11T12:14:30.709Z | 2024-09-13T12:20:04.728Z |
5022659 | 5022659 | 20240905091627_fwVPk | US0021 | 2024-09-10T12:16:26.558Z | 2024-09-10T12:16:55.591Z |
5022523 | 5022523 | 20240905090203_QheXe | US0021 | 2024-09-10T12:16:22.407Z | 2024-09-10T12:16:55.567Z |
5022236 | 5022236 | 20240905082317_oEwPI | US0021 | 2024-09-10T12:16:12.355Z | 2024-09-10T12:16:55.521Z |
5015553 | 5015553 | 20240904115155_u31ia | US0021 | 2024-09-10T12:06:23.325Z | 2024-09-13T12:19:44.282Z |
5012669 | 5012669 | 20240903071704_0miyb | US0021 | 2024-09-09T12:18:01.621Z | 2024-09-11T12:21:18.504Z |
5012523 | 5012523 | 20240903065609_1fBtN | US0021 | 2024-09-09T12:17:55.212Z | 2024-09-11T12:21:18.013Z |
5012146 | 5012146 | 20240904084536_HBdlb | US0021 | 2024-09-09T12:10:23.512Z | 2024-09-12T12:19:34.910Z |
5012038 | 5012038 | 20240904083157_LQBO8 | US0021 | 2024-09-09T12:10:18.965Z | 2024-09-12T12:19:34.574Z |
5011889 | 5011889 | 20240904081156_c7oKx | US0021 | 2024-09-09T12:10:07.738Z | 2024-09-12T12:19:34.030Z |
5004693 | 5004693 | 20240903120910_mXLP2 | US0021 | 2024-09-09T12:02:55.122Z | 2024-09-12T12:19:03.535Z |
5004660 | 5004660 | 20240903120352_8SHdR | US0021 | 2024-09-09T12:02:53.510Z | 2024-09-12T12:19:03.442Z |
5004646 | 5004646 | 20240903115940_RIskz | US0021 | 2024-09-09T12:02:52.631Z | 2024-09-12T12:19:03.376Z |
5004170 | 5004170 | 20240903105443_s6qA5 | US0021 | 2024-09-09T12:02:25.488Z | 2024-09-12T12:19:00.948Z |
5004038 | 5004038 | 20240903102828_Y8u8C | US0021 | 2024-09-09T12:02:18.256Z | 2024-09-12T12:19:00.557Z |
5003916 | 5003916 | 20240903101344_ckwBf | US0021 | 2024-09-09T12:02:12.389Z | 2024-09-12T12:19:00.168Z |
5003482 | 5003482 | 20240903090130_kMdOe | US0021 | 2024-09-09T12:01:46.837Z | 2024-09-12T12:18:56.981Z |
5002349 | 5002349 | 20240904093712_03A2d | US0021 | 2024-09-09T12:00:29.503Z | 2024-09-13T12:19:40.567Z |
5001798 | 5001798 | 20240902064344_s6zFz | US0021 | 2024-09-08T12:16:58.055Z | 2024-09-10T12:19:34.740Z |
4998863 | 4998863 | 20240903041738_MHeWQ | US0021 | 2024-09-08T12:08:09.213Z | 2024-09-11T12:21:15.320Z |
4998443 | 4998443 | 20240903030441_Bdon3 | US0021 | 2024-09-08T12:07:38.596Z | 2024-09-11T12:21:12.800Z |
4991688 | 4991688 | 20240901025850_382aq | US0021 | 2024-09-07T12:12:23.971Z | 2024-09-09T12:27:15.757Z |
4985196 | 4985196 | 20240901114233_042Vf | US0021 | 2024-09-07T12:02:58.942Z | 2024-09-10T12:19:07.264Z |
4984747 | 4984747 | 20240901104641_PN3NA | US0021 | 2024-09-07T12:02:21.668Z | 2024-09-10T12:19:06.117Z |
4984216 | 4984216 | 20240901092659_bDKrc | US0021 | 2024-09-07T12:01:34.351Z | 2024-09-10T12:19:04.810Z |
4956359 | 4956359 | 20240811071004_7jnfP | US0021 | 2024-09-03T12:20:17.825Z | 2024-09-06T12:30:27.467Z |
4956101 | 4956101 | 20240811064447_xVg30 | US0021 | 2024-09-03T12:19:52.823Z | 2024-09-06T12:30:15.605Z |
4955899 | 4955899 | 20240811062024_SjpOo | US0021 | 2024-09-03T12:19:33.689Z | 2024-09-06T12:30:03.261Z |
4955688 | 4955688 | 20240811054956_PWtxv | US0021 | 2024-09-03T12:19:22.958Z | 2024-09-06T12:29:53.315Z |
4955664 | 4955664 | 20240811054748_zv6rQ | US0021 | 2024-09-03T12:19:22.330Z | 2024-09-06T12:29:53.000Z |
4868779 | 4868779 | 20240806071126_3MAls | US0021 | 2024-08-18T12:24:29.885Z | 2024-08-19T12:29:00.803Z |
4868705 | 4868705 | 20240806070311_IKER4 | US0021 | 2024-08-18T12:24:24.393Z | 2024-08-19T12:28:56.620Z |
4861451 | 4861451 | 20240806113626_jrWCQ | US0021 | 2024-08-18T12:03:43.323Z | 2024-08-27T12:03:34.350Z |
4860593 | 4860593 | 20240806104850_NR22g | US0021 | 2024-08-18T12:02:58.778Z | 2024-08-27T12:02:53.810Z |
4818558 | 4818558 | 20240804094449_GZhIU | US0021 | 2024-08-14T12:03:07.515Z | 2024-08-17T12:24:42.785Z |
4818021 | 4818021 | 20240804081946_szMix | US0021 | 2024-08-14T12:01:48.584Z | 2024-08-17T12:24:09.243Z |
4818007 | 4818007 | 20240804081717_ZyTxb | US0021 | 2024-08-14T12:01:47.168Z | 2024-08-17T12:24:08.519Z |
4817929 | 4817929 | 20240804080731_BbZ5W | US0021 | 2024-08-14T12:01:33.674Z | 2024-08-17T12:24:02.009Z |
4809177 | 4809177 | 20240803114619_bQmUz | US0021 | 2024-08-13T12:06:44.002Z | 2024-08-15T12:19:34.673Z |
4809045 | 4809045 | 20240803113659_9vd7Q | US0021 | 2024-08-13T12:06:33.038Z | 2024-08-15T12:19:29.173Z |
4808829 | 4808829 | 20240803112152_RS2vK | US0021 | 2024-08-13T12:06:14.549Z | 2024-08-15T12:19:21.770Z |
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);