participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,967 rows where station_code = "CH0005" 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 |
---|---|---|---|---|---|
5511186 | 5511186 | 20241109045817_JlAY6 | CH0005 | 2024-11-10T14:16:26.880Z | 2024-11-12T14:23:45.993Z |
5511172 | 5511172 | 20241109045633_ByFPU | CH0005 | 2024-11-10T14:16:24.402Z | 2024-11-12T14:23:45.851Z |
5511097 | 5511097 | 20241109042510_58yF2 | CH0005 | 2024-11-10T14:16:14.394Z | 2024-11-12T14:23:44.834Z |
5510722 | 5510722 | 20241109032936_DSQbk | CH0005 | 2024-11-10T14:15:35.991Z | 2024-11-12T14:23:39.815Z |
5510556 | 5510556 | 20241109025831_vbteQ | CH0005 | 2024-11-10T14:15:26.348Z | 2024-11-12T14:23:37.841Z |
5510523 | 5510523 | 20241109025337_2V9mx | CH0005 | 2024-11-10T14:15:24.437Z | 2024-11-12T14:23:37.458Z |
5510398 | 5510398 | 20241109023453_2E4GQ | CH0005 | 2024-11-10T14:15:08.939Z | 2024-11-12T14:23:35.692Z |
5510015 | 5510015 | 20241109012707_QtkRF | CH0005 | 2024-11-10T14:14:26.940Z | 2024-11-12T14:23:28.952Z |
5508993 | 5508993 | 20241108210801_FqUKG | CH0005 | 2024-11-10T14:12:15.092Z | 2024-11-12T14:23:10.963Z |
5508773 | 5508773 | 20241108191739_Qqix8 | CH0005 | 2024-11-10T14:11:47.576Z | 2024-11-12T14:23:03.284Z |
5495926 | 5495926 | 20241106220928_C5MmJ | CH0005 | 2024-11-08T14:11:08.859Z | 2024-11-12T14:26:00.029Z |
5495858 | 5495858 | 20241106215133_nTR4a | CH0005 | 2024-11-08T14:11:01.911Z | 2024-11-12T14:25:58.591Z |
5495794 | 5495794 | 20241106213546_Mn2C4 | CH0005 | 2024-11-08T14:10:53.617Z | 2024-11-12T14:25:57.864Z |
5495695 | 5495695 | 20241106210457_EJZNv | CH0005 | 2024-11-08T14:10:38.503Z | 2024-11-12T14:25:57.371Z |
5495329 | 5495329 | 20241106192922_dLv5n | CH0005 | 2024-11-08T14:10:00.168Z | 2024-11-12T14:25:52.315Z |
5491720 | 5491720 | 20241106044152_ZBiCe | CH0005 | 2024-11-07T14:16:51.197Z | 2024-11-12T14:26:55.764Z |
5491398 | 5491398 | 20241106031156_KzfrX | CH0005 | 2024-11-07T14:16:03.391Z | 2024-11-12T14:26:54.094Z |
5491028 | 5491028 | 20241106014016_e5Fv8 | CH0005 | 2024-11-07T14:15:13.801Z | 2024-11-12T14:26:52.621Z |
5491007 | 5491007 | 20241106013409_oobQn | CH0005 | 2024-11-07T14:15:11.926Z | 2024-11-12T14:26:52.543Z |
5490862 | 5490862 | 20241106005830_tw27r | CH0005 | 2024-11-07T14:15:00.675Z | 2024-11-12T14:26:51.611Z |
5490680 | 5490680 | 20241106000623_xi9rU | CH0005 | 2024-11-07T14:14:29.781Z | 2024-11-12T14:26:50.574Z |
5490584 | 5490584 | 20241105233036_8rFxn | CH0005 | 2024-11-07T14:14:15.033Z | 2024-11-12T14:26:49.759Z |
5490150 | 5490150 | 20241105212334_2OQzF | CH0005 | 2024-11-07T14:13:20.559Z | 2024-11-12T14:26:46.693Z |
5490145 | 5490145 | 20241105212034_CqgDU | CH0005 | 2024-11-07T14:13:19.799Z | 2024-11-12T14:26:46.656Z |
5490131 | 5490131 | 20241105211529_ceooc | CH0005 | 2024-11-07T14:13:16.781Z | 2024-11-12T14:26:46.596Z |
5490123 | 5490123 | 20241105211208_B5tSF | CH0005 | 2024-11-07T14:13:15.362Z | 2024-11-12T14:26:46.447Z |
5489396 | 5489396 | 20241105184338_Ib12o | CH0005 | 2024-11-07T14:11:58.418Z | 2024-11-12T14:26:42.571Z |
5463704 | 5463704 | 20241102044145_SU2jZ | CH0005 | 2024-11-03T14:19:11.095Z | 2024-11-10T14:26:36.429Z |
5463598 | 5463598 | 20241102041628_P2MBG | CH0005 | 2024-11-03T14:19:00.934Z | 2024-11-10T14:26:35.654Z |
5463503 | 5463503 | 20241102034739_R2oFZ | CH0005 | 2024-11-03T14:18:51.353Z | 2024-11-10T14:26:35.384Z |
5463499 | 5463499 | 20241102034731_UIulo | CH0005 | 2024-11-03T14:18:51.051Z | 2024-11-10T14:26:35.383Z |
5463450 | 5463450 | 20241102034017_Ak83V | CH0005 | 2024-11-03T14:18:46.097Z | 2024-11-10T14:26:35.310Z |
5463431 | 5463431 | 20241102033731_FkII0 | CH0005 | 2024-11-03T14:18:45.159Z | 2024-11-10T14:26:35.216Z |
5463394 | 5463394 | 20241102033131_8kFeO | CH0005 | 2024-11-03T14:18:41.315Z | 2024-11-10T14:26:35.080Z |
5463386 | 5463386 | 20241102033104_wOW3U | CH0005 | 2024-11-03T14:18:41.047Z | 2024-11-10T14:26:35.074Z |
5463377 | 5463377 | 20241102033009_lc5GH | CH0005 | 2024-11-03T14:18:40.661Z | 2024-11-10T14:26:35.046Z |
5463376 | 5463376 | 20241102032954_kBv9C | CH0005 | 2024-11-03T14:18:40.240Z | 2024-11-10T14:26:35.045Z |
5463203 | 5463203 | 20241102025259_G2KJZ | CH0005 | 2024-11-03T14:18:26.237Z | 2024-11-10T14:26:34.519Z |
5463176 | 5463176 | 20241102024704_SWlC9 | CH0005 | 2024-11-03T14:18:25.243Z | 2024-11-10T14:26:34.449Z |
5463110 | 5463110 | 20241102023609_0arhK | CH0005 | 2024-11-03T14:18:19.489Z | 2024-11-10T14:26:34.271Z |
5463094 | 5463094 | 20241102023325_DpUzy | CH0005 | 2024-11-03T14:18:17.967Z | 2024-11-10T14:26:34.261Z |
5463067 | 5463067 | 20241102022926_JbEiY | CH0005 | 2024-11-03T14:18:16.801Z | 2024-11-10T14:26:34.192Z |
5462925 | 5462925 | 20241102015712_AeiRJ | CH0005 | 2024-11-03T14:18:10.059Z | 2024-11-10T14:26:33.730Z |
5462581 | 5462581 | 20241102004736_XMGAW | CH0005 | 2024-11-03T14:17:44.418Z | 2024-11-10T14:26:32.932Z |
5462470 | 5462470 | 20241102002452_amsV5 | CH0005 | 2024-11-03T14:17:28.428Z | 2024-11-10T14:26:32.594Z |
5462446 | 5462446 | 20241102002156_3L5K7 | CH0005 | 2024-11-03T14:17:26.691Z | 2024-11-10T14:26:32.533Z |
5462419 | 5462419 | 20241102001536_5vjW3 | CH0005 | 2024-11-03T14:17:25.228Z | 2024-11-10T14:26:32.475Z |
5462263 | 5462263 | 20241101233454_ct25I | CH0005 | 2024-11-03T14:17:06.792Z | 2024-11-10T14:26:32.066Z |
5462256 | 5462256 | 20241101233226_XPPFH | CH0005 | 2024-11-03T14:17:06.328Z | 2024-11-10T14:26:32.042Z |
5461955 | 5461955 | 20241101222338_ts7Nj | CH0005 | 2024-11-03T14:16:49.016Z | 2024-11-10T14:26:31.084Z |
5461936 | 5461936 | 20241101221810_O6A9b | CH0005 | 2024-11-03T14:16:47.797Z | 2024-11-10T14:26:30.981Z |
5461602 | 5461602 | 20241101201225_Dw3lt | CH0005 | 2024-11-03T14:15:57.825Z | 2024-11-10T14:26:29.242Z |
5461354 | 5461354 | 20241101181442_uBL6K | CH0005 | 2024-11-03T14:15:16.495Z | 2024-11-10T14:26:28.226Z |
5461325 | 5461325 | 20241101175857_yWWP4 | CH0005 | 2024-11-03T14:15:10.329Z | 2024-11-10T14:26:28.119Z |
5443281 | 5443281 | 20241030043106_gWyom | CH0005 | 2024-11-01T12:20:26.444Z | 2024-11-07T14:26:50.531Z |
5442116 | 5442116 | 20241030003926_tc3MU | CH0005 | 2024-11-01T12:19:26.202Z | 2024-11-07T14:26:45.074Z |
5442112 | 5442112 | 20241030003747_OyKS3 | CH0005 | 2024-11-01T12:19:26.088Z | 2024-11-07T14:26:45.063Z |
5442022 | 5442022 | 20241030002058_2GK28 | CH0005 | 2024-11-01T12:19:19.926Z | 2024-11-07T14:26:44.747Z |
5441903 | 5441903 | 20241030000015_pYTF7 | CH0005 | 2024-11-01T12:19:11.803Z | 2024-11-07T14:26:44.301Z |
5441420 | 5441420 | 20241029220840_JaK4i | CH0005 | 2024-11-01T12:18:33.766Z | 2024-11-07T14:26:42.017Z |
5433641 | 5433641 | 20241029203602_OZaWO | CH0005 | 2024-10-31T12:22:25.475Z | 2024-11-07T14:26:40.470Z |
5433366 | 5433366 | 20241029192524_RTvKa | CH0005 | 2024-10-31T12:22:10.728Z | 2024-11-07T14:26:38.749Z |
5433195 | 5433195 | 20241029180858_KPhgN | CH0005 | 2024-10-31T12:21:56.551Z | 2024-11-07T14:26:36.333Z |
5433160 | 5433160 | 20241029174610_zhqNK | CH0005 | 2024-10-31T12:21:53.494Z | 2024-11-07T14:26:35.831Z |
5432816 | 5432816 | 20241029044635_X1Qpg | CH0005 | 2024-10-31T12:21:35.986Z | 2024-11-06T14:27:28.806Z |
5432801 | 5432801 | 20241029044139_q0Mft | CH0005 | 2024-10-31T12:21:35.595Z | 2024-11-06T14:27:28.755Z |
5432795 | 5432795 | 20241029044053_PgJmh | CH0005 | 2024-10-31T12:21:35.352Z | 2024-11-06T14:27:28.738Z |
5432789 | 5432789 | 20241029043949_K75IM | CH0005 | 2024-10-31T12:21:35.197Z | 2024-11-06T14:27:28.713Z |
5432725 | 5432725 | 20241029042656_F94Qq | CH0005 | 2024-10-31T12:21:32.716Z | 2024-11-06T14:27:28.571Z |
5432670 | 5432670 | 20241029041308_a02Df | CH0005 | 2024-10-31T12:21:30.697Z | 2024-11-06T14:27:28.356Z |
5432664 | 5432664 | 20241029041238_MTNhW | CH0005 | 2024-10-31T12:21:30.500Z | 2024-11-06T14:27:28.325Z |
5432410 | 5432410 | 20241029032915_l6qc1 | CH0005 | 2024-10-31T12:21:21.374Z | 2024-11-06T14:27:26.980Z |
5432314 | 5432314 | 20241029031303_td1rF | CH0005 | 2024-10-31T12:21:17.568Z | 2024-11-06T14:27:26.646Z |
5432236 | 5432236 | 20241029025852_olpi3 | CH0005 | 2024-10-31T12:21:14.655Z | 2024-11-06T14:27:26.332Z |
5432226 | 5432226 | 20241029025756_ziZbQ | CH0005 | 2024-10-31T12:21:14.052Z | 2024-11-06T14:27:26.308Z |
5432222 | 5432222 | 20241029025707_VnyqP | CH0005 | 2024-10-31T12:21:13.807Z | 2024-11-06T14:27:26.304Z |
5432180 | 5432180 | 20241029025241_rEhsX | CH0005 | 2024-10-31T12:21:10.350Z | 2024-11-06T14:27:26.186Z |
5432153 | 5432153 | 20241029024855_hjk7y | CH0005 | 2024-10-31T12:21:07.504Z | 2024-11-06T14:27:26.122Z |
5432139 | 5432139 | 20241029024751_qVoHO | CH0005 | 2024-10-31T12:21:05.702Z | 2024-11-06T14:27:26.054Z |
5432080 | 5432080 | 20241029024032_ZLZlU | CH0005 | 2024-10-31T12:21:01.661Z | 2024-11-06T14:27:25.889Z |
5432067 | 5432067 | 20241029023836_A4cMq | CH0005 | 2024-10-31T12:20:59.931Z | 2024-11-06T14:27:25.852Z |
5432034 | 5432034 | 20241029023348_MGYLc | CH0005 | 2024-10-31T12:20:57.139Z | 2024-11-06T14:27:25.712Z |
5431968 | 5431968 | 20241029022431_0M71i | CH0005 | 2024-10-31T12:20:54.133Z | 2024-11-06T14:27:25.628Z |
5431948 | 5431948 | 20241029022111_SsbBK | CH0005 | 2024-10-31T12:20:52.106Z | 2024-11-06T14:27:25.594Z |
5431891 | 5431891 | 20241029021258_21SUz | CH0005 | 2024-10-31T12:20:47.270Z | 2024-11-06T14:27:25.191Z |
5431839 | 5431839 | 20241029020437_AS49x | CH0005 | 2024-10-31T12:20:43.189Z | 2024-11-06T14:27:25.038Z |
5431688 | 5431688 | 20241029014807_ZkKeN | CH0005 | 2024-10-31T12:20:32.603Z | 2024-11-06T14:27:24.432Z |
5431672 | 5431672 | 20241029014516_jkjkD | CH0005 | 2024-10-31T12:20:31.258Z | 2024-11-06T14:27:24.416Z |
5431522 | 5431522 | 20241029012350_X0486 | CH0005 | 2024-10-31T12:20:18.081Z | 2024-11-06T14:27:23.983Z |
5431482 | 5431482 | 20241029011909_BRLDD | CH0005 | 2024-10-31T12:20:12.877Z | 2024-11-06T14:27:23.893Z |
5431413 | 5431413 | 20241029010757_FCoxK | CH0005 | 2024-10-31T12:20:06.332Z | 2024-11-06T14:27:23.526Z |
5431323 | 5431323 | 20241029005547_23HoF | CH0005 | 2024-10-31T12:19:54.942Z | 2024-11-06T14:27:23.281Z |
5431174 | 5431174 | 20241029003843_5Bp99 | CH0005 | 2024-10-31T12:19:42.790Z | 2024-11-06T14:27:22.908Z |
5430976 | 5430976 | 20241029001134_j3XWb | CH0005 | 2024-10-31T12:19:23.972Z | 2024-11-06T14:27:22.388Z |
5430938 | 5430938 | 20241029000554_8DU57 | CH0005 | 2024-10-31T12:19:19.986Z | 2024-11-06T14:27:22.286Z |
5430935 | 5430935 | 20241029000541_yldaD | CH0005 | 2024-10-31T12:19:19.511Z | 2024-11-06T14:27:22.283Z |
5430869 | 5430869 | 20241028235427_lxh1w | CH0005 | 2024-10-31T12:19:12.348Z | 2024-11-06T14:27:21.942Z |
5430799 | 5430799 | 20241028234020_M2Wni | CH0005 | 2024-10-31T12:19:03.776Z | 2024-11-06T14:27:21.604Z |
5430511 | 5430511 | 20241028224928_LDsBn | CH0005 | 2024-10-31T12:18:30.114Z | 2024-11-06T14:27:20.283Z |
5430452 | 5430452 | 20241028223843_xd1Ne | CH0005 | 2024-10-31T12:18:24.588Z | 2024-11-06T14:27:20.211Z |
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);