participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,351 rows where station_code = "IE0004" 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 |
---|---|---|---|---|---|
5565469 | 5565469 | 20241120042920_9KRta | IE0004 | 2024-11-21T14:18:50.199Z | 2024-11-22T14:21:47.482Z |
5565374 | 5565374 | 20241120042149_x4jjK | IE0004 | 2024-11-21T14:18:47.560Z | 2024-11-22T14:21:46.292Z |
5565327 | 5565327 | 20241120041932_spJFM | IE0004 | 2024-11-21T14:18:46.656Z | 2024-11-22T14:21:46.007Z |
5565030 | 5565030 | 20241120034528_4ZYP8 | IE0004 | 2024-11-21T14:18:23.159Z | 2024-11-22T14:21:40.494Z |
5564981 | 5564981 | 20241120034328_ALSKA | IE0004 | 2024-11-21T14:18:17.670Z | 2024-11-22T14:21:40.098Z |
5564959 | 5564959 | 20241120034218_74CSR | IE0004 | 2024-11-21T14:18:16.541Z | 2024-11-22T14:21:39.810Z |
5564699 | 5564699 | 20241120032124_6mw4v | IE0004 | 2024-11-21T14:17:58.786Z | 2024-11-22T14:21:35.740Z |
5564575 | 5564575 | 20241120031110_Yv1xy | IE0004 | 2024-11-21T14:17:51.206Z | 2024-11-22T14:21:33.597Z |
5564543 | 5564543 | 20241120030747_TluGP | IE0004 | 2024-11-21T14:17:47.686Z | 2024-11-22T14:21:33.431Z |
5564450 | 5564450 | 20241120025841_RVY30 | IE0004 | 2024-11-21T14:17:38.966Z | 2024-11-22T14:21:32.225Z |
5564169 | 5564169 | 20241120023502_B9zPh | IE0004 | 2024-11-21T14:17:15.560Z | 2024-11-22T14:21:27.876Z |
5563878 | 5563878 | 20241120021213_GkWqR | IE0004 | 2024-11-21T14:16:53.144Z | 2024-11-22T14:21:24.428Z |
5561837 | 5561837 | 20241119221556_0bYIV | IE0004 | 2024-11-21T14:14:09.266Z | 2024-11-22T14:20:47.297Z |
5561271 | 5561271 | 20241119192548_ycJnq | IE0004 | 2024-11-21T14:12:55.964Z | 2024-11-22T14:20:29.330Z |
5561243 | 5561243 | 20241119191725_oL9Uz | IE0004 | 2024-11-21T14:12:44.921Z | 2024-11-22T14:20:27.556Z |
5557697 | 5557697 | 20241120050517_GLhx3 | IE0004 | 2024-11-21T14:01:32.054Z | 2024-11-22T14:19:21.113Z |
5557416 | 5557416 | 20241120044437_TIB6u | IE0004 | 2024-11-21T14:00:47.295Z | 2024-11-22T14:19:21.067Z |
5532689 | 5532689 | 20241112055313_QUoU9 | IE0004 | 2024-11-13T14:17:09.827Z | 2024-11-20T14:26:25.684Z |
5532545 | 5532545 | 20241112053631_2FUZe | IE0004 | 2024-11-13T14:16:59.169Z | 2024-11-20T14:26:24.544Z |
5532482 | 5532482 | 20241112052906_9PnEE | IE0004 | 2024-11-13T14:16:52.457Z | 2024-11-20T14:26:23.918Z |
5532472 | 5532472 | 20241112052812_4BBgp | IE0004 | 2024-11-13T14:16:51.697Z | 2024-11-20T14:26:23.824Z |
5532421 | 5532421 | 20241112051905_X3ecm | IE0004 | 2024-11-13T14:16:43.690Z | 2024-11-20T14:26:22.794Z |
5532413 | 5532413 | 20241112051905_73Gir | IE0004 | 2024-11-13T14:16:43.359Z | 2024-11-20T14:26:22.752Z |
5532232 | 5532232 | 20241112045330_eukHX | IE0004 | 2024-11-13T14:16:29.019Z | 2024-11-20T14:26:21.194Z |
5532208 | 5532208 | 20241112045210_EbI3i | IE0004 | 2024-11-13T14:16:27.342Z | 2024-11-20T14:26:20.910Z |
5532194 | 5532194 | 20241112045157_suJov | IE0004 | 2024-11-13T14:16:26.830Z | 2024-11-20T14:26:20.873Z |
5532153 | 5532153 | 20241112044402_Ih3Ow | IE0004 | 2024-11-13T14:16:23.031Z | 2024-11-20T14:26:20.403Z |
5531737 | 5531737 | 20241112040554_3P1R1 | IE0004 | 2024-11-13T14:15:53.353Z | 2024-11-20T14:26:13.762Z |
5531549 | 5531549 | 20241112034810_CaEeh | IE0004 | 2024-11-13T14:15:44.421Z | 2024-11-20T14:26:12.149Z |
5531375 | 5531375 | 20241112033443_DYKqa | IE0004 | 2024-11-13T14:15:36.511Z | 2024-11-20T14:26:10.669Z |
5531365 | 5531365 | 20241112033408_muBiX | IE0004 | 2024-11-13T14:15:36.064Z | 2024-11-20T14:26:10.650Z |
5531248 | 5531248 | 20241112032556_pDsI2 | IE0004 | 2024-11-13T14:15:31.702Z | 2024-11-20T14:26:09.543Z |
5531206 | 5531206 | 20241112032207_EyB2L | IE0004 | 2024-11-13T14:15:25.584Z | 2024-11-20T14:26:08.577Z |
5531184 | 5531184 | 20241112032051_ktgcI | IE0004 | 2024-11-13T14:15:23.157Z | 2024-11-20T14:26:08.504Z |
5530902 | 5530902 | 20241112025906_IKv9G | IE0004 | 2024-11-13T14:14:49.862Z | 2024-11-20T14:26:05.154Z |
5530787 | 5530787 | 20241112024643_IbkLz | IE0004 | 2024-11-13T14:14:38.542Z | 2024-11-20T14:26:03.606Z |
5530610 | 5530610 | 20241112023358_h3TtC | IE0004 | 2024-11-13T14:14:24.880Z | 2024-11-20T14:26:01.997Z |
5530095 | 5530095 | 20241112014309_oKyEJ | IE0004 | 2024-11-13T14:13:51.609Z | 2024-11-20T14:25:54.296Z |
5530068 | 5530068 | 20241112013942_3ikrN | IE0004 | 2024-11-13T14:13:48.124Z | 2024-11-20T14:25:54.060Z |
5529998 | 5529998 | 20241112013341_cqoYP | IE0004 | 2024-11-13T14:13:36.076Z | 2024-11-20T14:25:52.378Z |
5529977 | 5529977 | 20241112013231_2fAAn | IE0004 | 2024-11-13T14:13:33.586Z | 2024-11-20T14:25:52.008Z |
5529194 | 5529194 | 20241111234632_kacXY | IE0004 | 2024-11-13T14:12:13.334Z | 2024-11-20T14:25:41.774Z |
5529038 | 5529038 | 20241111232149_d73hP | IE0004 | 2024-11-13T14:12:00.203Z | 2024-11-20T14:25:39.182Z |
5525624 | 5525624 | 20241112055747_0142F | IE0004 | 2024-11-13T14:00:09.907Z | 2024-11-21T14:25:24.392Z |
5525612 | 5525612 | 20241112055638_AqEy8 | IE0004 | 2024-11-13T14:00:08.849Z | 2024-11-21T14:25:24.341Z |
5524058 | 5524058 | 20241111030700_hL3bC | IE0004 | 2024-11-12T14:16:29.988Z | 2024-11-19T14:22:16.922Z |
5523889 | 5523889 | 20241111024359_CRZFa | IE0004 | 2024-11-12T14:16:19.141Z | 2024-11-19T14:22:15.717Z |
5523833 | 5523833 | 20241111023210_fe9B3 | IE0004 | 2024-11-12T14:16:16.171Z | 2024-11-19T14:22:15.474Z |
5523821 | 5523821 | 20241111022928_3Yn2X | IE0004 | 2024-11-12T14:16:15.611Z | 2024-11-19T14:22:15.407Z |
5523670 | 5523670 | 20241111020326_GC2pD | IE0004 | 2024-11-12T14:16:06.911Z | 2024-11-19T14:22:14.313Z |
5522607 | 5522607 | 20241110204404_zPSL8 | IE0004 | 2024-11-12T14:13:45.663Z | 2024-11-19T14:22:04.598Z |
5429552 | 5429552 | 20241028193428_RhUiX | IE0004 | 2024-10-31T12:16:45.654Z | 2024-11-06T14:27:16.587Z |
5410709 | 5410709 | 20241027053054_BwOEC | IE0004 | 2024-10-29T12:18:03.157Z | 2024-11-04T14:29:05.285Z |
5410678 | 5410678 | 20241027052755_rMIxt | IE0004 | 2024-10-29T12:18:02.338Z | 2024-11-04T14:29:05.212Z |
5410239 | 5410239 | 20241027050234_4umfj | IE0004 | 2024-10-29T12:17:51.307Z | 2024-11-04T14:29:04.239Z |
5409603 | 5409603 | 20241027042808_Qpgc7 | IE0004 | 2024-10-29T12:17:32.939Z | 2024-11-04T14:29:02.007Z |
5409523 | 5409523 | 20241027042329_wiHUZ | IE0004 | 2024-10-29T12:17:28.485Z | 2024-11-04T14:29:01.938Z |
5409165 | 5409165 | 20241027040355_02mPc | IE0004 | 2024-10-29T12:17:09.544Z | 2024-11-04T14:29:01.235Z |
5408971 | 5408971 | 20241027035141_YSaAm | IE0004 | 2024-10-29T12:16:58.777Z | 2024-11-04T14:29:00.881Z |
5408782 | 5408782 | 20241027034330_1VmU3 | IE0004 | 2024-10-29T12:16:51.328Z | 2024-11-04T14:29:00.537Z |
5408663 | 5408663 | 20241027033457_w1Cgs | IE0004 | 2024-10-29T12:16:43.315Z | 2024-11-04T14:28:59.812Z |
5408599 | 5408599 | 20241027033122_UIF1P | IE0004 | 2024-10-29T12:16:38.868Z | 2024-11-04T14:28:59.671Z |
5408297 | 5408297 | 20241027032207_Qopv8 | IE0004 | 2024-10-29T12:16:21.841Z | 2024-11-04T14:28:59.069Z |
5407376 | 5407376 | 20241027023423_05cST | IE0004 | 2024-10-29T12:15:23.072Z | 2024-11-04T14:28:57.462Z |
5407239 | 5407239 | 20241027022801_VZzI4 | IE0004 | 2024-10-29T12:15:18.396Z | 2024-11-04T14:28:57.259Z |
5407148 | 5407148 | 20241027022404_742y8 | IE0004 | 2024-10-29T12:15:14.951Z | 2024-11-04T14:28:57.110Z |
5407032 | 5407032 | 20241027021751_ZtfmF | IE0004 | 2024-10-29T12:15:09.756Z | 2024-11-04T14:28:56.791Z |
5406893 | 5406893 | 20241027020705_X8Qr8 | IE0004 | 2024-10-29T12:14:53.632Z | 2024-11-04T14:28:56.582Z |
5406673 | 5406673 | 20241027015310_A8k3u | IE0004 | 2024-10-29T12:14:30.969Z | 2024-11-04T14:28:56.018Z |
5406640 | 5406640 | 20241027015144_gwnWn | IE0004 | 2024-10-29T12:14:28.269Z | 2024-11-04T14:28:55.971Z |
5406126 | 5406126 | 20241027011826_AwXPw | IE0004 | 2024-10-29T12:13:52.957Z | 2024-11-04T14:28:55.153Z |
5405909 | 5405909 | 20241027010720_Zw4Tl | IE0004 | 2024-10-29T12:13:32.374Z | 2024-11-04T14:28:54.600Z |
5405804 | 5405804 | 20241027010014_3Y08T | IE0004 | 2024-10-29T12:13:18.711Z | 2024-11-04T14:28:54.336Z |
5405487 | 5405487 | 20241027003916_iUq8e | IE0004 | 2024-10-29T12:12:59.052Z | 2024-11-04T14:28:53.560Z |
5405408 | 5405408 | 20241027003242_RrX59 | IE0004 | 2024-10-29T12:12:54.769Z | 2024-11-04T14:28:53.458Z |
5405334 | 5405334 | 20241027002907_1x3el | IE0004 | 2024-10-29T12:12:50.147Z | 2024-11-04T14:28:53.294Z |
5405099 | 5405099 | 20241027001344_ckHDe | IE0004 | 2024-10-29T12:12:27.469Z | 2024-11-04T14:28:52.677Z |
5405040 | 5405040 | 20241027001005_sYxuw | IE0004 | 2024-10-29T12:12:19.220Z | 2024-11-04T14:28:52.617Z |
5404995 | 5404995 | 20241027000707_bkzkk | IE0004 | 2024-10-29T12:12:15.318Z | 2024-11-04T14:28:52.505Z |
5404725 | 5404725 | 20241026234925_gxOAe | IE0004 | 2024-10-29T12:11:55.131Z | 2024-11-04T14:28:51.872Z |
5404250 | 5404250 | 20241026231208_R2WjD | IE0004 | 2024-10-29T12:11:03.268Z | 2024-11-04T14:28:50.555Z |
5404241 | 5404241 | 20241026231121_7nHby | IE0004 | 2024-10-29T12:11:02.998Z | 2024-11-04T14:28:50.551Z |
5404228 | 5404228 | 20241026231013_SK3sc | IE0004 | 2024-10-29T12:11:02.298Z | 2024-11-04T14:28:50.522Z |
5404199 | 5404199 | 20241026230812_fWwLf | IE0004 | 2024-10-29T12:11:00.153Z | 2024-11-04T14:28:50.454Z |
5403899 | 5403899 | 20241026224444_rA486 | IE0004 | 2024-10-29T12:10:25.977Z | 2024-11-04T14:28:49.980Z |
5403423 | 5403423 | 20241026215532_xIVT8 | IE0004 | 2024-10-29T12:09:28.820Z | 2024-11-04T14:28:48.800Z |
5403404 | 5403404 | 20241026215414_l20z6 | IE0004 | 2024-10-29T12:09:27.763Z | 2024-11-04T14:28:48.729Z |
5403320 | 5403320 | 20241026214045_GDS6I | IE0004 | 2024-10-29T12:09:21.896Z | 2024-11-04T14:28:48.330Z |
5403171 | 5403171 | 20241026212537_u5XAq | IE0004 | 2024-10-29T12:09:10.195Z | 2024-11-04T14:28:47.923Z |
5402872 | 5402872 | 20241026203613_PT3P0 | IE0004 | 2024-10-29T12:08:31.009Z | 2024-11-04T14:28:46.759Z |
5402581 | 5402581 | 20241026195837_13aRw | IE0004 | 2024-10-29T12:07:44.774Z | 2024-11-04T14:28:45.386Z |
5400175 | 5400175 | 20241026055029_ulbyN | IE0004 | 2024-10-28T12:20:25.562Z | 2024-11-03T14:27:41.457Z |
5400171 | 5400171 | 20241026055019_eG88G | IE0004 | 2024-10-28T12:20:25.540Z | 2024-11-03T14:27:41.455Z |
5398040 | 5398040 | 20241026021956_zlsaw | IE0004 | 2024-10-28T12:18:58.379Z | 2024-11-03T14:27:35.103Z |
5397897 | 5397897 | 20241026020619_C4SMr | IE0004 | 2024-10-28T12:18:49.859Z | 2024-11-03T14:27:34.458Z |
5397373 | 5397373 | 20241026012420_u8aPb | IE0004 | 2024-10-28T12:18:18.726Z | 2024-11-03T14:27:32.758Z |
5397294 | 5397294 | 20241026011622_7nBQs | IE0004 | 2024-10-28T12:18:14.868Z | 2024-11-03T14:27:32.551Z |
5397287 | 5397287 | 20241026011559_UY7D1 | IE0004 | 2024-10-28T12:18:14.304Z | 2024-11-03T14:27:32.515Z |
5396531 | 5396531 | 20241026000955_0KhG3 | IE0004 | 2024-10-28T12:17:48.938Z | 2024-11-03T14:27:30.157Z |
5396483 | 5396483 | 20241026000712_K7xmw | IE0004 | 2024-10-28T12:17:45.763Z | 2024-11-03T14:27:29.968Z |
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);