participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
236 rows where station_code = "IE000J" 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 |
---|---|---|---|---|---|
5136722 | 5136722 | 20240919033503_oP9hr | IE000J | 2024-09-20T12:02:59.726Z | 2024-09-20T12:06:54.945Z |
5136513 | 5136513 | 20240919021429_hRzNm | IE000J | 2024-09-20T12:02:20.922Z | 2024-09-20T12:06:54.881Z |
5133064 | 5133064 | 20240916024924_paA39 | IE000J | 2024-09-19T12:16:43.305Z | 2024-09-20T12:13:30.568Z |
5133034 | 5133034 | 20240916024630_jRoi1 | IE000J | 2024-09-19T12:16:41.994Z | 2024-09-20T12:13:29.338Z |
5132244 | 5132244 | 20240916001007_wnZ7T | IE000J | 2024-09-19T12:16:00.292Z | 2024-09-20T12:13:02.854Z |
5132146 | 5132146 | 20240915234240_3DFp0 | IE000J | 2024-09-19T12:15:52.979Z | 2024-09-20T12:12:58.745Z |
5131694 | 5131694 | 20240915204932_wGKQj | IE000J | 2024-09-19T12:15:15.756Z | 2024-09-20T12:12:38.335Z |
5131667 | 5131667 | 20240915204359_02Jht | IE000J | 2024-09-19T12:15:13.691Z | 2024-09-20T12:12:36.988Z |
5131630 | 5131630 | 20240915203828_XtTRN | IE000J | 2024-09-19T12:15:12.396Z | 2024-09-20T12:12:36.028Z |
5125897 | 5125897 | 20240918042934_mlmKg | IE000J | 2024-09-19T12:04:30.635Z | 2024-09-20T12:08:56.936Z |
5125877 | 5125877 | 20240918041713_pzKpF | IE000J | 2024-09-19T12:04:27.466Z | 2024-09-20T12:08:54.606Z |
5125818 | 5125818 | 20240918040151_q8sKB | IE000J | 2024-09-19T12:04:10.270Z | 2024-09-20T12:08:48.737Z |
5125806 | 5125806 | 20240918040016_lecV8 | IE000J | 2024-09-19T12:04:08.998Z | 2024-09-20T12:08:47.323Z |
5125745 | 5125745 | 20240918033610_bmvoP | IE000J | 2024-09-19T12:04:00.377Z | 2024-09-20T12:08:42.999Z |
5125481 | 5125481 | 20240918024621_s3TGk | IE000J | 2024-09-19T12:03:20.929Z | 2024-09-20T12:08:23.063Z |
5125384 | 5125384 | 20240918022425_dqo2o | IE000J | 2024-09-19T12:03:08.137Z | 2024-09-20T12:08:13.284Z |
5125358 | 5125358 | 20240918022003_kq6YG | IE000J | 2024-09-19T12:03:04.161Z | 2024-09-20T12:08:11.539Z |
5125314 | 5125314 | 20240918020012_ixxQj | IE000J | 2024-09-19T12:02:44.912Z | 2024-09-20T12:08:07.495Z |
5125254 | 5125254 | 20240918014204_GH45C | IE000J | 2024-09-19T12:02:36.616Z | 2024-09-20T12:08:00.019Z |
5125246 | 5125246 | 20240918013027_Vb611 | IE000J | 2024-09-19T12:02:35.315Z | 2024-09-20T12:07:58.777Z |
5125134 | 5125134 | 20240918002540_RMjbv | IE000J | 2024-09-19T12:02:22.887Z | 2024-09-20T12:07:49.434Z |
5125068 | 5125068 | 20240917235650_lbyYh | IE000J | 2024-09-19T12:02:08.039Z | 2024-09-20T12:07:42.791Z |
5125054 | 5125054 | 20240917235105_iSwm7 | IE000J | 2024-09-19T12:02:03.726Z | 2024-09-20T12:07:40.928Z |
5124905 | 5124905 | 20240917224505_iPQDk | IE000J | 2024-09-19T12:01:46.837Z | 2024-09-20T12:07:31.636Z |
5124891 | 5124891 | 20240917223742_z224S | IE000J | 2024-09-19T12:01:44.761Z | 2024-09-20T12:07:30.723Z |
5124827 | 5124827 | 20240917221516_T43hP | IE000J | 2024-09-19T12:01:39.114Z | 2024-09-20T12:07:26.975Z |
5124702 | 5124702 | 20240917215034_De8Ps | IE000J | 2024-09-19T12:01:21.076Z | 2024-09-20T12:07:21.980Z |
5124660 | 5124660 | 20240917214559_0bfyC | IE000J | 2024-09-19T12:01:17.481Z | 2024-09-20T12:07:20.847Z |
5124614 | 5124614 | 20240917213629_ilnUh | IE000J | 2024-09-19T12:01:13.727Z | 2024-09-20T12:07:18.461Z |
5124574 | 5124574 | 20240917211445_o8eGn | IE000J | 2024-09-19T12:01:09.643Z | 2024-09-20T12:07:16.192Z |
5124417 | 5124417 | 20240917200234_o2PlZ | IE000J | 2024-09-19T12:00:47.302Z | 2024-09-20T12:07:02.450Z |
5106464 | 5106464 | 20240913032532_DUSQg | IE000J | 2024-09-17T12:12:55.337Z | 2024-09-20T12:20:41.851Z |
5106108 | 5106108 | 20240913031146_n7YuO | IE000J | 2024-09-17T12:12:42.511Z | 2024-09-20T12:20:40.365Z |
5094872 | 5094872 | 20240912042751_98sjz | IE000J | 2024-09-16T12:15:00.028Z | 2024-09-20T12:21:56.134Z |
5093782 | 5093782 | 20240912033516_AYx7d | IE000J | 2024-09-16T12:14:25.301Z | 2024-09-20T12:21:54.125Z |
5092674 | 5092674 | 20240912025436_mOnUy | IE000J | 2024-09-16T12:14:01.994Z | 2024-09-20T12:21:50.980Z |
5091734 | 5091734 | 20240912022028_gHoif | IE000J | 2024-09-16T12:13:21.208Z | 2024-09-20T12:21:49.048Z |
5091464 | 5091464 | 20240912021007_q3J6u | IE000J | 2024-09-16T12:13:07.249Z | 2024-09-20T12:21:48.368Z |
5091338 | 5091338 | 20240912020536_TeEq6 | IE000J | 2024-09-16T12:13:01.757Z | 2024-09-20T12:21:47.251Z |
5091109 | 5091109 | 20240912015800_3bOyu | IE000J | 2024-09-16T12:12:49.589Z | 2024-09-20T12:21:46.608Z |
5090945 | 5090945 | 20240912015313_h74nB | IE000J | 2024-09-16T12:12:45.345Z | 2024-09-20T12:21:46.127Z |
5090387 | 5090387 | 20240912012401_bjVoR | IE000J | 2024-09-16T12:12:18.243Z | 2024-09-20T12:21:44.929Z |
5090244 | 5090244 | 20240912011818_RvuPB | IE000J | 2024-09-16T12:12:08.641Z | 2024-09-20T12:21:44.741Z |
5090231 | 5090231 | 20240912011716_r2p7P | IE000J | 2024-09-16T12:12:07.497Z | 2024-09-20T12:21:44.710Z |
5089740 | 5089740 | 20240912005510_3Xbfw | IE000J | 2024-09-16T12:11:39.774Z | 2024-09-20T12:21:43.429Z |
5088734 | 5088734 | 20240913002212_J4PLo | IE000J | 2024-09-16T12:08:23.266Z | 2024-09-20T12:20:22.998Z |
5087472 | 5087472 | 20240912232907_r4esJ | IE000J | 2024-09-16T12:06:58.336Z | 2024-09-20T12:20:16.209Z |
5087384 | 5087384 | 20240912232636_sjMe6 | IE000J | 2024-09-16T12:06:54.901Z | 2024-09-20T12:20:15.999Z |
5086322 | 5086322 | 20240912222835_qnhL6 | IE000J | 2024-09-16T12:05:35.020Z | 2024-09-20T12:20:10.807Z |
5085948 | 5085948 | 20240912215925_2ESKg | IE000J | 2024-09-16T12:05:05.385Z | 2024-09-20T12:20:08.719Z |
5085642 | 5085642 | 20240912213901_g4Ybb | IE000J | 2024-09-16T12:04:33.013Z | 2024-09-20T12:20:06.570Z |
5085577 | 5085577 | 20240912213101_Olty0 | IE000J | 2024-09-16T12:04:25.943Z | 2024-09-20T12:20:05.596Z |
5084857 | 5084857 | 20240912202416_yRIBy | IE000J | 2024-09-16T12:03:03.399Z | 2024-09-20T12:19:59.276Z |
5079296 | 5079296 | 20240911024732_flTSh | IE000J | 2024-09-15T12:16:14.808Z | 2024-09-19T12:21:41.409Z |
5077928 | 5077928 | 20240911013127_v2owL | IE000J | 2024-09-15T12:15:11.565Z | 2024-09-19T12:21:39.793Z |
5077778 | 5077778 | 20240911011707_Ox4D3 | IE000J | 2024-09-15T12:15:04.275Z | 2024-09-19T12:21:39.635Z |
5077155 | 5077155 | 20240911002645_J0Swp | IE000J | 2024-09-15T12:14:25.798Z | 2024-09-19T12:21:38.299Z |
5075455 | 5075455 | 20240911234904_5Z0sQ | IE000J | 2024-09-15T12:09:47.812Z | 2024-09-20T12:21:39.917Z |
5075386 | 5075386 | 20240911234516_OMM7O | IE000J | 2024-09-15T12:09:41.403Z | 2024-09-20T12:21:39.806Z |
5074827 | 5074827 | 20240911230727_8cFI7 | IE000J | 2024-09-15T12:09:01.648Z | 2024-09-20T12:21:37.098Z |
5074726 | 5074726 | 20240911225840_Usfh2 | IE000J | 2024-09-15T12:08:46.762Z | 2024-09-20T12:21:36.828Z |
5074710 | 5074710 | 20240911225641_rEDD5 | IE000J | 2024-09-15T12:08:45.498Z | 2024-09-20T12:21:36.773Z |
5074630 | 5074630 | 20240911225047_IxePz | IE000J | 2024-09-15T12:08:40.885Z | 2024-09-20T12:21:36.681Z |
5074335 | 5074335 | 20240911223046_3EZUj | IE000J | 2024-09-15T12:08:24.128Z | 2024-09-20T12:21:35.844Z |
5074257 | 5074257 | 20240911222813_igvnu | IE000J | 2024-09-15T12:08:16.133Z | 2024-09-20T12:21:35.689Z |
5072865 | 5072865 | 20240911204436_hNpcC | IE000J | 2024-09-15T12:06:13.908Z | 2024-09-20T12:21:30.141Z |
5052456 | 5052456 | 20240907204652_JqZjI | IE000J | 2024-09-13T12:15:09.711Z | 2024-09-16T12:21:05.651Z |
5040426 | 5040426 | 20240906040959_yItr8 | IE000J | 2024-09-12T12:16:11.024Z | 2024-09-14T12:23:09.134Z |
5040279 | 5040279 | 20240906032943_cmb2O | IE000J | 2024-09-12T12:16:04.983Z | 2024-09-14T12:23:08.523Z |
5040160 | 5040160 | 20240906030805_b3TrN | IE000J | 2024-09-12T12:16:00.513Z | 2024-09-14T12:23:08.010Z |
5040120 | 5040120 | 20240906030159_QORYW | IE000J | 2024-09-12T12:15:58.689Z | 2024-09-14T12:23:07.638Z |
5039950 | 5039950 | 20240906023435_Zx9No | IE000J | 2024-09-12T12:15:52.646Z | 2024-09-14T12:23:06.239Z |
5039896 | 5039896 | 20240906022149_6G5aA | IE000J | 2024-09-12T12:15:49.010Z | 2024-09-14T12:23:05.768Z |
5039890 | 5039890 | 20240906021936_VGH2N | IE000J | 2024-09-12T12:15:48.880Z | 2024-09-14T12:23:05.761Z |
5039878 | 5039878 | 20240906021641_4BBP5 | IE000J | 2024-09-12T12:15:48.519Z | 2024-09-14T12:23:05.721Z |
5039835 | 5039835 | 20240906020656_WdPIr | IE000J | 2024-09-12T12:15:46.776Z | 2024-09-14T12:23:05.307Z |
5039711 | 5039711 | 20240906015523_jmO6Q | IE000J | 2024-09-12T12:15:43.039Z | 2024-09-14T12:23:04.325Z |
5039595 | 5039595 | 20240906013233_gtni2 | IE000J | 2024-09-12T12:15:38.542Z | 2024-09-14T12:23:03.706Z |
5039405 | 5039405 | 20240906005048_UmbXd | IE000J | 2024-09-12T12:15:31.002Z | 2024-09-14T12:23:01.960Z |
5039396 | 5039396 | 20240906004521_1OjQO | IE000J | 2024-09-12T12:15:29.393Z | 2024-09-14T12:23:01.910Z |
5039372 | 5039372 | 20240906003610_PnPOQ | IE000J | 2024-09-12T12:15:28.569Z | 2024-09-14T12:23:01.678Z |
5039365 | 5039365 | 20240906003252_0w9c0 | IE000J | 2024-09-12T12:15:28.230Z | 2024-09-14T12:23:01.660Z |
5039345 | 5039345 | 20240906002809_302jB | IE000J | 2024-09-12T12:15:27.408Z | 2024-09-14T12:23:01.458Z |
5039322 | 5039322 | 20240906002304_qMR5W | IE000J | 2024-09-12T12:15:26.598Z | 2024-09-14T12:23:01.410Z |
5039242 | 5039242 | 20240905235944_raHKt | IE000J | 2024-09-12T12:15:22.208Z | 2024-09-14T12:23:01.037Z |
5033689 | 5033689 | 20240907032854_58Q0U | IE000J | 2024-09-12T12:09:50.096Z | 2024-09-15T12:21:31.516Z |
5033669 | 5033669 | 20240907032652_pl3iW | IE000J | 2024-09-12T12:09:48.986Z | 2024-09-15T12:21:31.469Z |
5033625 | 5033625 | 20240907032105_eByVE | IE000J | 2024-09-12T12:09:46.015Z | 2024-09-15T12:21:30.711Z |
5033246 | 5033246 | 20240907024128_Y7HYv | IE000J | 2024-09-12T12:09:02.281Z | 2024-09-15T12:21:29.359Z |
5033129 | 5033129 | 20240907022746_1LCWk | IE000J | 2024-09-12T12:08:51.525Z | 2024-09-15T12:21:29.036Z |
5032816 | 5032816 | 20240907015135_MKBRk | IE000J | 2024-09-12T12:08:06.685Z | 2024-09-15T12:21:27.978Z |
5032699 | 5032699 | 20240907013411_JetSn | IE000J | 2024-09-12T12:07:52.489Z | 2024-09-15T12:21:27.483Z |
5032483 | 5032483 | 20240907010730_g96oQ | IE000J | 2024-09-12T12:07:23.641Z | 2024-09-15T12:21:26.573Z |
5032102 | 5032102 | 20240907001309_y8MTp | IE000J | 2024-09-12T12:06:33.098Z | 2024-09-15T12:21:25.235Z |
5032033 | 5032033 | 20240906235856_MtkOC | IE000J | 2024-09-12T12:06:26.306Z | 2024-09-15T12:21:25.122Z |
5031892 | 5031892 | 20240906233752_vZZjE | IE000J | 2024-09-12T12:06:00.995Z | 2024-09-15T12:21:24.632Z |
5031843 | 5031843 | 20240906233114_g7MpY | IE000J | 2024-09-12T12:05:55.084Z | 2024-09-15T12:21:24.413Z |
5031757 | 5031757 | 20240906231149_hwo2D | IE000J | 2024-09-12T12:05:44.990Z | 2024-09-15T12:21:24.228Z |
5031717 | 5031717 | 20240906230532_2un26 | IE000J | 2024-09-12T12:05:34.218Z | 2024-09-15T12:21:23.932Z |
5031702 | 5031702 | 20240906230222_lCZGL | IE000J | 2024-09-12T12:05:27.102Z | 2024-09-15T12:21:23.899Z |
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);