participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,627 rows where station_code = "HR000J" 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 |
---|---|---|---|---|---|
5524450 | 5524450 | 20241111041540_l1XAS | HR000J | 2024-11-12T14:17:22.361Z | 2024-11-12T14:18:08.629Z |
5524417 | 5524417 | 20241111040942_5k29g | HR000J | 2024-11-12T14:17:17.038Z | 2024-11-12T14:18:08.611Z |
5524389 | 5524389 | 20241111040716_Ss3u7 | HR000J | 2024-11-12T14:17:14.695Z | 2024-11-12T14:18:08.597Z |
5524350 | 5524350 | 20241111035931_aYpxI | HR000J | 2024-11-12T14:17:05.956Z | 2024-11-12T14:18:08.576Z |
5523931 | 5523931 | 20241111025020_5lHjj | HR000J | 2024-11-12T14:16:21.185Z | 2024-11-12T14:18:08.403Z |
5523843 | 5523843 | 20241111023419_9Za9q | HR000J | 2024-11-12T14:16:16.706Z | 2024-11-12T14:18:08.368Z |
5523534 | 5523534 | 20241111014059_CdPBs | HR000J | 2024-11-12T14:15:53.895Z | 2024-11-12T14:18:08.236Z |
5523439 | 5523439 | 20241111012550_wjqhu | HR000J | 2024-11-12T14:15:37.105Z | 2024-11-12T14:18:08.195Z |
5523404 | 5523404 | 20241111011844_AbbA3 | HR000J | 2024-11-12T14:15:33.101Z | 2024-11-12T14:18:08.180Z |
5523397 | 5523397 | 20241111011705_1cpn1 | HR000J | 2024-11-12T14:15:31.729Z | 2024-11-12T14:18:08.175Z |
5523272 | 5523272 | 20241111005119_kQfGM | HR000J | 2024-11-12T14:15:12.347Z | 2024-11-12T14:18:08.119Z |
5523117 | 5523117 | 20241111000617_7360Y | HR000J | 2024-11-12T14:14:46.308Z | 2024-11-12T14:18:08.037Z |
5523093 | 5523093 | 20241110235943_OdM51 | HR000J | 2024-11-12T14:14:45.121Z | 2024-11-12T14:18:08.028Z |
5522947 | 5522947 | 20241110231534_0NifO | HR000J | 2024-11-12T14:14:32.939Z | 2024-11-12T14:18:07.969Z |
5522933 | 5522933 | 20241110230635_sWATN | HR000J | 2024-11-12T14:14:31.645Z | 2024-11-12T14:18:07.962Z |
5522924 | 5522924 | 20241110230039_nH3Mb | HR000J | 2024-11-12T14:14:30.281Z | 2024-11-12T14:18:07.958Z |
5522888 | 5522888 | 20241110224101_hInw6 | HR000J | 2024-11-12T14:14:27.083Z | 2024-11-12T14:18:07.941Z |
5517673 | 5517673 | 20241110042524_kKJhf | HR000J | 2024-11-11T14:14:43.861Z | 2024-11-12T14:21:51.532Z |
5517541 | 5517541 | 20241110040040_YWrrc | HR000J | 2024-11-11T14:14:33.741Z | 2024-11-12T14:21:46.100Z |
5517524 | 5517524 | 20241110035723_PPdhZ | HR000J | 2024-11-11T14:14:32.420Z | 2024-11-12T14:21:45.122Z |
5517409 | 5517409 | 20241110033936_Cv4JQ | HR000J | 2024-11-11T14:14:22.498Z | 2024-11-12T14:21:41.024Z |
5517323 | 5517323 | 20241110032600_5tZ9S | HR000J | 2024-11-11T14:14:14.438Z | 2024-11-12T14:21:37.861Z |
5517270 | 5517270 | 20241110031651_XVJxa | HR000J | 2024-11-11T14:14:11.456Z | 2024-11-12T14:21:36.702Z |
5517079 | 5517079 | 20241110024457_UyzPs | HR000J | 2024-11-11T14:13:51.236Z | 2024-11-12T14:21:31.117Z |
5516898 | 5516898 | 20241110021737_j6uYn | HR000J | 2024-11-11T14:13:30.331Z | 2024-11-12T14:21:23.336Z |
5516547 | 5516547 | 20241110011748_9k2LR | HR000J | 2024-11-11T14:13:07.909Z | 2024-11-12T14:21:10.982Z |
5516480 | 5516480 | 20241110010540_1mr1F | HR000J | 2024-11-11T14:13:03.763Z | 2024-11-12T14:21:07.078Z |
5516435 | 5516435 | 20241110005927_0PrCt | HR000J | 2024-11-11T14:13:01.133Z | 2024-11-12T14:21:05.150Z |
5516013 | 5516013 | 20241109233434_L8hLj | HR000J | 2024-11-11T14:11:59.407Z | 2024-11-12T14:20:47.192Z |
5515944 | 5515944 | 20241109231649_OZUJe | HR000J | 2024-11-11T14:11:49.308Z | 2024-11-12T14:20:44.319Z |
5515681 | 5515681 | 20241109222244_2mzU0 | HR000J | 2024-11-11T14:11:21.516Z | 2024-11-12T14:20:33.300Z |
5515593 | 5515593 | 20241109220553_f5ePu | HR000J | 2024-11-11T14:11:15.891Z | 2024-11-12T14:20:28.762Z |
5511086 | 5511086 | 20241109042342_8DSRT | HR000J | 2024-11-10T14:16:13.703Z | 2024-11-12T14:23:44.707Z |
5511075 | 5511075 | 20241109041937_S7YDy | HR000J | 2024-11-10T14:16:11.590Z | 2024-11-12T14:23:44.547Z |
5510851 | 5510851 | 20241109034434_AKpz5 | HR000J | 2024-11-10T14:15:46.379Z | 2024-11-12T14:23:41.645Z |
5510793 | 5510793 | 20241109033708_RUb2d | HR000J | 2024-11-10T14:15:43.259Z | 2024-11-12T14:23:40.929Z |
5510349 | 5510349 | 20241109022505_h9L3P | HR000J | 2024-11-10T14:15:04.137Z | 2024-11-12T14:23:34.853Z |
5510255 | 5510255 | 20241109020637_PxeHF | HR000J | 2024-11-10T14:14:52.098Z | 2024-11-12T14:23:32.701Z |
5510163 | 5510163 | 20241109015227_N8aqI | HR000J | 2024-11-10T14:14:41.616Z | 2024-11-12T14:23:31.357Z |
5509994 | 5509994 | 20241109012442_w3s4i | HR000J | 2024-11-10T14:14:24.892Z | 2024-11-12T14:23:28.670Z |
5509910 | 5509910 | 20241109010648_LCEkO | HR000J | 2024-11-10T14:14:13.924Z | 2024-11-12T14:23:27.400Z |
5509758 | 5509758 | 20241109002911_6Md3q | HR000J | 2024-11-10T14:13:57.279Z | 2024-11-12T14:23:24.536Z |
5509742 | 5509742 | 20241109002552_MVvX4 | HR000J | 2024-11-10T14:13:55.775Z | 2024-11-12T14:23:24.335Z |
5509716 | 5509716 | 20241109001836_15sfI | HR000J | 2024-11-10T14:13:53.489Z | 2024-11-12T14:23:24.060Z |
5509509 | 5509509 | 20241108233443_2t9uT | HR000J | 2024-11-10T14:13:29.227Z | 2024-11-12T14:23:20.977Z |
5509365 | 5509365 | 20241108225656_w2a2u | HR000J | 2024-11-10T14:13:16.064Z | 2024-11-12T14:23:17.655Z |
5509340 | 5509340 | 20241108225349_dYGRG | HR000J | 2024-11-10T14:13:13.582Z | 2024-11-12T14:23:17.313Z |
5509234 | 5509234 | 20241108223231_FtiRO | HR000J | 2024-11-10T14:12:59.990Z | 2024-11-12T14:23:15.710Z |
5509170 | 5509170 | 20241108221345_VIWAo | HR000J | 2024-11-10T14:12:47.916Z | 2024-11-12T14:23:14.294Z |
5504660 | 5504660 | 20241108023556_cM33o | HR000J | 2024-11-09T14:15:02.054Z | 2024-11-12T14:25:06.233Z |
5503823 | 5503823 | 20241107235517_8Hqrt | HR000J | 2024-11-09T14:13:46.356Z | 2024-11-12T14:24:53.194Z |
5503651 | 5503651 | 20241107231531_fjKLB | HR000J | 2024-11-09T14:13:29.243Z | 2024-11-12T14:24:50.345Z |
5502857 | 5502857 | 20241107195921_ClSrm | HR000J | 2024-11-09T14:12:08.601Z | 2024-11-12T14:24:40.306Z |
5502745 | 5502745 | 20241107194030_626mL | HR000J | 2024-11-09T14:12:01.199Z | 2024-11-12T14:24:38.511Z |
5502541 | 5502541 | 20241107190003_aO9ss | HR000J | 2024-11-09T14:11:42.262Z | 2024-11-12T14:24:36.882Z |
5497697 | 5497697 | 20241107043434_EQlvT | HR000J | 2024-11-08T14:14:13.009Z | 2024-11-12T14:26:13.813Z |
5497677 | 5497677 | 20241107042639_3QpXR | HR000J | 2024-11-08T14:14:10.177Z | 2024-11-12T14:26:13.764Z |
5497661 | 5497661 | 20241107042141_dQ3An | HR000J | 2024-11-08T14:14:09.235Z | 2024-11-12T14:26:13.688Z |
5497601 | 5497601 | 20241107041026_3IVUc | HR000J | 2024-11-08T14:14:02.218Z | 2024-11-12T14:26:13.183Z |
5497249 | 5497249 | 20241107030534_PBKgH | HR000J | 2024-11-08T14:13:26.524Z | 2024-11-12T14:26:10.259Z |
5496416 | 5496416 | 20241107002003_Pq6Zg | HR000J | 2024-11-08T14:12:08.026Z | 2024-11-12T14:26:04.005Z |
5496411 | 5496411 | 20241107001927_2geSb | HR000J | 2024-11-08T14:12:07.551Z | 2024-11-12T14:26:03.995Z |
5496288 | 5496288 | 20241106234750_ns3a7 | HR000J | 2024-11-08T14:11:54.527Z | 2024-11-12T14:26:03.105Z |
5496252 | 5496252 | 20241106234010_M6NPu | HR000J | 2024-11-08T14:11:51.674Z | 2024-11-12T14:26:02.927Z |
5496244 | 5496244 | 20241106233707_zhAxK | HR000J | 2024-11-08T14:11:50.937Z | 2024-11-12T14:26:02.902Z |
5496087 | 5496087 | 20241106225343_uoMve | HR000J | 2024-11-08T14:11:31.251Z | 2024-11-12T14:26:01.372Z |
5496069 | 5496069 | 20241106225126_TcTxG | HR000J | 2024-11-08T14:11:29.820Z | 2024-11-12T14:26:01.221Z |
5496000 | 5496000 | 20241106223355_w2cP7 | HR000J | 2024-11-08T14:11:20.525Z | 2024-11-12T14:26:00.524Z |
5495903 | 5495903 | 20241106220100_VdYYl | HR000J | 2024-11-08T14:11:05.524Z | 2024-11-12T14:25:59.785Z |
5495053 | 5495053 | 20241106182728_v6RHu | HR000J | 2024-11-08T14:09:09.761Z | 2024-11-12T14:25:48.092Z |
5494985 | 5494985 | 20241106180619_6gWay | HR000J | 2024-11-08T14:08:55.384Z | 2024-11-12T14:25:47.295Z |
5491010 | 5491010 | 20241106013505_qg0Ss | HR000J | 2024-11-07T14:15:12.229Z | 2024-11-12T14:26:52.546Z |
5490936 | 5490936 | 20241106011947_knwft | HR000J | 2024-11-07T14:15:06.095Z | 2024-11-12T14:26:52.014Z |
5490683 | 5490683 | 20241106000913_PXFB0 | HR000J | 2024-11-07T14:14:31.330Z | 2024-11-12T14:26:50.592Z |
5490275 | 5490275 | 20241105215927_CIsKH | HR000J | 2024-11-07T14:13:47.816Z | 2024-11-12T14:26:47.602Z |
5489736 | 5489736 | 20241105195423_5l4TS | HR000J | 2024-11-07T14:12:42.189Z | 2024-11-12T14:26:44.845Z |
5485119 | 5485119 | 20241105040651_8rNwv | HR000J | 2024-11-06T14:17:47.213Z | 2024-11-12T14:27:36.746Z |
5484510 | 5484510 | 20241105025931_ClJOv | HR000J | 2024-11-06T14:16:58.940Z | 2024-11-12T14:27:34.510Z |
5484433 | 5484433 | 20241105024915_MNRcb | HR000J | 2024-11-06T14:16:54.369Z | 2024-11-12T14:27:33.860Z |
5484430 | 5484430 | 20241105024853_1Ofx6 | HR000J | 2024-11-06T14:16:53.963Z | 2024-11-12T14:27:33.819Z |
5484388 | 5484388 | 20241105024149_3lYK0 | HR000J | 2024-11-06T14:16:52.112Z | 2024-11-12T14:27:33.660Z |
5484361 | 5484361 | 20241105024021_GsSCT | HR000J | 2024-11-06T14:16:50.814Z | 2024-11-12T14:27:33.604Z |
5484335 | 5484335 | 20241105023605_aknqA | HR000J | 2024-11-06T14:16:49.190Z | 2024-11-12T14:27:33.520Z |
5484276 | 5484276 | 20241105023014_A5Tob | HR000J | 2024-11-06T14:16:42.484Z | 2024-11-12T14:27:32.964Z |
5484205 | 5484205 | 20241105022033_Se7Q2 | HR000J | 2024-11-06T14:16:32.100Z | 2024-11-12T14:27:32.713Z |
5484137 | 5484137 | 20241105021419_Txp18 | HR000J | 2024-11-06T14:16:21.488Z | 2024-11-12T14:27:32.162Z |
5483848 | 5483848 | 20241105013833_eyISZ | HR000J | 2024-11-06T14:15:46.057Z | 2024-11-12T14:27:30.401Z |
5483796 | 5483796 | 20241105013130_Oc39m | HR000J | 2024-11-06T14:15:43.304Z | 2024-11-12T14:27:30.237Z |
5483674 | 5483674 | 20241105011759_E2tL1 | HR000J | 2024-11-06T14:15:35.103Z | 2024-11-12T14:27:29.704Z |
5483426 | 5483426 | 20241105003928_v1IH8 | HR000J | 2024-11-06T14:15:15.930Z | 2024-11-12T14:27:28.098Z |
5483245 | 5483245 | 20241105001820_o4L3o | HR000J | 2024-11-06T14:14:49.507Z | 2024-11-12T14:27:27.373Z |
5482998 | 5482998 | 20241104234639_jpmc4 | HR000J | 2024-11-06T14:14:33.980Z | 2024-11-12T14:27:25.147Z |
5482888 | 5482888 | 20241104233015_z9HO5 | HR000J | 2024-11-06T14:14:16.058Z | 2024-11-12T14:27:24.501Z |
5482730 | 5482730 | 20241104230902_UM6m9 | HR000J | 2024-11-06T14:13:46.107Z | 2024-11-12T14:27:23.962Z |
5482643 | 5482643 | 20241104225319_0gYDY | HR000J | 2024-11-06T14:13:29.789Z | 2024-11-12T14:27:23.525Z |
5482542 | 5482542 | 20241104223833_MwS7P | HR000J | 2024-11-06T14:13:20.192Z | 2024-11-12T14:27:22.921Z |
5482526 | 5482526 | 20241104223444_wpsEj | HR000J | 2024-11-06T14:13:18.599Z | 2024-11-12T14:27:22.882Z |
5482497 | 5482497 | 20241104223223_MBiw6 | HR000J | 2024-11-06T14:13:16.502Z | 2024-11-12T14:27:22.705Z |
5482429 | 5482429 | 20241104221141_YwK7Q | HR000J | 2024-11-06T14:13:10.556Z | 2024-11-12T14:27:22.463Z |
5482378 | 5482378 | 20241104220122_zCakc | HR000J | 2024-11-06T14:13:06.360Z | 2024-11-12T14:27:22.317Z |
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);