participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
425 rows where station_code = "GR0008" 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 |
---|---|---|---|---|---|
5469493 | 5469493 | 20241103033622_2OP2G | GR0008 | 2024-11-04T14:16:31.889Z | 2024-11-05T14:21:47.802Z |
5469462 | 5469462 | 20241103033130_garin | GR0008 | 2024-11-04T14:16:29.694Z | 2024-11-05T14:21:46.621Z |
5469078 | 5469078 | 20241103023134_V8YDG | GR0008 | 2024-11-04T14:15:34.293Z | 2024-11-05T14:21:38.955Z |
5468232 | 5468232 | 20241102235447_h3ydf | GR0008 | 2024-11-04T14:13:47.832Z | 2024-11-05T14:21:20.630Z |
5468124 | 5468124 | 20241102233443_RodWD | GR0008 | 2024-11-04T14:13:18.977Z | 2024-11-05T14:21:18.165Z |
5467907 | 5467907 | 20241102225540_ghgrc | GR0008 | 2024-11-04T14:12:56.658Z | 2024-11-05T14:21:11.441Z |
5467857 | 5467857 | 20241102224725_E3tUK | GR0008 | 2024-11-04T14:12:43.090Z | 2024-11-05T14:21:10.521Z |
5467351 | 5467351 | 20241102205005_10yao | GR0008 | 2024-11-04T14:11:20.652Z | 2024-11-05T14:21:03.886Z |
5467222 | 5467222 | 20241102202507_GTL09 | GR0008 | 2024-11-04T14:11:07.218Z | 2024-11-05T14:21:00.267Z |
5466316 | 5466316 | 20241102171004_yGfa2 | GR0008 | 2024-11-04T14:08:36.303Z | 2024-11-05T14:20:43.849Z |
5463341 | 5463341 | 20241102032255_UdPrF | GR0008 | 2024-11-03T14:18:36.281Z | 2024-11-05T14:23:08.587Z |
5463313 | 5463313 | 20241102031519_dWscQ | GR0008 | 2024-11-03T14:18:32.435Z | 2024-11-05T14:23:07.985Z |
5463063 | 5463063 | 20241102022722_vm8nm | GR0008 | 2024-11-03T14:18:16.682Z | 2024-11-05T14:23:04.897Z |
5463027 | 5463027 | 20241102021644_lwhyR | GR0008 | 2024-11-03T14:18:15.042Z | 2024-11-05T14:23:04.429Z |
5462727 | 5462727 | 20241102011902_CiAIX | GR0008 | 2024-11-03T14:17:59.125Z | 2024-11-05T14:23:00.787Z |
5462715 | 5462715 | 20241102011719_nDrW3 | GR0008 | 2024-11-03T14:17:57.689Z | 2024-11-05T14:23:00.705Z |
5462661 | 5462661 | 20241102010322_jRoDS | GR0008 | 2024-11-03T14:17:52.293Z | 2024-11-05T14:23:00.344Z |
5462527 | 5462527 | 20241102004142_HUFAC | GR0008 | 2024-11-03T14:17:36.669Z | 2024-11-05T14:22:59.582Z |
5462474 | 5462474 | 20241102002638_uB0wu | GR0008 | 2024-11-03T14:17:28.695Z | 2024-11-05T14:22:59.049Z |
5462413 | 5462413 | 20241102001443_zZ68Z | GR0008 | 2024-11-03T14:17:24.596Z | 2024-11-05T14:22:58.637Z |
5462395 | 5462395 | 20241102000955_Bokf8 | GR0008 | 2024-11-03T14:17:22.244Z | 2024-11-05T14:22:58.606Z |
5462377 | 5462377 | 20241102000529_ZSsy2 | GR0008 | 2024-11-03T14:17:20.722Z | 2024-11-05T14:22:58.443Z |
5462282 | 5462282 | 20241101233743_EaJzP | GR0008 | 2024-11-03T14:17:09.053Z | 2024-11-05T14:22:57.517Z |
5462225 | 5462225 | 20241101232823_n2TxE | GR0008 | 2024-11-03T14:17:04.769Z | 2024-11-05T14:22:57.060Z |
5462158 | 5462158 | 20241101231238_wTvXv | GR0008 | 2024-11-03T14:17:00.588Z | 2024-11-05T14:22:55.920Z |
5462074 | 5462074 | 20241101225533_1RMoZ | GR0008 | 2024-11-03T14:16:55.695Z | 2024-11-05T14:22:54.936Z |
5462070 | 5462070 | 20241101225506_DKMgx | GR0008 | 2024-11-03T14:16:55.500Z | 2024-11-05T14:22:54.933Z |
5461986 | 5461986 | 20241101223249_3x1AN | GR0008 | 2024-11-03T14:16:50.605Z | 2024-11-05T14:22:53.835Z |
5461979 | 5461979 | 20241101223144_fdSz3 | GR0008 | 2024-11-03T14:16:50.190Z | 2024-11-05T14:22:53.755Z |
5461866 | 5461866 | 20241101215330_hmqtT | GR0008 | 2024-11-03T14:16:29.303Z | 2024-11-05T14:22:51.747Z |
5461809 | 5461809 | 20241101213318_hcZ36 | GR0008 | 2024-11-03T14:16:19.975Z | 2024-11-05T14:22:51.119Z |
5461786 | 5461786 | 20241101212547_vLiwF | GR0008 | 2024-11-03T14:16:16.241Z | 2024-11-05T14:22:50.931Z |
5461769 | 5461769 | 20241101212034_Zffr1 | GR0008 | 2024-11-03T14:16:13.764Z | 2024-11-05T14:22:50.788Z |
5461725 | 5461725 | 20241101210232_A9oxB | GR0008 | 2024-11-03T14:16:07.813Z | 2024-11-05T14:22:50.141Z |
5461584 | 5461584 | 20241101200652_iYhGc | GR0008 | 2024-11-03T14:15:56.969Z | 2024-11-05T14:22:48.390Z |
5461518 | 5461518 | 20241101193303_Y2WWW | GR0008 | 2024-11-03T14:15:52.200Z | 2024-11-05T14:22:47.568Z |
5461515 | 5461515 | 20241101193238_gjLJo | GR0008 | 2024-11-03T14:15:52.056Z | 2024-11-05T14:22:47.552Z |
5461364 | 5461364 | 20241101182125_tsknN | GR0008 | 2024-11-03T14:15:19.954Z | 2024-11-05T14:22:44.281Z |
5453971 | 5453971 | 20241031032349_d4M7Z | GR0008 | 2024-11-02T12:22:46.556Z | 2024-11-05T14:25:30.656Z |
5453731 | 5453731 | 20241031025254_N2vNt | GR0008 | 2024-11-02T12:22:41.325Z | 2024-11-05T14:25:29.506Z |
5453678 | 5453678 | 20241031024206_JUvy0 | GR0008 | 2024-11-02T12:22:40.229Z | 2024-11-05T14:25:29.043Z |
5453638 | 5453638 | 20241031023736_Hc0kV | GR0008 | 2024-11-02T12:22:37.805Z | 2024-11-05T14:25:28.713Z |
5453570 | 5453570 | 20241031022610_9xB53 | GR0008 | 2024-11-02T12:22:36.294Z | 2024-11-05T14:25:28.462Z |
5453436 | 5453436 | 20241031021200_9YexC | GR0008 | 2024-11-02T12:22:33.662Z | 2024-11-05T14:25:27.752Z |
5453325 | 5453325 | 20241031020230_Bp2mq | GR0008 | 2024-11-02T12:22:31.829Z | 2024-11-05T14:25:27.243Z |
5453258 | 5453258 | 20241031015355_83gqa | GR0008 | 2024-11-02T12:22:30.433Z | 2024-11-05T14:25:26.894Z |
5453154 | 5453154 | 20241031014541_i6goS | GR0008 | 2024-11-02T12:22:28.189Z | 2024-11-05T14:25:26.580Z |
5453128 | 5453128 | 20241031014337_9CJeX | GR0008 | 2024-11-02T12:22:27.452Z | 2024-11-05T14:25:26.278Z |
5453065 | 5453065 | 20241031013244_0787E | GR0008 | 2024-11-02T12:22:25.273Z | 2024-11-05T14:25:26.121Z |
5452535 | 5452535 | 20241101033519_fmSgx | GR0008 | 2024-11-02T12:18:56.590Z | 2024-11-05T14:24:21.069Z |
5452494 | 5452494 | 20241101032429_BLuuo | GR0008 | 2024-11-02T12:18:52.737Z | 2024-11-05T14:24:20.865Z |
5452424 | 5452424 | 20241101031041_98aeF | GR0008 | 2024-11-02T12:18:48.096Z | 2024-11-05T14:24:19.782Z |
5452275 | 5452275 | 20241101024048_Q5FCH | GR0008 | 2024-11-02T12:18:33.938Z | 2024-11-05T14:24:18.515Z |
5452247 | 5452247 | 20241101023335_d6aBO | GR0008 | 2024-11-02T12:18:31.447Z | 2024-11-05T14:24:18.191Z |
5452211 | 5452211 | 20241101022327_pHPaN | GR0008 | 2024-11-02T12:18:28.305Z | 2024-11-05T14:24:17.753Z |
5452160 | 5452160 | 20241101021231_LEGee | GR0008 | 2024-11-02T12:18:21.569Z | 2024-11-05T14:24:17.245Z |
5452147 | 5452147 | 20241101020845_2A3v6 | GR0008 | 2024-11-02T12:18:20.387Z | 2024-11-05T14:24:17.158Z |
5452078 | 5452078 | 20241101015305_eYgBH | GR0008 | 2024-11-02T12:18:15.461Z | 2024-11-05T14:24:16.524Z |
5451979 | 5451979 | 20241101013919_W94vs | GR0008 | 2024-11-02T12:18:09.326Z | 2024-11-05T14:24:15.437Z |
5451909 | 5451909 | 20241101012511_qnSw6 | GR0008 | 2024-11-02T12:18:05.435Z | 2024-11-05T14:24:14.813Z |
5451887 | 5451887 | 20241101012048_9kIr7 | GR0008 | 2024-11-02T12:18:03.935Z | 2024-11-05T14:24:14.712Z |
5451820 | 5451820 | 20241101011058_M69PW | GR0008 | 2024-11-02T12:17:59.426Z | 2024-11-05T14:24:13.664Z |
5451722 | 5451722 | 20241101005247_IYIov | GR0008 | 2024-11-02T12:17:53.726Z | 2024-11-05T14:24:12.797Z |
5451614 | 5451614 | 20241101003220_WF2G7 | GR0008 | 2024-11-02T12:17:40.578Z | 2024-11-05T14:24:11.480Z |
5451555 | 5451555 | 20241101001406_1PEKS | GR0008 | 2024-11-02T12:17:32.218Z | 2024-11-05T14:24:11.234Z |
5451545 | 5451545 | 20241101001312_bBAKG | GR0008 | 2024-11-02T12:17:29.494Z | 2024-11-05T14:24:11.188Z |
5451514 | 5451514 | 20241101000807_o1dsi | GR0008 | 2024-11-02T12:17:22.870Z | 2024-11-05T14:24:11.090Z |
5451427 | 5451427 | 20241031235507_b9uwt | GR0008 | 2024-11-02T12:17:08.871Z | 2024-11-05T14:24:10.433Z |
5451390 | 5451390 | 20241031235002_7Thlm | GR0008 | 2024-11-02T12:17:01.651Z | 2024-11-05T14:24:10.190Z |
5451265 | 5451265 | 20241031231731_WKAfT | GR0008 | 2024-11-02T12:16:46.646Z | 2024-11-05T14:24:09.224Z |
5451048 | 5451048 | 20241031222630_lsnRk | GR0008 | 2024-11-02T12:16:32.421Z | 2024-11-05T14:24:07.200Z |
5451001 | 5451001 | 20241031221608_2ypd3 | GR0008 | 2024-11-02T12:16:29.086Z | 2024-11-05T14:24:06.785Z |
5450948 | 5450948 | 20241031220037_TnVWb | GR0008 | 2024-11-02T12:16:20.764Z | 2024-11-05T14:24:06.446Z |
5450881 | 5450881 | 20241031213222_ziM3e | GR0008 | 2024-11-02T12:16:09.892Z | 2024-11-05T14:24:05.924Z |
5450875 | 5450875 | 20241031212944_Xvw6q | GR0008 | 2024-11-02T12:16:07.970Z | 2024-11-05T14:24:05.902Z |
5450837 | 5450837 | 20241031211908_kIMEW | GR0008 | 2024-11-02T12:16:02.245Z | 2024-11-05T14:24:05.561Z |
5450746 | 5450746 | 20241031204615_xWon1 | GR0008 | 2024-11-02T12:15:49.668Z | 2024-11-05T14:24:04.137Z |
5450737 | 5450737 | 20241031204217_MguT8 | GR0008 | 2024-11-02T12:15:49.318Z | 2024-11-05T14:24:04.119Z |
5450701 | 5450701 | 20241031202728_bSE2d | GR0008 | 2024-11-02T12:15:45.518Z | 2024-11-05T14:24:03.391Z |
5450612 | 5450612 | 20241031200145_rgs7S | GR0008 | 2024-11-02T12:15:39.364Z | 2024-11-05T14:24:02.878Z |
5450393 | 5450393 | 20241031190934_7qQ4D | GR0008 | 2024-11-02T12:15:11.466Z | 2024-11-05T14:24:01.116Z |
5450240 | 5450240 | 20241031182417_1R1dn | GR0008 | 2024-11-02T12:14:50.605Z | 2024-11-05T14:23:59.622Z |
5444280 | 5444280 | 20241031010433_R9Nnt | GR0008 | 2024-11-01T12:21:11.986Z | 2024-11-05T14:25:25.353Z |
5444214 | 5444214 | 20241031005938_mF0fS | GR0008 | 2024-11-01T12:21:10.218Z | 2024-11-05T14:25:25.124Z |
5444064 | 5444064 | 20241031004334_UvY0Z | GR0008 | 2024-11-01T12:21:04.069Z | 2024-11-05T14:25:24.404Z |
5443858 | 5443858 | 20241031002044_ihTzv | GR0008 | 2024-11-01T12:20:54.420Z | 2024-11-05T14:25:23.382Z |
5443180 | 5443180 | 20241030035210_qshrP | GR0008 | 2024-11-01T12:20:21.080Z | 2024-11-05T14:26:10.234Z |
5442953 | 5442953 | 20241030030152_dfjt8 | GR0008 | 2024-11-01T12:20:13.880Z | 2024-11-05T14:26:09.024Z |
5442948 | 5442948 | 20241030030101_bALrp | GR0008 | 2024-11-01T12:20:13.666Z | 2024-11-05T14:26:09.014Z |
5442870 | 5442870 | 20241030024647_6gfLS | GR0008 | 2024-11-01T12:20:11.355Z | 2024-11-05T14:26:08.793Z |
5442810 | 5442810 | 20241030023720_js96F | GR0008 | 2024-11-01T12:20:09.086Z | 2024-11-05T14:26:08.531Z |
5442561 | 5442561 | 20241030015108_2akv6 | GR0008 | 2024-11-01T12:20:01.321Z | 2024-11-05T14:26:07.051Z |
5442484 | 5442484 | 20241030013653_Rm0gh | GR0008 | 2024-11-01T12:19:53.760Z | 2024-11-05T14:26:06.563Z |
5442341 | 5442341 | 20241030011532_NUPiI | GR0008 | 2024-11-01T12:19:42.989Z | 2024-11-05T14:26:05.919Z |
5442174 | 5442174 | 20241030004751_wPrq6 | GR0008 | 2024-11-01T12:19:31.849Z | 2024-11-05T14:26:04.969Z |
5442078 | 5442078 | 20241030003256_qa1q7 | GR0008 | 2024-11-01T12:19:24.167Z | 2024-11-05T14:26:04.575Z |
5442070 | 5442070 | 20241030003127_QV56V | GR0008 | 2024-11-01T12:19:23.275Z | 2024-11-05T14:26:04.561Z |
5442006 | 5442006 | 20241030001731_EYdXw | GR0008 | 2024-11-01T12:19:17.725Z | 2024-11-05T14:26:04.086Z |
5441932 | 5441932 | 20241030000538_QId8D | GR0008 | 2024-11-01T12:19:12.827Z | 2024-11-05T14:26:03.726Z |
5441770 | 5441770 | 20241029232745_8jWUK | GR0008 | 2024-11-01T12:19:00.958Z | 2024-11-05T14:26:02.838Z |
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);