participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,498 rows where station_code = "GR0002" 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 |
---|---|---|---|---|---|
5565209 | 5565209 | 20241120040401_3FJ7C | GR0002 | 2024-11-21T14:18:41.085Z | 2024-11-21T14:18:54.174Z |
5565126 | 5565126 | 20241120035419_4rCc1 | GR0002 | 2024-11-21T14:18:32.786Z | 2024-11-21T14:18:54.158Z |
5564889 | 5564889 | 20241120033554_KUByR | GR0002 | 2024-11-21T14:18:13.588Z | 2024-11-21T14:18:54.120Z |
5563925 | 5563925 | 20241120021552_a1c8D | GR0002 | 2024-11-21T14:16:59.098Z | 2024-11-21T14:18:53.948Z |
5561184 | 5561184 | 20241119185407_UbX9V | GR0002 | 2024-11-21T14:12:34.063Z | 2024-11-21T14:18:53.428Z |
5557182 | 5557182 | 20241119042353_C2SZV | GR0002 | 2024-11-20T14:12:25.374Z | 2024-11-21T14:20:49.110Z |
5557128 | 5557128 | 20241119040426_s6QdU | GR0002 | 2024-11-20T14:12:20.047Z | 2024-11-21T14:20:47.508Z |
5557123 | 5557123 | 20241119040144_C5f20 | GR0002 | 2024-11-20T14:12:19.573Z | 2024-11-21T14:20:47.039Z |
5557085 | 5557085 | 20241119034835_lvUb5 | GR0002 | 2024-11-20T14:12:14.123Z | 2024-11-21T14:20:45.889Z |
5557041 | 5557041 | 20241119033053_n83nl | GR0002 | 2024-11-20T14:12:03.755Z | 2024-11-21T14:20:44.250Z |
5557026 | 5557026 | 20241119032605_1fkWQ | GR0002 | 2024-11-20T14:12:01.887Z | 2024-11-21T14:20:43.774Z |
5556928 | 5556928 | 20241119025559_M2Fft | GR0002 | 2024-11-20T14:11:41.906Z | 2024-11-21T14:20:39.834Z |
5556850 | 5556850 | 20241119021806_MPYar | GR0002 | 2024-11-20T14:11:33.923Z | 2024-11-21T14:20:37.215Z |
5556807 | 5556807 | 20241119015912_9FmIV | GR0002 | 2024-11-20T14:11:30.185Z | 2024-11-21T14:20:36.050Z |
5556700 | 5556700 | 20241119011533_M936m | GR0002 | 2024-11-20T14:11:19.733Z | 2024-11-21T14:20:32.829Z |
5556617 | 5556617 | 20241119001303_UpPqG | GR0002 | 2024-11-20T14:10:54.169Z | 2024-11-21T14:20:29.917Z |
5556586 | 5556586 | 20241118234420_UJ6Ds | GR0002 | 2024-11-20T14:10:47.578Z | 2024-11-21T14:20:28.396Z |
5556574 | 5556574 | 20241118234017_0qvT8 | GR0002 | 2024-11-20T14:10:46.407Z | 2024-11-21T14:20:28.184Z |
5556494 | 5556494 | 20241118222441_vHPUi | GR0002 | 2024-11-20T14:10:37.284Z | 2024-11-21T14:20:26.275Z |
5556448 | 5556448 | 20241118214807_mUd4o | GR0002 | 2024-11-20T14:10:32.502Z | 2024-11-21T14:20:24.647Z |
5556393 | 5556393 | 20241118204831_NDzgI | GR0002 | 2024-11-20T14:10:23.685Z | 2024-11-21T14:20:22.517Z |
5556379 | 5556379 | 20241118202533_N7p0p | GR0002 | 2024-11-20T14:10:18.188Z | 2024-11-21T14:20:20.404Z |
5556366 | 5556366 | 20241118200359_ID4Jc | GR0002 | 2024-11-20T14:10:07.977Z | 2024-11-21T14:20:19.601Z |
5556319 | 5556319 | 20241118183659_tu9hm | GR0002 | 2024-11-20T14:09:54.518Z | 2024-11-21T14:20:16.691Z |
5556314 | 5556314 | 20241118182944_3KFiJ | GR0002 | 2024-11-20T14:09:52.768Z | 2024-11-21T14:20:16.309Z |
5553743 | 5553743 | 20241118040858_3KdP3 | GR0002 | 2024-11-19T14:11:24.416Z | 2024-11-21T14:22:20.747Z |
5553473 | 5553473 | 20241118025141_nLhk1 | GR0002 | 2024-11-19T14:10:39.741Z | 2024-11-21T14:22:15.508Z |
5552767 | 5552767 | 20241117211658_N4sik | GR0002 | 2024-11-19T14:09:09.081Z | 2024-11-21T14:21:59.834Z |
5552683 | 5552683 | 20241117200932_y45tX | GR0002 | 2024-11-19T14:08:54.675Z | 2024-11-21T14:21:55.055Z |
5548151 | 5548151 | 20241116202027_rwJIe | GR0002 | 2024-11-18T14:08:20.746Z | 2024-11-21T14:22:49.203Z |
5517548 | 5517548 | 20241110040118_jDS99 | GR0002 | 2024-11-11T14:14:34.325Z | 2024-11-18T14:26:37.110Z |
5517366 | 5517366 | 20241110033407_il8Xw | GR0002 | 2024-11-11T14:14:18.818Z | 2024-11-18T14:26:36.155Z |
5517310 | 5517310 | 20241110032226_5gIDp | GR0002 | 2024-11-11T14:14:13.507Z | 2024-11-18T14:26:35.826Z |
5517088 | 5517088 | 20241110024606_jPO0d | GR0002 | 2024-11-11T14:13:52.600Z | 2024-11-18T14:26:34.680Z |
5517053 | 5517053 | 20241110023943_h7c8q | GR0002 | 2024-11-11T14:13:48.555Z | 2024-11-18T14:26:34.436Z |
5516881 | 5516881 | 20241110021337_R3Drx | GR0002 | 2024-11-11T14:13:28.130Z | 2024-11-18T14:26:33.644Z |
5516731 | 5516731 | 20241110015120_5V8dm | GR0002 | 2024-11-11T14:13:17.338Z | 2024-11-18T14:26:33.022Z |
5516673 | 5516673 | 20241110013857_pJnkM | GR0002 | 2024-11-11T14:13:14.516Z | 2024-11-18T14:26:32.744Z |
5516549 | 5516549 | 20241110011753_YTBp5 | GR0002 | 2024-11-11T14:13:08.028Z | 2024-11-18T14:26:31.885Z |
5516534 | 5516534 | 20241110011412_auoSG | GR0002 | 2024-11-11T14:13:06.911Z | 2024-11-18T14:26:31.727Z |
5516495 | 5516495 | 20241110010809_NjSSe | GR0002 | 2024-11-11T14:13:04.947Z | 2024-11-18T14:26:31.528Z |
5516379 | 5516379 | 20241110004951_Plf2E | GR0002 | 2024-11-11T14:12:54.937Z | 2024-11-18T14:26:30.927Z |
5516375 | 5516375 | 20241110004907_5Aw69 | GR0002 | 2024-11-11T14:12:54.228Z | 2024-11-18T14:26:30.903Z |
5516267 | 5516267 | 20241110002544_PZqfr | GR0002 | 2024-11-11T14:12:37.688Z | 2024-11-18T14:26:30.373Z |
5516237 | 5516237 | 20241110001905_M3O2z | GR0002 | 2024-11-11T14:12:31.853Z | 2024-11-18T14:26:30.233Z |
5516200 | 5516200 | 20241110001240_iOsKL | GR0002 | 2024-11-11T14:12:26.892Z | 2024-11-18T14:26:30.066Z |
5516189 | 5516189 | 20241110001045_SOG12 | GR0002 | 2024-11-11T14:12:25.237Z | 2024-11-18T14:26:30.021Z |
5516153 | 5516153 | 20241110000043_SSxVb | GR0002 | 2024-11-11T14:12:20.713Z | 2024-11-18T14:26:29.839Z |
5516018 | 5516018 | 20241109233456_LtROn | GR0002 | 2024-11-11T14:11:59.873Z | 2024-11-18T14:26:28.945Z |
5515977 | 5515977 | 20241109232328_kac3D | GR0002 | 2024-11-11T14:11:52.411Z | 2024-11-18T14:26:28.767Z |
5515946 | 5515946 | 20241109231728_L7JZs | GR0002 | 2024-11-11T14:11:49.994Z | 2024-11-18T14:26:28.613Z |
5515844 | 5515844 | 20241109225542_WKjZv | GR0002 | 2024-11-11T14:11:36.706Z | 2024-11-18T14:26:28.161Z |
5515737 | 5515737 | 20241109223254_32Enk | GR0002 | 2024-11-11T14:11:25.223Z | 2024-11-18T14:26:27.779Z |
5515727 | 5515727 | 20241109223156_bkA0d | GR0002 | 2024-11-11T14:11:24.722Z | 2024-11-18T14:26:27.751Z |
5515695 | 5515695 | 20241109222436_BusTp | GR0002 | 2024-11-11T14:11:22.474Z | 2024-11-18T14:26:27.570Z |
5515677 | 5515677 | 20241109222223_306Qn | GR0002 | 2024-11-11T14:11:21.127Z | 2024-11-18T14:26:27.364Z |
5515627 | 5515627 | 20241109221147_JJHSz | GR0002 | 2024-11-11T14:11:18.133Z | 2024-11-18T14:26:27.108Z |
5515547 | 5515547 | 20241109215557_jjr24 | GR0002 | 2024-11-11T14:11:12.684Z | 2024-11-18T14:26:26.676Z |
5515513 | 5515513 | 20241109214529_PpJGa | GR0002 | 2024-11-11T14:11:10.189Z | 2024-11-18T14:26:26.488Z |
5515454 | 5515454 | 20241109212707_IYdMh | GR0002 | 2024-11-11T14:11:05.990Z | 2024-11-18T14:26:26.115Z |
5515377 | 5515377 | 20241109210427_Q1jEa | GR0002 | 2024-11-11T14:10:52.133Z | 2024-11-18T14:26:25.755Z |
5515279 | 5515279 | 20241109201157_p7Q72 | GR0002 | 2024-11-11T14:10:34.426Z | 2024-11-18T14:26:25.232Z |
5515226 | 5515226 | 20241109195850_txTAc | GR0002 | 2024-11-11T14:10:22.439Z | 2024-11-18T14:26:24.987Z |
5515203 | 5515203 | 20241109195240_ClkOr | GR0002 | 2024-11-11T14:10:19.995Z | 2024-11-18T14:26:24.913Z |
5515089 | 5515089 | 20241109191950_L6LyY | GR0002 | 2024-11-11T14:10:03.696Z | 2024-11-18T14:26:24.229Z |
5514807 | 5514807 | 20241109174212_RYjhV | GR0002 | 2024-11-11T14:09:18.050Z | 2024-11-18T14:26:22.590Z |
5514693 | 5514693 | 20241109164732_BiFtg | GR0002 | 2024-11-11T14:08:58.233Z | 2024-11-18T14:26:21.811Z |
5514666 | 5514666 | 20241109163944_hIaZV | GR0002 | 2024-11-11T14:08:55.907Z | 2024-11-18T14:26:21.666Z |
5510932 | 5510932 | 20241109035715_1o6ei | GR0002 | 2024-11-10T14:15:57.387Z | 2024-11-17T14:24:02.729Z |
5510918 | 5510918 | 20241109035436_au4IG | GR0002 | 2024-11-10T14:15:54.641Z | 2024-11-17T14:24:02.546Z |
5510915 | 5510915 | 20241109035436_tfUEe | GR0002 | 2024-11-10T14:15:54.512Z | 2024-11-17T14:24:02.545Z |
5510752 | 5510752 | 20241109033233_Br0Eo | GR0002 | 2024-11-10T14:15:38.008Z | 2024-11-17T14:24:00.931Z |
5510602 | 5510602 | 20241109030930_AFaO3 | GR0002 | 2024-11-10T14:15:29.152Z | 2024-11-17T14:23:59.588Z |
5510467 | 5510467 | 20241109024435_DHujq | GR0002 | 2024-11-10T14:15:18.898Z | 2024-11-17T14:23:58.068Z |
5510403 | 5510403 | 20241109023549_2vJ9z | GR0002 | 2024-11-10T14:15:09.635Z | 2024-11-17T14:23:57.075Z |
5510343 | 5510343 | 20241109022309_KH3m1 | GR0002 | 2024-11-10T14:15:03.506Z | 2024-11-17T14:23:56.401Z |
5510222 | 5510222 | 20241109020215_YUzdB | GR0002 | 2024-11-10T14:14:49.418Z | 2024-11-17T14:23:54.310Z |
5510189 | 5510189 | 20241109015712_pJwho | GR0002 | 2024-11-10T14:14:45.824Z | 2024-11-17T14:23:53.779Z |
5510131 | 5510131 | 20241109014638_V4fIq | GR0002 | 2024-11-10T14:14:38.547Z | 2024-11-17T14:23:53.159Z |
5510019 | 5510019 | 20241109012840_gsjZe | GR0002 | 2024-11-10T14:14:27.711Z | 2024-11-17T14:23:52.045Z |
5509848 | 5509848 | 20241109005023_ufyAq | GR0002 | 2024-11-10T14:14:06.940Z | 2024-11-17T14:23:50.029Z |
5509811 | 5509811 | 20241109004436_fYWMI | GR0002 | 2024-11-10T14:14:03.044Z | 2024-11-17T14:23:49.481Z |
5509688 | 5509688 | 20241109001102_P7eY1 | GR0002 | 2024-11-10T14:13:51.398Z | 2024-11-17T14:23:48.279Z |
5509652 | 5509652 | 20241109000415_ezRyy | GR0002 | 2024-11-10T14:13:47.323Z | 2024-11-17T14:23:48.059Z |
5509638 | 5509638 | 20241109000141_7CsNT | GR0002 | 2024-11-10T14:13:45.608Z | 2024-11-17T14:23:48.004Z |
5509580 | 5509580 | 20241108235011_MpFg4 | GR0002 | 2024-11-10T14:13:36.872Z | 2024-11-17T14:23:47.111Z |
5509522 | 5509522 | 20241108233939_doItl | GR0002 | 2024-11-10T14:13:31.144Z | 2024-11-17T14:23:46.572Z |
5509496 | 5509496 | 20241108233250_TfCGU | GR0002 | 2024-11-10T14:13:27.824Z | 2024-11-17T14:23:46.203Z |
5509356 | 5509356 | 20241108225618_4FhwA | GR0002 | 2024-11-10T14:13:15.416Z | 2024-11-17T14:23:43.507Z |
5509281 | 5509281 | 20241108224213_Qmvvw | GR0002 | 2024-11-10T14:13:08.717Z | 2024-11-17T14:23:42.358Z |
5509246 | 5509246 | 20241108223501_nC27f | GR0002 | 2024-11-10T14:13:01.486Z | 2024-11-17T14:23:41.976Z |
5509222 | 5509222 | 20241108222931_qdCL1 | GR0002 | 2024-11-10T14:12:58.714Z | 2024-11-17T14:23:41.708Z |
5509212 | 5509212 | 20241108222719_ObZyF | GR0002 | 2024-11-10T14:12:56.598Z | 2024-11-17T14:23:41.569Z |
5509194 | 5509194 | 20241108222324_vm1iM | GR0002 | 2024-11-10T14:12:52.214Z | 2024-11-17T14:23:41.415Z |
5509192 | 5509192 | 20241108222311_DuzYT | GR0002 | 2024-11-10T14:12:52.095Z | 2024-11-17T14:23:41.397Z |
5509190 | 5509190 | 20241108222239_K0IYX | GR0002 | 2024-11-10T14:12:50.802Z | 2024-11-17T14:23:41.380Z |
5509165 | 5509165 | 20241108221144_zG9sq | GR0002 | 2024-11-10T14:12:46.992Z | 2024-11-17T14:23:41.129Z |
5509153 | 5509153 | 20241108220658_eKzNk | GR0002 | 2024-11-10T14:12:45.236Z | 2024-11-17T14:23:41.010Z |
5509148 | 5509148 | 20241108220647_x1Hgk | GR0002 | 2024-11-10T14:12:44.016Z | 2024-11-17T14:23:41.010Z |
5509119 | 5509119 | 20241108215637_nKdmd | GR0002 | 2024-11-10T14:12:35.383Z | 2024-11-17T14:23:40.447Z |
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);