participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,363 rows where station_code = "GR0009" 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 |
---|---|---|---|---|---|
5564180 | 5564180 | 20241120023542_BODN9 | GR0009 | 2024-11-21T14:17:16.105Z | 2024-11-22T14:21:27.956Z |
5563614 | 5563614 | 20241120015303_6nS86 | GR0009 | 2024-11-21T14:16:29.325Z | 2024-11-22T14:21:20.048Z |
5557118 | 5557118 | 20241119040130_7K4Ym | GR0009 | 2024-11-20T14:12:19.461Z | 2024-11-22T14:22:22.351Z |
5557094 | 5557094 | 20241119035055_JTWOY | GR0009 | 2024-11-20T14:12:16.607Z | 2024-11-22T14:22:22.167Z |
5557089 | 5557089 | 20241119034943_BJUC6 | GR0009 | 2024-11-20T14:12:15.927Z | 2024-11-22T14:22:22.131Z |
5557027 | 5557027 | 20241119032605_1fkWQ | GR0009 | 2024-11-20T14:12:01.887Z | 2024-11-22T14:22:21.762Z |
5556942 | 5556942 | 20241119025932_Ot3nX | GR0009 | 2024-11-20T14:11:43.665Z | 2024-11-22T14:22:21.084Z |
5556929 | 5556929 | 20241119025559_M2Fft | GR0009 | 2024-11-20T14:11:41.906Z | 2024-11-22T14:22:20.869Z |
5556902 | 5556902 | 20241119024456_C3L3q | GR0009 | 2024-11-20T14:11:39.541Z | 2024-11-22T14:22:20.734Z |
5556881 | 5556881 | 20241119023051_S313D | GR0009 | 2024-11-20T14:11:36.731Z | 2024-11-22T14:22:20.599Z |
5556872 | 5556872 | 20241119022355_otdOW | GR0009 | 2024-11-20T14:11:35.874Z | 2024-11-22T14:22:20.524Z |
5556851 | 5556851 | 20241119021806_MPYar | GR0009 | 2024-11-20T14:11:33.923Z | 2024-11-22T14:22:20.377Z |
5556836 | 5556836 | 20241119020921_A2gNl | GR0009 | 2024-11-20T14:11:32.476Z | 2024-11-22T14:22:20.283Z |
5556826 | 5556826 | 20241119020717_TGTB6 | GR0009 | 2024-11-20T14:11:31.470Z | 2024-11-22T14:22:20.239Z |
5556809 | 5556809 | 20241119015912_9FmIV | GR0009 | 2024-11-20T14:11:30.185Z | 2024-11-22T14:22:20.108Z |
5556802 | 5556802 | 20241119015728_EOwus | GR0009 | 2024-11-20T14:11:29.696Z | 2024-11-22T14:22:20.078Z |
5556757 | 5556757 | 20241119014534_bSXRi | GR0009 | 2024-11-20T14:11:25.730Z | 2024-11-22T14:22:19.740Z |
5556735 | 5556735 | 20241119013434_kYPYN | GR0009 | 2024-11-20T14:11:23.949Z | 2024-11-22T14:22:19.630Z |
5556707 | 5556707 | 20241119011824_Uuu40 | GR0009 | 2024-11-20T14:11:20.408Z | 2024-11-22T14:22:19.366Z |
5556701 | 5556701 | 20241119011533_M936m | GR0009 | 2024-11-20T14:11:19.733Z | 2024-11-22T14:22:19.344Z |
5556681 | 5556681 | 20241119010149_h8zuv | GR0009 | 2024-11-20T14:11:15.811Z | 2024-11-22T14:22:19.262Z |
5556671 | 5556671 | 20241119005635_W7iTm | GR0009 | 2024-11-20T14:11:09.049Z | 2024-11-22T14:22:19.231Z |
5556667 | 5556667 | 20241119005522_zJkTf | GR0009 | 2024-11-20T14:11:08.553Z | 2024-11-22T14:22:19.184Z |
5556656 | 5556656 | 20241119004719_qZuN7 | GR0009 | 2024-11-20T14:11:05.321Z | 2024-11-22T14:22:19.077Z |
5556629 | 5556629 | 20241119002306_aC3Vb | GR0009 | 2024-11-20T14:10:58.112Z | 2024-11-22T14:22:18.874Z |
5556618 | 5556618 | 20241119001303_UpPqG | GR0009 | 2024-11-20T14:10:54.169Z | 2024-11-22T14:22:18.784Z |
5556575 | 5556575 | 20241118234017_0qvT8 | GR0009 | 2024-11-20T14:10:46.407Z | 2024-11-22T14:22:18.499Z |
5556563 | 5556563 | 20241118233002_ASD04 | GR0009 | 2024-11-20T14:10:44.826Z | 2024-11-22T14:22:18.369Z |
5556559 | 5556559 | 20241118232752_yGE2p | GR0009 | 2024-11-20T14:10:44.252Z | 2024-11-22T14:22:18.354Z |
5556555 | 5556555 | 20241118232221_BoxiK | GR0009 | 2024-11-20T14:10:42.951Z | 2024-11-22T14:22:18.213Z |
5556530 | 5556530 | 20241118230452_2GI0i | GR0009 | 2024-11-20T14:10:40.732Z | 2024-11-22T14:22:18.108Z |
5556516 | 5556516 | 20241118224850_22G2O | GR0009 | 2024-11-20T14:10:39.298Z | 2024-11-22T14:22:17.996Z |
5556503 | 5556503 | 20241118223950_m1wNK | GR0009 | 2024-11-20T14:10:38.130Z | 2024-11-22T14:22:17.860Z |
5556495 | 5556495 | 20241118222441_vHPUi | GR0009 | 2024-11-20T14:10:37.284Z | 2024-11-22T14:22:17.782Z |
5556481 | 5556481 | 20241118221446_TNPQZ | GR0009 | 2024-11-20T14:10:35.615Z | 2024-11-22T14:22:17.657Z |
5556450 | 5556450 | 20241118214807_mUd4o | GR0009 | 2024-11-20T14:10:32.502Z | 2024-11-22T14:22:17.401Z |
5556437 | 5556437 | 20241118213321_Bu64c | GR0009 | 2024-11-20T14:10:30.508Z | 2024-11-22T14:22:17.360Z |
5556433 | 5556433 | 20241118212937_cflc2 | GR0009 | 2024-11-20T14:10:29.831Z | 2024-11-22T14:22:17.341Z |
5556396 | 5556396 | 20241118205641_dd8EJ | GR0009 | 2024-11-20T14:10:24.509Z | 2024-11-22T14:22:17.063Z |
5556394 | 5556394 | 20241118204831_NDzgI | GR0009 | 2024-11-20T14:10:23.685Z | 2024-11-22T14:22:16.940Z |
5556386 | 5556386 | 20241118203056_ZpF2B | GR0009 | 2024-11-20T14:10:21.487Z | 2024-11-22T14:22:16.798Z |
5556367 | 5556367 | 20241118200359_ID4Jc | GR0009 | 2024-11-20T14:10:07.977Z | 2024-11-22T14:22:16.317Z |
5556355 | 5556355 | 20241118193533_SA0MQ | GR0009 | 2024-11-20T14:10:02.431Z | 2024-11-22T14:22:15.992Z |
5556352 | 5556352 | 20241118192741_iXs83 | GR0009 | 2024-11-20T14:10:01.446Z | 2024-11-22T14:22:15.946Z |
5556324 | 5556324 | 20241118184621_G2S0q | GR0009 | 2024-11-20T14:09:56.321Z | 2024-11-22T14:22:15.418Z |
5556322 | 5556322 | 20241118183659_tu9hm | GR0009 | 2024-11-20T14:09:54.518Z | 2024-11-22T14:22:15.353Z |
5556316 | 5556316 | 20241118182944_3KFiJ | GR0009 | 2024-11-20T14:09:52.788Z | 2024-11-22T14:22:15.186Z |
5556305 | 5556305 | 20241118181853_Cifaz | GR0009 | 2024-11-20T14:09:50.705Z | 2024-11-22T14:22:14.847Z |
5556274 | 5556274 | 20241118172844_q7VSY | GR0009 | 2024-11-20T14:09:44.092Z | 2024-11-22T14:22:14.257Z |
5556252 | 5556252 | 20241118164205_DbS8v | GR0009 | 2024-11-20T14:09:38.943Z | 2024-11-22T14:22:13.441Z |
5556248 | 5556248 | 20241118163012_2wf2o | GR0009 | 2024-11-20T14:09:38.208Z | 2024-11-22T14:22:13.348Z |
5553745 | 5553745 | 20241118040929_uLNYm | GR0009 | 2024-11-19T14:11:24.543Z | 2024-11-22T14:22:55.995Z |
5553474 | 5553474 | 20241118025141_nLhk1 | GR0009 | 2024-11-19T14:10:39.741Z | 2024-11-22T14:22:53.482Z |
5553338 | 5553338 | 20241118020711_Zae3R | GR0009 | 2024-11-19T14:10:20.229Z | 2024-11-22T14:22:52.361Z |
5553115 | 5553115 | 20241118004912_ymr5B | GR0009 | 2024-11-19T14:10:04.171Z | 2024-11-22T14:22:50.623Z |
5553084 | 5553084 | 20241118003919_RR2js | GR0009 | 2024-11-19T14:10:02.131Z | 2024-11-22T14:22:50.385Z |
5553071 | 5553071 | 20241118003734_rh6lg | GR0009 | 2024-11-19T14:10:01.414Z | 2024-11-22T14:22:50.351Z |
5553056 | 5553056 | 20241118003347_93TyV | GR0009 | 2024-11-19T14:10:00.250Z | 2024-11-22T14:22:50.276Z |
5553042 | 5553042 | 20241118002622_wCNLa | GR0009 | 2024-11-19T14:09:58.710Z | 2024-11-22T14:22:49.979Z |
5553033 | 5553033 | 20241118002253_8kaxj | GR0009 | 2024-11-19T14:09:57.978Z | 2024-11-22T14:22:49.936Z |
5553012 | 5553012 | 20241118001153_oYV4e | GR0009 | 2024-11-19T14:09:56.591Z | 2024-11-22T14:22:49.815Z |
5553005 | 5553005 | 20241118000430_av8bM | GR0009 | 2024-11-19T14:09:56.134Z | 2024-11-22T14:22:49.778Z |
5552822 | 5552822 | 20241117221302_PCHF3 | GR0009 | 2024-11-19T14:09:21.578Z | 2024-11-22T14:22:47.299Z |
5552686 | 5552686 | 20241117201220_iqKyq | GR0009 | 2024-11-19T14:08:55.021Z | 2024-11-22T14:22:45.244Z |
5552684 | 5552684 | 20241117200932_y45tX | GR0009 | 2024-11-19T14:08:54.688Z | 2024-11-22T14:22:45.156Z |
5549072 | 5549072 | 20241117025809_JZRyj | GR0009 | 2024-11-18T14:10:49.090Z | 2024-11-22T14:23:17.784Z |
5549056 | 5549056 | 20241117025338_eTx4L | GR0009 | 2024-11-18T14:10:47.308Z | 2024-11-22T14:23:17.734Z |
5548995 | 5548995 | 20241117023853_f6MQZ | GR0009 | 2024-11-18T14:10:36.772Z | 2024-11-22T14:23:17.448Z |
5548400 | 5548400 | 20241116231119_aQvBO | GR0009 | 2024-11-18T14:09:08.783Z | 2024-11-22T14:23:12.742Z |
5548387 | 5548387 | 20241116230521_EXlvq | GR0009 | 2024-11-18T14:09:04.954Z | 2024-11-22T14:23:12.497Z |
5548332 | 5548332 | 20241116223600_bjqrL | GR0009 | 2024-11-18T14:08:47.640Z | 2024-11-22T14:23:12.034Z |
5548152 | 5548152 | 20241116202027_rwJIe | GR0009 | 2024-11-18T14:08:20.760Z | 2024-11-22T14:23:10.332Z |
5548132 | 5548132 | 20241116200408_mizxd | GR0009 | 2024-11-18T14:08:18.196Z | 2024-11-22T14:23:10.203Z |
5524411 | 5524411 | 20241111040934_Uc8Yu | GR0009 | 2024-11-12T14:17:16.416Z | 2024-11-19T14:22:21.125Z |
5524301 | 5524301 | 20241111035028_MUnrP | GR0009 | 2024-11-12T14:16:58.170Z | 2024-11-19T14:22:19.827Z |
5524014 | 5524014 | 20241111030158_OLKzd | GR0009 | 2024-11-12T14:16:26.567Z | 2024-11-19T14:22:16.536Z |
5523907 | 5523907 | 20241111024533_49ig3 | GR0009 | 2024-11-12T14:16:19.805Z | 2024-11-19T14:22:15.747Z |
5523853 | 5523853 | 20241111023847_wf4km | GR0009 | 2024-11-12T14:16:17.375Z | 2024-11-19T14:22:15.572Z |
5523841 | 5523841 | 20241111023400_vyZT0 | GR0009 | 2024-11-12T14:16:16.517Z | 2024-11-19T14:22:15.509Z |
5523796 | 5523796 | 20241111022425_WbJT1 | GR0009 | 2024-11-12T14:16:13.520Z | 2024-11-19T14:22:15.023Z |
5523773 | 5523773 | 20241111022145_g3omX | GR0009 | 2024-11-12T14:16:12.388Z | 2024-11-19T14:22:14.876Z |
5517582 | 5517582 | 20241110040414_rivHb | GR0009 | 2024-11-11T14:14:37.577Z | 2024-11-18T14:26:37.222Z |
5517503 | 5517503 | 20241110035553_DkMs3 | GR0009 | 2024-11-11T14:14:30.386Z | 2024-11-18T14:26:36.823Z |
5517463 | 5517463 | 20241110034624_PnXqF | GR0009 | 2024-11-11T14:14:26.544Z | 2024-11-18T14:26:36.524Z |
5517443 | 5517443 | 20241110034356_kx29o | GR0009 | 2024-11-11T14:14:24.522Z | 2024-11-18T14:26:36.475Z |
5517425 | 5517425 | 20241110034137_Nt5uh | GR0009 | 2024-11-11T14:14:23.221Z | 2024-11-18T14:26:36.396Z |
5517419 | 5517419 | 20241110034109_rHGMB | GR0009 | 2024-11-11T14:14:22.822Z | 2024-11-18T14:26:36.371Z |
5517406 | 5517406 | 20241110033908_i912H | GR0009 | 2024-11-11T14:14:22.134Z | 2024-11-18T14:26:36.334Z |
5517396 | 5517396 | 20241110033834_2mvqN | GR0009 | 2024-11-11T14:14:21.487Z | 2024-11-18T14:26:36.274Z |
5517376 | 5517376 | 20241110033612_N1a5v | GR0009 | 2024-11-11T14:14:19.358Z | 2024-11-18T14:26:36.192Z |
5517368 | 5517368 | 20241110033407_il8Xw | GR0009 | 2024-11-11T14:14:18.818Z | 2024-11-18T14:26:36.155Z |
5517256 | 5517256 | 20241110031524_k1Y30 | GR0009 | 2024-11-11T14:14:10.008Z | 2024-11-18T14:26:35.661Z |
5517153 | 5517153 | 20241110025442_ESA7v | GR0009 | 2024-11-11T14:13:58.809Z | 2024-11-18T14:26:34.960Z |
5517136 | 5517136 | 20241110025200_8LoCG | GR0009 | 2024-11-11T14:13:57.448Z | 2024-11-18T14:26:34.830Z |
5517074 | 5517074 | 20241110024306_7G6g0 | GR0009 | 2024-11-11T14:13:50.203Z | 2024-11-18T14:26:34.594Z |
5516882 | 5516882 | 20241110021337_R3Drx | GR0009 | 2024-11-11T14:13:28.130Z | 2024-11-18T14:26:33.644Z |
5516842 | 5516842 | 20241110020838_QejJz | GR0009 | 2024-11-11T14:13:25.896Z | 2024-11-18T14:26:33.534Z |
5516824 | 5516824 | 20241110020708_rmORF | GR0009 | 2024-11-11T14:13:24.892Z | 2024-11-18T14:26:33.477Z |
5516764 | 5516764 | 20241110015839_eRrYn | GR0009 | 2024-11-11T14:13:18.785Z | 2024-11-18T14:26:33.165Z |
5516749 | 5516749 | 20241110015428_FzRj1 | GR0009 | 2024-11-11T14:13:18.204Z | 2024-11-18T14:26:33.145Z |
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);