participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,702 rows where station_code = "SI0005" 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 |
|---|---|---|---|---|---|
| 9584451 | 9584451 | 20260325195331_xys3k | SI0005 | 2026-03-27T12:15:20.337Z | 2026-04-03T12:39:14.404Z |
| 9580005 | 9580005 | 20260324234738_3NA4i | SI0005 | 2026-03-26T12:14:52.356Z | 2026-04-02T12:37:38.757Z |
| 9579996 | 9579996 | 20260324234555_DRRaI | SI0005 | 2026-03-26T12:14:50.656Z | 2026-04-02T12:37:38.334Z |
| 9579402 | 9579402 | 20260324200007_Vx4dW | SI0005 | 2026-03-26T12:13:34.555Z | 2026-04-02T12:37:08.209Z |
| 9576599 | 9576599 | 20260325023818_bqkmS | SI0005 | 2026-03-26T12:02:44.934Z | 2026-04-03T12:36:14.015Z |
| 9576292 | 9576292 | 20260325014843_oqSpl | SI0005 | 2026-03-26T12:01:50.953Z | 2026-04-03T12:35:52.011Z |
| 9576025 | 9576025 | 20260325010036_sUZ3e | SI0005 | 2026-03-26T12:01:01.187Z | 2026-04-03T12:35:41.333Z |
| 9575869 | 9575869 | 20260325003107_FujIc | SI0005 | 2026-03-26T12:00:29.724Z | 2026-04-03T12:35:27.205Z |
| 9575635 | 9575635 | 20260323235926_mskpm | SI0005 | 2026-03-25T12:21:33.629Z | 2026-03-31T12:29:03.658Z |
| 9575572 | 9575572 | 20260323232333_a416n | SI0005 | 2026-03-25T12:21:25.500Z | 2026-03-31T12:29:02.109Z |
| 9575482 | 9575482 | 20260323224506_CH1pt | SI0005 | 2026-03-25T12:21:14.569Z | 2026-03-31T12:28:59.366Z |
| 9571746 | 9571746 | 20260324035304_dPQA6 | SI0005 | 2026-03-25T12:02:32.805Z | 2026-04-02T12:34:42.178Z |
| 9571664 | 9571664 | 20260324032613_i02kY | SI0005 | 2026-03-25T12:02:15.498Z | 2026-04-02T12:34:36.978Z |
| 9571618 | 9571618 | 20260324031425_HXiOw | SI0005 | 2026-03-25T12:02:07.406Z | 2026-04-02T12:34:34.895Z |
| 9571598 | 9571598 | 20260324030812_a12NY | SI0005 | 2026-03-25T12:02:02.487Z | 2026-04-02T12:34:33.715Z |
| 9571564 | 9571564 | 20260324025541_Dbeed | SI0005 | 2026-03-25T12:01:56.276Z | 2026-04-02T12:34:32.113Z |
| 9571483 | 9571483 | 20260324023024_qQKuV | SI0005 | 2026-03-25T12:01:40.227Z | 2026-04-02T12:34:28.762Z |
| 9571456 | 9571456 | 20260324021933_QQft3 | SI0005 | 2026-03-25T12:01:32.942Z | 2026-04-02T12:34:27.486Z |
| 9571430 | 9571430 | 20260324020336_GyPZz | SI0005 | 2026-03-25T12:01:25.877Z | 2026-04-02T12:34:26.126Z |
| 9571380 | 9571380 | 20260324014226_emJQc | SI0005 | 2026-03-25T12:01:15.336Z | 2026-04-02T12:34:23.773Z |
| 9571356 | 9571356 | 20260324013238_XieBN | SI0005 | 2026-03-25T12:01:10.535Z | 2026-04-02T12:34:22.640Z |
| 9571354 | 9571354 | 20260324013235_AckGm | SI0005 | 2026-03-25T12:01:10.022Z | 2026-04-02T12:34:22.541Z |
| 9571329 | 9571329 | 20260324011736_HYwXk | SI0005 | 2026-03-25T12:01:03.614Z | 2026-04-02T12:34:20.373Z |
| 9571268 | 9571268 | 20260324004818_aTrn1 | SI0005 | 2026-03-25T12:00:44.324Z | 2026-04-02T12:34:17.202Z |
| 9571246 | 9571246 | 20260324004608_0UmFi | SI0005 | 2026-03-25T12:00:39.351Z | 2026-04-02T12:34:16.496Z |
| 9570744 | 9570744 | 20260322223836_mbnHx | SI0005 | 2026-03-24T12:23:45.775Z | 2026-03-30T12:30:48.579Z |
| 9562904 | 9562904 | 20260323034225_WCdMi | SI0005 | 2026-03-24T12:04:23.728Z | 2026-03-31T12:26:28.908Z |
| 9561891 | 9561891 | 20260323005323_ZQS3a | SI0005 | 2026-03-24T12:01:32.106Z | 2026-03-31T12:25:55.776Z |
| 9561767 | 9561767 | 20260323003924_3qS3U | SI0005 | 2026-03-24T12:01:14.125Z | 2026-03-31T12:25:53.155Z |
| 9560356 | 9560356 | 20260321210507_uTTKQ | SI0005 | 2026-03-23T12:11:43.655Z | 2026-03-29T12:20:59.414Z |
| 9560280 | 9560280 | 20260321205717_GDJ0w | SI0005 | 2026-03-23T12:11:41.155Z | 2026-03-29T12:20:59.017Z |
| 9551886 | 9551886 | 20260320220518_Ez44c | SI0005 | 2026-03-22T12:27:15.575Z | 2026-03-28T12:37:03.607Z |
| 9551876 | 9551876 | 20260320220230_ar2N5 | SI0005 | 2026-03-22T12:27:14.911Z | 2026-03-28T12:37:03.528Z |
| 9551855 | 9551855 | 20260320215642_EYUeA | SI0005 | 2026-03-22T12:27:06.899Z | 2026-03-28T12:37:03.037Z |
| 9551753 | 9551753 | 20260320212108_b1Rh9 | SI0005 | 2026-03-22T12:27:00.728Z | 2026-03-28T12:37:01.584Z |
| 9551331 | 9551331 | 20260320192437_JXl75 | SI0005 | 2026-03-22T12:26:26.230Z | 2026-03-28T12:36:45.027Z |
| 9543028 | 9543028 | 20260321022042_iSClG | SI0005 | 2026-03-22T12:02:25.496Z | 2026-03-29T12:19:01.611Z |
| 9542504 | 9542504 | 20260320235509_PbQZL | SI0005 | 2026-03-22T12:00:29.774Z | 2026-03-29T12:18:44.840Z |
| 9542449 | 9542449 | 20260320234104_FaBbJ | SI0005 | 2026-03-22T12:00:17.279Z | 2026-03-29T12:18:44.194Z |
| 9542303 | 9542303 | 20260319230844_eTkGE | SI0005 | 2026-03-21T12:29:56.635Z | 2026-03-27T12:42:54.748Z |
| 9542048 | 9542048 | 20260319223912_iSUzP | SI0005 | 2026-03-21T12:29:37.565Z | 2026-03-27T12:42:44.604Z |
| 9542016 | 9542016 | 20260319222945_DJ22k | SI0005 | 2026-03-21T12:29:35.804Z | 2026-03-27T12:42:44.263Z |
| 9541957 | 9541957 | 20260319221345_Yue4m | SI0005 | 2026-03-21T12:29:31.319Z | 2026-03-27T12:42:43.280Z |
| 9541568 | 9541568 | 20260319210509_iS1v9 | SI0005 | 2026-03-21T12:29:11.106Z | 2026-03-27T12:42:38.862Z |
| 9541348 | 9541348 | 20260319201947_J9Mem | SI0005 | 2026-03-21T12:28:50.933Z | 2026-03-27T12:42:36.728Z |
| 9541206 | 9541206 | 20260319200142_YlIPt | SI0005 | 2026-03-21T12:28:44.075Z | 2026-03-27T12:42:35.477Z |
| 9534615 | 9534615 | 20260320040545_Isllr | SI0005 | 2026-03-21T12:08:27.559Z | 2026-03-28T12:34:20.092Z |
| 9534602 | 9534602 | 20260320040313_iNoY3 | SI0005 | 2026-03-21T12:08:23.417Z | 2026-03-28T12:34:19.786Z |
| 9534486 | 9534486 | 20260320035215_HKMnr | SI0005 | 2026-03-21T12:08:06.013Z | 2026-03-28T12:34:18.703Z |
| 9534203 | 9534203 | 20260320033539_3WxZX | SI0005 | 2026-03-21T12:07:26.231Z | 2026-03-28T12:34:16.049Z |
| 9534181 | 9534181 | 20260320033358_mx3Pz | SI0005 | 2026-03-21T12:07:22.320Z | 2026-03-28T12:34:15.515Z |
| 9534153 | 9534153 | 20260320033154_KZUue | SI0005 | 2026-03-21T12:07:17.328Z | 2026-03-28T12:34:14.998Z |
| 9533983 | 9533983 | 20260320031355_LSmJd | SI0005 | 2026-03-21T12:06:49.555Z | 2026-03-28T12:34:03.136Z |
| 9533838 | 9533838 | 20260320030535_R2q64 | SI0005 | 2026-03-21T12:06:26.834Z | 2026-03-28T12:34:01.395Z |
| 9533827 | 9533827 | 20260320030229_2SIiq | SI0005 | 2026-03-21T12:06:24.452Z | 2026-03-28T12:34:01.132Z |
| 9533796 | 9533796 | 20260320025834_drP3K | SI0005 | 2026-03-21T12:06:18.900Z | 2026-03-28T12:34:00.670Z |
| 9533745 | 9533745 | 20260320025405_8Q7tw | SI0005 | 2026-03-21T12:06:09.334Z | 2026-03-28T12:33:59.991Z |
| 9533712 | 9533712 | 20260320025232_UlRyM | SI0005 | 2026-03-21T12:06:05.615Z | 2026-03-28T12:33:58.978Z |
| 9533348 | 9533348 | 20260320022513_uMiul | SI0005 | 2026-03-21T12:05:13.285Z | 2026-03-28T12:33:52.189Z |
| 9533343 | 9533343 | 20260320022437_flYcR | SI0005 | 2026-03-21T12:05:11.936Z | 2026-03-28T12:33:52.131Z |
| 9533339 | 9533339 | 20260320022431_RM2Yu | SI0005 | 2026-03-21T12:05:11.378Z | 2026-03-28T12:33:52.110Z |
| 9532936 | 9532936 | 20260320013939_pIW8P | SI0005 | 2026-03-21T12:04:01.915Z | 2026-03-28T12:33:46.770Z |
| 9532875 | 9532875 | 20260320013521_3iKuE | SI0005 | 2026-03-21T12:03:51.820Z | 2026-03-28T12:33:45.701Z |
| 9532608 | 9532608 | 20260320011157_qlbcy | SI0005 | 2026-03-21T12:03:09.957Z | 2026-03-28T12:33:34.526Z |
| 9532400 | 9532400 | 20260320005133_WqPOb | SI0005 | 2026-03-21T12:02:35.890Z | 2026-03-28T12:33:29.648Z |
| 9532167 | 9532167 | 20260320002550_ZSBFe | SI0005 | 2026-03-21T12:01:53.055Z | 2026-03-28T12:33:25.122Z |
| 9531588 | 9531588 | 20260319232631_Hnh5V | SI0005 | 2026-03-21T12:00:18.619Z | 2026-03-28T12:33:18.960Z |
| 9529855 | 9529855 | 20260318193748_S7Os2 | SI0005 | 2026-03-20T12:23:46.533Z | 2026-03-26T12:39:07.043Z |
| 9521366 | 9521366 | 20260319040912_IOsFc | SI0005 | 2026-03-20T12:07:54.099Z | 2026-03-27T12:40:54.146Z |
| 9517055 | 9517055 | 20260317223129_HrYBh | SI0005 | 2026-03-19T12:27:08.290Z | 2026-03-25T12:43:08.341Z |
| 9517024 | 9517024 | 20260317222710_V2CTj | SI0005 | 2026-03-19T12:27:05.332Z | 2026-03-25T12:43:08.089Z |
| 9516980 | 9516980 | 20260317222148_3B8EU | SI0005 | 2026-03-19T12:27:03.390Z | 2026-03-25T12:43:07.912Z |
| 9516639 | 9516639 | 20260317212255_XgB9L | SI0005 | 2026-03-19T12:26:35.689Z | 2026-03-25T12:43:04.849Z |
| 9516534 | 9516534 | 20260317210748_PE5Y0 | SI0005 | 2026-03-19T12:26:22.893Z | 2026-03-25T12:43:01.396Z |
| 9516315 | 9516315 | 20260317203149_a83vC | SI0005 | 2026-03-19T12:26:00.782Z | 2026-03-25T12:42:53.772Z |
| 9515862 | 9515862 | 20260317190549_7oESN | SI0005 | 2026-03-19T12:25:09.257Z | 2026-03-25T12:42:40.378Z |
| 9515748 | 9515748 | 20260317182204_E4xwp | SI0005 | 2026-03-19T12:24:45.744Z | 2026-03-25T12:42:35.342Z |
| 9515727 | 9515727 | 20260317181041_Y4tKi | SI0005 | 2026-03-19T12:24:41.889Z | 2026-03-25T12:42:34.979Z |
| 9501621 | 9501621 | 20260315225336_462aQ | SI0005 | 2026-03-17T12:25:19.596Z | 2026-03-23T12:22:45.215Z |
| 9501517 | 9501517 | 20260315223209_CaN31 | SI0005 | 2026-03-17T12:25:11.403Z | 2026-03-23T12:22:44.742Z |
| 9501441 | 9501441 | 20260315222059_Ni3qC | SI0005 | 2026-03-17T12:25:01.708Z | 2026-03-23T12:22:44.443Z |
| 9501155 | 9501155 | 20260315212003_PeEOw | SI0005 | 2026-03-17T12:24:32.809Z | 2026-03-23T12:22:43.405Z |
| 9501096 | 9501096 | 20260315205559_i12UJ | SI0005 | 2026-03-17T12:24:24.583Z | 2026-03-23T12:22:43.021Z |
| 9494751 | 9494751 | 20260316025221_3o28E | SI0005 | 2026-03-17T12:04:49.193Z | 2026-03-24T12:40:49.672Z |
| 9494747 | 9494747 | 20260316025221_yh3sS | SI0005 | 2026-03-17T12:04:48.784Z | 2026-03-24T12:40:49.632Z |
| 9494601 | 9494601 | 20260316023349_otg28 | SI0005 | 2026-03-17T12:04:20.166Z | 2026-03-24T12:40:48.644Z |
| 9494586 | 9494586 | 20260316023121_PsTRY | SI0005 | 2026-03-17T12:04:17.805Z | 2026-03-24T12:40:48.458Z |
| 9494582 | 9494582 | 20260316022952_2Kmqb | SI0005 | 2026-03-17T12:04:17.281Z | 2026-03-24T12:40:48.431Z |
| 9494290 | 9494290 | 20260316015119_sfEpn | SI0005 | 2026-03-17T12:03:32.561Z | 2026-03-24T12:40:46.582Z |
| 9494208 | 9494208 | 20260316014115_NYzhS | SI0005 | 2026-03-17T12:03:20.388Z | 2026-03-24T12:40:45.202Z |
| 9494143 | 9494143 | 20260316013053_lsFdJ | SI0005 | 2026-03-17T12:03:04.570Z | 2026-03-24T12:40:44.682Z |
| 9493598 | 9493598 | 20260316000456_W328z | SI0005 | 2026-03-17T12:01:28.534Z | 2026-03-24T12:40:40.960Z |
| 9493417 | 9493417 | 20260315232827_9VoI1 | SI0005 | 2026-03-17T12:00:48.379Z | 2026-03-24T12:40:39.560Z |
| 9483546 | 9483546 | 20260313224217_ieBFP | SI0005 | 2026-03-15T12:26:39.367Z | 2026-03-21T12:50:28.380Z |
| 9483503 | 9483503 | 20260313222540_Hv2aP | SI0005 | 2026-03-15T12:26:36.390Z | 2026-03-21T12:50:28.148Z |
| 9483217 | 9483217 | 20260313211144_N3mub | SI0005 | 2026-03-15T12:26:06.682Z | 2026-03-21T12:50:24.368Z |
| 9482983 | 9482983 | 20260313200613_QX6VN | SI0005 | 2026-03-15T12:25:41.140Z | 2026-03-21T12:50:14.179Z |
| 9482897 | 9482897 | 20260313194125_js7RX | SI0005 | 2026-03-15T12:25:29.749Z | 2026-03-21T12:50:08.117Z |
| 9482862 | 9482862 | 20260313192958_yDCvw | SI0005 | 2026-03-15T12:25:22.691Z | 2026-03-21T12:50:04.694Z |
| 9476826 | 9476826 | 20260314034319_Cy31s | SI0005 | 2026-03-15T12:06:57.673Z | 2026-03-22T12:41:59.487Z |
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);