participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
252 rows where station_code = "IE000H" 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 |
---|---|---|---|---|---|
5104582 | 5104582 | 20240913021556_ewyvg | IE000H | 2024-09-17T12:11:40.029Z | 2024-09-20T12:20:34.808Z |
5097219 | 5097219 | 20240913003702_mc0UT | IE000H | 2024-09-16T12:17:08.445Z | 2024-09-20T12:20:24.798Z |
5087457 | 5087457 | 20240912232817_KTxO8 | IE000H | 2024-09-16T12:06:56.967Z | 2024-09-20T12:20:16.157Z |
4736178 | 4736178 | 20240729023553_1DRMf | IE000H | 2024-08-01T12:05:23.708Z | 2024-08-06T12:14:54.822Z |
4545343 | 4545343 | 20240704001257_WGLNp | IE000H | 2024-07-05T12:01:43.858Z | 2024-07-12T12:08:52.970Z |
3239460 | 3239460 | 20231022045533_HgzDW | IE000H | 2024-01-06T00:03:16.114Z | 2024-01-06T00:03:16.114Z |
2954738 | 2954738 | 20230908020643_2ZKLf | IE000H | 2024-01-06T00:01:36.524Z | 2024-01-06T00:01:36.524Z |
2841277 | 2841277 | 20230817022350_XnhvR | IE000H | 2024-01-06T00:00:57.818Z | 2024-01-06T00:00:57.818Z |
2822328 | 2822328 | 20230815221216_es3yX | IE000H | 2024-01-06T00:00:52.211Z | 2024-01-06T00:00:52.211Z |
2701040 | 2701040 | 20230806010956_tTmT5 | IE000H | 2024-01-06T00:00:17.019Z | 2024-01-06T00:00:17.019Z |
2699650 | 2699650 | 20230805215440_2SSZ3 | IE000H | 2024-01-06T00:00:15.587Z | 2024-01-06T00:00:15.587Z |
2384459 | 2384459 | 20230415025517_Up0Ql | IE000H | 2024-01-05T23:56:54.355Z | 2024-01-05T23:56:54.355Z |
2384438 | 2384438 | 20230415024859_lPPT3 | IE000H | 2024-01-05T23:56:54.353Z | 2024-01-05T23:56:54.353Z |
2383789 | 2383789 | 20230414231433_W1sOT | IE000H | 2024-01-05T23:56:54.286Z | 2024-01-05T23:56:54.286Z |
2383755 | 2383755 | 20230414225011_lpQbZ | IE000H | 2024-01-05T23:56:54.282Z | 2024-01-05T23:56:54.282Z |
2383645 | 2383645 | 20230414220102_WE8xh | IE000H | 2024-01-05T23:56:54.268Z | 2024-01-05T23:56:54.268Z |
2379105 | 2379105 | 20230413000330_V3y2u | IE000H | 2024-01-05T23:56:51.304Z | 2024-01-05T23:56:51.304Z |
2377240 | 2377240 | 20230412024151_GzSGy | IE000H | 2024-01-05T23:56:49.927Z | 2024-01-05T23:56:49.927Z |
2374975 | 2374975 | 20230411022213_YYnOd | IE000H | 2024-01-05T23:56:48.308Z | 2024-01-05T23:56:48.308Z |
2374518 | 2374518 | 20230411003412_PlYxn | IE000H | 2024-01-05T23:56:48.139Z | 2024-01-05T23:56:48.139Z |
2374071 | 2374071 | 20230410223257_aldI7 | IE000H | 2024-01-05T23:56:48.006Z | 2024-01-05T23:56:48.006Z |
2304048 | 2304048 | 20230226194847_L7Y2w | IE000H | 2024-01-05T23:55:42.915Z | 2024-01-05T23:55:42.915Z |
2302940 | 2302940 | 20230226055146_HtdwC | IE000H | 2024-01-05T23:55:42.790Z | 2024-01-05T23:55:42.790Z |
2298917 | 2298917 | 20230225013934_TL5hG | IE000H | 2024-01-05T23:55:40.000Z | 2024-01-05T23:55:40.000Z |
2298490 | 2298490 | 20230224220613_Ok8rj | IE000H | 2024-01-05T23:55:39.957Z | 2024-01-05T23:55:39.957Z |
2295456 | 2295456 | 20230223024353_lNPG3 | IE000H | 2024-01-05T23:55:36.926Z | 2024-01-05T23:55:36.926Z |
2295374 | 2295374 | 20230223015522_3t43v | IE000H | 2024-01-05T23:55:36.916Z | 2024-01-05T23:55:36.916Z |
2266146 | 2266146 | 20230209041855_fP4kQ | IE000H | 2024-01-05T23:55:07.824Z | 2024-01-05T23:55:07.824Z |
2251636 | 2251636 | 20230131054719_R4Itc | IE000H | 2024-01-05T23:54:52.014Z | 2024-01-05T23:54:52.014Z |
2237994 | 2237994 | 20230127005250_O77kk | IE000H | 2024-01-05T23:54:45.456Z | 2024-01-05T23:54:45.456Z |
2200501 | 2200501 | 20230117042244_2ys37 | IE000H | 2024-01-05T23:54:20.473Z | 2024-01-05T23:54:20.473Z |
2198025 | 2198025 | 20230116053647_VQ0Bp | IE000H | 2024-01-05T23:54:19.048Z | 2024-01-05T23:54:19.048Z |
2197529 | 2197529 | 20230115182421_19WAK | IE000H | 2024-01-05T23:54:18.973Z | 2024-01-05T23:54:18.973Z |
2169080 | 2169080 | 20221229041547_rKsYH | IE000H | 2024-01-05T23:53:56.362Z | 2024-01-05T23:53:56.362Z |
2161074 | 2161074 | 20221226201741_movlD | IE000H | 2024-01-05T23:53:51.996Z | 2024-01-05T23:53:51.996Z |
2157947 | 2157947 | 20221226062217_4Loox | IE000H | 2024-01-05T23:53:51.708Z | 2024-01-05T23:53:51.708Z |
2157678 | 2157678 | 20221226055543_QYPGl | IE000H | 2024-01-05T23:53:51.688Z | 2024-01-05T23:53:51.688Z |
2156598 | 2156598 | 20221226040437_6icOo | IE000H | 2024-01-05T23:53:51.592Z | 2024-01-05T23:53:51.592Z |
2155623 | 2155623 | 20221226004959_pJTUz | IE000H | 2024-01-05T23:53:50.225Z | 2024-01-05T23:53:50.225Z |
2147368 | 2147368 | 20221224051123_u4Hjp | IE000H | 2024-01-05T23:53:48.141Z | 2024-01-05T23:53:48.141Z |
2145840 | 2145840 | 20221224005911_xwWj4 | IE000H | 2024-01-05T23:53:46.796Z | 2024-01-05T23:53:46.796Z |
2143633 | 2143633 | 20221222195448_36QAM | IE000H | 2024-01-05T23:53:45.295Z | 2024-01-05T23:53:45.295Z |
2133867 | 2133867 | 20221220064153_QsNLY | IE000H | 2024-01-05T23:53:41.474Z | 2024-01-05T23:53:41.474Z |
2133501 | 2133501 | 20221220053420_9EpMX | IE000H | 2024-01-05T23:53:40.245Z | 2024-01-05T23:53:40.245Z |
2133502 | 2133502 | 20221220053524_f4nkY | IE000H | 2024-01-05T23:53:40.245Z | 2024-01-05T23:53:40.245Z |
2133288 | 2133288 | 20221220042446_peu9V | IE000H | 2024-01-05T23:53:40.221Z | 2024-01-05T23:53:40.221Z |
2133275 | 2133275 | 20221220042106_a5mSF | IE000H | 2024-01-05T23:53:40.219Z | 2024-01-05T23:53:40.219Z |
2132925 | 2132925 | 20221220014732_ECzpL | IE000H | 2024-01-05T23:53:40.177Z | 2024-01-05T23:53:40.177Z |
2132252 | 2132252 | 20221219190305_uzKJc | IE000H | 2024-01-05T23:53:40.098Z | 2024-01-05T23:53:40.098Z |
2105604 | 2105604 | 20221215065120_w6rcX | IE000H | 2024-01-05T23:53:30.894Z | 2024-01-05T23:53:30.894Z |
2105197 | 2105197 | 20221215063243_2u85v | IE000H | 2024-01-05T23:53:30.861Z | 2024-01-05T23:53:30.861Z |
2102613 | 2102613 | 20221215051207_IDcUF | IE000H | 2024-01-05T23:53:30.501Z | 2024-01-05T23:53:30.501Z |
2101812 | 2101812 | 20221215045001_v4R98 | IE000H | 2024-01-05T23:53:30.445Z | 2024-01-05T23:53:30.445Z |
2100914 | 2100914 | 20221215043115_luMjH | IE000H | 2024-01-05T23:53:30.386Z | 2024-01-05T23:53:30.386Z |
2098958 | 2098958 | 20221215034142_LI2Yw | IE000H | 2024-01-05T23:53:30.044Z | 2024-01-05T23:53:30.044Z |
2097888 | 2097888 | 20221215031406_452VJ | IE000H | 2024-01-05T23:53:29.968Z | 2024-01-05T23:53:29.968Z |
2097742 | 2097742 | 20221215031017_mWMoN | IE000H | 2024-01-05T23:53:29.958Z | 2024-01-05T23:53:29.958Z |
2097565 | 2097565 | 20221215030452_p6GxL | IE000H | 2024-01-05T23:53:29.944Z | 2024-01-05T23:53:29.944Z |
2096252 | 2096252 | 20221215023857_CJxqm | IE000H | 2024-01-05T23:53:29.856Z | 2024-01-05T23:53:29.856Z |
2095849 | 2095849 | 20221215022927_k82GS | IE000H | 2024-01-05T23:53:29.830Z | 2024-01-05T23:53:29.830Z |
2094184 | 2094184 | 20221215014721_thQdD | IE000H | 2024-01-05T23:53:29.429Z | 2024-01-05T23:53:29.429Z |
2093976 | 2093976 | 20221215014332_WpzY0 | IE000H | 2024-01-05T23:53:29.415Z | 2024-01-05T23:53:29.415Z |
2093754 | 2093754 | 20221215013751_tsAeM | IE000H | 2024-01-05T23:53:29.400Z | 2024-01-05T23:53:29.400Z |
2093377 | 2093377 | 20221215013149_JeOdw | IE000H | 2024-01-05T23:53:29.378Z | 2024-01-05T23:53:29.378Z |
2093371 | 2093371 | 20221215013130_Dad2r | IE000H | 2024-01-05T23:53:29.377Z | 2024-01-05T23:53:29.377Z |
2093134 | 2093134 | 20221215012618_agph4 | IE000H | 2024-01-05T23:53:29.361Z | 2024-01-05T23:53:29.361Z |
2091264 | 2091264 | 20221215004713_bHjh2 | IE000H | 2024-01-05T23:53:29.015Z | 2024-01-05T23:53:29.015Z |
2090599 | 2090599 | 20221215003146_sZ2ID | IE000H | 2024-01-05T23:53:28.970Z | 2024-01-05T23:53:28.970Z |
2090593 | 2090593 | 20221215003138_00Pp4 | IE000H | 2024-01-05T23:53:28.969Z | 2024-01-05T23:53:28.969Z |
2090196 | 2090196 | 20221215002245_VsCGh | IE000H | 2024-01-05T23:53:28.940Z | 2024-01-05T23:53:28.940Z |
2089442 | 2089442 | 20221215000536_Be45Z | IE000H | 2024-01-05T23:53:28.890Z | 2024-01-05T23:53:28.890Z |
2089048 | 2089048 | 20221214235819_DyFhy | IE000H | 2024-01-05T23:53:28.865Z | 2024-01-05T23:53:28.865Z |
2088725 | 2088725 | 20221214235152_XPggR | IE000H | 2024-01-05T23:53:28.842Z | 2024-01-05T23:53:28.842Z |
2088625 | 2088625 | 20221214235110_zirzE | IE000H | 2024-01-05T23:53:28.836Z | 2024-01-05T23:53:28.836Z |
2088139 | 2088139 | 20221214234126_qZGuc | IE000H | 2024-01-05T23:53:28.800Z | 2024-01-05T23:53:28.800Z |
2087988 | 2087988 | 20221214233739_3jafN | IE000H | 2024-01-05T23:53:28.788Z | 2024-01-05T23:53:28.788Z |
2087781 | 2087781 | 20221214233303_3P2Np | IE000H | 2024-01-05T23:53:28.510Z | 2024-01-05T23:53:28.510Z |
2086483 | 2086483 | 20221214230355_0h1ul | IE000H | 2024-01-05T23:53:28.423Z | 2024-01-05T23:53:28.423Z |
2085176 | 2085176 | 20221214223159_MJxWK | IE000H | 2024-01-05T23:53:28.338Z | 2024-01-05T23:53:28.338Z |
2084977 | 2084977 | 20221214222638_jDjkU | IE000H | 2024-01-05T23:53:28.323Z | 2024-01-05T23:53:28.323Z |
2084796 | 2084796 | 20221214222336_IV2X3 | IE000H | 2024-01-05T23:53:28.312Z | 2024-01-05T23:53:28.312Z |
2084213 | 2084213 | 20221214220923_Sst7G | IE000H | 2024-01-05T23:53:28.274Z | 2024-01-05T23:53:28.274Z |
2083090 | 2083090 | 20221214214030_vY1v1 | IE000H | 2024-01-05T23:53:27.999Z | 2024-01-05T23:53:27.999Z |
2082847 | 2082847 | 20221214213502_SU3Mi | IE000H | 2024-01-05T23:53:27.985Z | 2024-01-05T23:53:27.985Z |
2082648 | 2082648 | 20221214213114_EZyA5 | IE000H | 2024-01-05T23:53:27.973Z | 2024-01-05T23:53:27.973Z |
2082494 | 2082494 | 20221214212749_XvVKB | IE000H | 2024-01-05T23:53:27.963Z | 2024-01-05T23:53:27.963Z |
2082319 | 2082319 | 20221214212227_BRAKb | IE000H | 2024-01-05T23:53:27.949Z | 2024-01-05T23:53:27.949Z |
2082260 | 2082260 | 20221214212124_xyl3P | IE000H | 2024-01-05T23:53:27.944Z | 2024-01-05T23:53:27.944Z |
2082073 | 2082073 | 20221214211627_XEnbf | IE000H | 2024-01-05T23:53:27.930Z | 2024-01-05T23:53:27.930Z |
2081927 | 2081927 | 20221214211232_jvXUu | IE000H | 2024-01-05T23:53:27.918Z | 2024-01-05T23:53:27.918Z |
2081637 | 2081637 | 20221214210423_ma2fj | IE000H | 2024-01-05T23:53:27.896Z | 2024-01-05T23:53:27.896Z |
2080423 | 2080423 | 20221214202333_JQrrE | IE000H | 2024-01-05T23:53:27.508Z | 2024-01-05T23:53:27.508Z |
2079895 | 2079895 | 20221214200522_CMZoN | IE000H | 2024-01-05T23:53:27.468Z | 2024-01-05T23:53:27.468Z |
2079414 | 2079414 | 20221214194928_1LNba | IE000H | 2024-01-05T23:53:27.431Z | 2024-01-05T23:53:27.431Z |
2079226 | 2079226 | 20221214194208_4eC9t | IE000H | 2024-01-05T23:53:27.415Z | 2024-01-05T23:53:27.415Z |
2078965 | 2078965 | 20221214193317_GgkiU | IE000H | 2024-01-05T23:53:27.392Z | 2024-01-05T23:53:27.392Z |
2078526 | 2078526 | 20221214191634_gh5B5 | IE000H | 2024-01-05T23:53:27.355Z | 2024-01-05T23:53:27.355Z |
2078370 | 2078370 | 20221214190754_v3osD | IE000H | 2024-01-05T23:53:27.341Z | 2024-01-05T23:53:27.341Z |
2077567 | 2077567 | 20221214183151_RCkI2 | IE000H | 2024-01-05T23:53:27.271Z | 2024-01-05T23:53:27.271Z |
2077020 | 2077020 | 20221214180642_aC6Ow | IE000H | 2024-01-05T23:53:27.211Z | 2024-01-05T23:53:27.211Z |
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);