participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,910 rows where station_code = "US0027" 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 |
---|---|---|---|---|---|
5130490 | 5130490 | 20240917122315_op82d | US0027 | 2024-09-19T12:13:25.505Z | 2024-09-19T12:13:25.505Z |
5130488 | 5130488 | 20240917122217_pU60n | US0027 | 2024-09-19T12:13:24.952Z | 2024-09-19T12:13:24.952Z |
5126484 | 5126484 | 20240918122958_LRXPx | US0027 | 2024-09-19T12:06:04.010Z | 2024-09-19T12:06:42.209Z |
5029604 | 5029604 | 20240905100416_oHc2G | US0027 | 2024-09-11T12:16:47.440Z | 2024-09-13T12:20:06.614Z |
5029276 | 5029276 | 20240905115142_OIeKF | US0027 | 2024-09-11T12:16:24.618Z | 2024-09-14T12:22:51.350Z |
5028628 | 5028628 | 20240905103038_zR02R | US0027 | 2024-09-11T12:15:38.524Z | 2024-09-14T12:22:48.667Z |
5028563 | 5028563 | 20240905102247_j4top | US0027 | 2024-09-11T12:15:35.201Z | 2024-09-14T12:22:48.261Z |
5023035 | 5023035 | 20240905100416_fx5hY | US0027 | 2024-09-10T12:16:35.580Z | 2024-09-11T12:15:22.296Z |
5021639 | 5021639 | 20240905070116_sIf5k | US0027 | 2024-09-10T12:15:44.808Z | 2024-09-10T12:16:55.413Z |
5015755 | 5015755 | 20240904122706_wzWbt | US0027 | 2024-09-10T12:06:44.415Z | 2024-09-13T12:19:44.645Z |
5014087 | 5014087 | 20240905115142_WeBR3 | US0027 | 2024-09-10T12:02:18.756Z | 2024-09-11T12:00:48.554Z |
5013438 | 5013438 | 20240905103038_k2LE0 | US0027 | 2024-09-10T12:00:38.983Z | 2024-09-11T12:00:20.479Z |
5013370 | 5013370 | 20240905102247_XB1TY | US0027 | 2024-09-10T12:00:29.227Z | 2024-09-11T12:00:18.174Z |
5012417 | 5012417 | 20240903063320_HIzY2 | US0027 | 2024-09-09T12:17:51.291Z | 2024-09-11T12:21:17.607Z |
5012237 | 5012237 | 20240904090208_mYleC | US0027 | 2024-09-09T12:10:27.942Z | 2024-09-12T12:19:35.499Z |
5012003 | 5012003 | 20240904082647_SCDBf | US0027 | 2024-09-09T12:10:16.859Z | 2024-09-12T12:19:34.493Z |
5011822 | 5011822 | 20240904080004_Nk6cZ | US0027 | 2024-09-09T12:10:03.179Z | 2024-09-12T12:19:33.622Z |
5004547 | 5004547 | 20240903114516_zcHMc | US0027 | 2024-09-09T12:02:47.781Z | 2024-09-12T12:19:02.802Z |
5004483 | 5004483 | 20240903113619_h3tKB | US0027 | 2024-09-09T12:02:45.023Z | 2024-09-12T12:19:02.351Z |
5004460 | 5004460 | 20240903113149_R4Cnx | US0027 | 2024-09-09T12:02:43.664Z | 2024-09-12T12:19:02.260Z |
5004372 | 5004372 | 20240903112057_0cw3B | US0027 | 2024-09-09T12:02:39.160Z | 2024-09-12T12:19:01.824Z |
5003392 | 5003392 | 20240903084317_BN5S1 | US0027 | 2024-09-09T12:01:40.932Z | 2024-09-12T12:18:56.247Z |
5003316 | 5003316 | 20240904113808_2JYZ2 | US0027 | 2024-09-09T12:01:33.864Z | 2024-09-13T12:19:44.026Z |
5003268 | 5003268 | 20240904113028_cb4Cc | US0027 | 2024-09-09T12:01:31.042Z | 2024-09-13T12:19:43.948Z |
5003199 | 5003199 | 20240904112312_Ig33V | US0027 | 2024-09-09T12:01:27.086Z | 2024-09-13T12:19:43.672Z |
5002976 | 5002976 | 20240904110231_AGyYn | US0027 | 2024-09-09T12:01:14.573Z | 2024-09-13T12:19:42.577Z |
5002264 | 5002264 | 20240904092855_wB2OW | US0027 | 2024-09-09T12:00:20.139Z | 2024-09-13T12:19:40.188Z |
5002038 | 5002038 | 20240902073125_724nJ | US0027 | 2024-09-08T12:17:07.961Z | 2024-09-10T12:19:35.960Z |
4999009 | 4999009 | 20240903045820_9erVM | US0027 | 2024-09-08T12:08:18.833Z | 2024-09-11T12:21:15.979Z |
4992951 | 4992951 | 20240902091854_zUvTd | US0027 | 2024-09-08T12:01:02.191Z | 2024-09-11T12:20:18.719Z |
4985147 | 4985147 | 20240901113810_7qIZ9 | US0027 | 2024-09-07T12:02:53.967Z | 2024-09-10T12:19:06.957Z |
4985122 | 4985122 | 20240901113434_0qoSZ | US0027 | 2024-09-07T12:02:51.151Z | 2024-09-10T12:19:06.950Z |
4985060 | 4985060 | 20240901112514_lprj2 | US0027 | 2024-09-07T12:02:47.314Z | 2024-09-10T12:19:06.878Z |
4984970 | 4984970 | 20240901111321_EbuRN | US0027 | 2024-09-07T12:02:41.087Z | 2024-09-10T12:19:06.731Z |
4984595 | 4984595 | 20240901102944_2gWcS | US0027 | 2024-09-07T12:02:06.895Z | 2024-09-10T12:19:05.654Z |
4984559 | 4984559 | 20240901102331_bgdjb | US0027 | 2024-09-07T12:02:04.186Z | 2024-09-10T12:19:05.591Z |
4983745 | 4983745 | 20240901075618_SGcCJ | US0027 | 2024-09-07T12:00:43.563Z | 2024-09-10T12:19:03.222Z |
4904630 | 4904630 | 20240808063247_nfJ3M | US0027 | 2024-08-28T12:20:38.924Z | 2024-08-28T12:20:38.924Z |
4867806 | 4867806 | 20240806040436_AACjQ | US0027 | 2024-08-18T12:23:48.089Z | 2024-08-19T12:28:27.218Z |
4840561 | 4840561 | 20240805114020_Zm6fY | US0027 | 2024-08-16T12:04:42.411Z | 2024-08-19T12:17:13.058Z |
4840417 | 4840417 | 20240805112718_ghMjA | US0027 | 2024-08-16T12:04:27.855Z | 2024-08-19T12:17:08.510Z |
4837883 | 4837883 | 20240805080243_MqqmS | US0027 | 2024-08-16T12:01:30.048Z | 2024-08-19T12:15:27.596Z |
4819608 | 4819608 | 20240804115703_jPrr2 | US0027 | 2024-08-14T12:05:17.905Z | 2024-08-17T12:25:48.080Z |
4819600 | 4819600 | 20240804115650_TnQLE | US0027 | 2024-08-14T12:05:17.392Z | 2024-08-17T12:25:47.890Z |
4819290 | 4819290 | 20240804111628_XlNX2 | US0027 | 2024-08-14T12:04:38.160Z | 2024-08-17T12:25:21.445Z |
4819209 | 4819209 | 20240804110313_1DkFF | US0027 | 2024-08-14T12:04:30.169Z | 2024-08-17T12:25:17.320Z |
4818949 | 4818949 | 20240804103050_9mOk0 | US0027 | 2024-08-14T12:03:52.903Z | 2024-08-17T12:24:55.846Z |
4817873 | 4817873 | 20240804075813_r9vwC | US0027 | 2024-08-14T12:01:26.493Z | 2024-08-17T12:23:56.866Z |
4817766 | 4817766 | 20240804074129_HebHe | US0027 | 2024-08-14T12:01:09.437Z | 2024-08-17T12:23:45.981Z |
4817719 | 4817719 | 20240804072737_BpBz2 | US0027 | 2024-08-14T12:01:00.463Z | 2024-08-17T12:23:40.189Z |
4808315 | 4808315 | 20240803105817_gvv4V | US0027 | 2024-08-13T12:05:13.377Z | 2024-08-15T12:19:03.176Z |
4808122 | 4808122 | 20240803104524_MTG9z | US0027 | 2024-08-13T12:04:52.805Z | 2024-08-15T12:18:54.775Z |
4807725 | 4807725 | 20240803102102_nd6oB | US0027 | 2024-08-13T12:03:52.744Z | 2024-08-15T12:18:39.288Z |
4807221 | 4807221 | 20240803094133_q6FZG | US0027 | 2024-08-13T12:02:42.429Z | 2024-08-15T12:18:23.508Z |
4807170 | 4807170 | 20240803093743_Lwpk2 | US0027 | 2024-08-13T12:02:35.037Z | 2024-08-15T12:18:22.395Z |
4806972 | 4806972 | 20240803092100_2oXz5 | US0027 | 2024-08-13T12:02:03.026Z | 2024-08-15T12:18:16.745Z |
4806967 | 4806967 | 20240803092047_f3255 | US0027 | 2024-08-13T12:02:02.186Z | 2024-08-15T12:18:16.505Z |
4806963 | 4806963 | 20240803091811_P0cFd | US0027 | 2024-08-13T12:02:01.334Z | 2024-08-15T12:18:16.322Z |
4797779 | 4797779 | 20240803072052_0twQT | US0027 | 2024-08-12T12:01:37.827Z | 2024-08-15T12:17:20.716Z |
4797628 | 4797628 | 20240803065441_PRZwg | US0027 | 2024-08-12T12:01:09.539Z | 2024-08-15T12:17:16.405Z |
4797327 | 4797327 | 20240803043212_Skn37 | US0027 | 2024-08-12T12:00:12.209Z | 2024-08-15T12:17:05.801Z |
4788369 | 4788369 | 20240802090455_9Lm6N | US0027 | 2024-08-11T12:04:27.356Z | 2024-08-13T12:15:48.888Z |
4774171 | 4774171 | 20240801111421_Qm9mA | US0027 | 2024-08-07T12:07:09.538Z | 2024-08-11T12:12:16.257Z |
4774068 | 4774068 | 20240801110253_NiGpk | US0027 | 2024-08-07T12:07:00.992Z | 2024-08-11T12:12:14.595Z |
4773999 | 4773999 | 20240801105703_geney | US0027 | 2024-08-07T12:06:51.980Z | 2024-08-11T12:12:13.538Z |
4773859 | 4773859 | 20240801104119_KnmV0 | US0027 | 2024-08-07T12:06:35.518Z | 2024-08-11T12:12:09.245Z |
4773793 | 4773793 | 20240801103511_0IDoR | US0027 | 2024-08-07T12:06:25.329Z | 2024-08-11T12:12:07.464Z |
4772967 | 4772967 | 20240801085847_O3mJR | US0027 | 2024-08-07T12:04:57.290Z | 2024-08-11T12:11:46.720Z |
4772901 | 4772901 | 20240801084917_3tQIn | US0027 | 2024-08-07T12:04:49.816Z | 2024-08-11T12:11:43.861Z |
4772649 | 4772649 | 20240801075331_3vf9u | US0027 | 2024-08-07T12:04:07.291Z | 2024-08-11T12:11:34.840Z |
4772494 | 4772494 | 20240801072748_E3eFU | US0027 | 2024-08-07T12:03:47.980Z | 2024-08-11T12:11:29.978Z |
4772489 | 4772489 | 20240801072738_jIaal | US0027 | 2024-08-07T12:03:46.549Z | 2024-08-11T12:11:29.918Z |
4772469 | 4772469 | 20240801072501_tBZCQ | US0027 | 2024-08-07T12:03:40.951Z | 2024-08-11T12:11:29.526Z |
4771971 | 4771971 | 20240801050341_NafDw | US0027 | 2024-08-07T12:02:09.074Z | 2024-08-11T12:11:08.358Z |
4771942 | 4771942 | 20240801045453_OvTr3 | US0027 | 2024-08-07T12:02:04.933Z | 2024-08-11T12:11:07.537Z |
4771795 | 4771795 | 20240801040923_hAvyC | US0027 | 2024-08-07T12:01:34.693Z | 2024-08-11T12:11:00.633Z |
4765937 | 4765937 | 20240731113730_PH2mU | US0027 | 2024-08-06T12:07:55.843Z | 2024-08-10T12:19:13.590Z |
4765867 | 4765867 | 20240731112239_akARH | US0027 | 2024-08-06T12:07:50.507Z | 2024-08-10T12:19:12.575Z |
4765850 | 4765850 | 20240731112111_C3gAj | US0027 | 2024-08-06T12:07:48.895Z | 2024-08-10T12:19:12.333Z |
4765381 | 4765381 | 20240731103333_yXgtK | US0027 | 2024-08-06T12:07:14.478Z | 2024-08-10T12:19:05.049Z |
4765093 | 4765093 | 20240731100151_koIVv | US0027 | 2024-08-06T12:07:00.466Z | 2024-08-10T12:19:01.479Z |
4764853 | 4764853 | 20240731093907_4me44 | US0027 | 2024-08-06T12:06:49.581Z | 2024-08-10T12:18:57.771Z |
4764579 | 4764579 | 20240731090748_4GNu9 | US0027 | 2024-08-06T12:06:23.326Z | 2024-08-10T12:18:50.782Z |
4764551 | 4764551 | 20240731090504_agehP | US0027 | 2024-08-06T12:06:20.439Z | 2024-08-10T12:18:49.578Z |
4763970 | 4763970 | 20240731073804_2wFXR | US0027 | 2024-08-06T12:05:32.692Z | 2024-08-10T12:18:35.219Z |
4763481 | 4763481 | 20240731055821_xrl07 | US0027 | 2024-08-06T12:04:37.092Z | 2024-08-10T12:18:19.492Z |
4763433 | 4763433 | 20240731054629_GmPMl | US0027 | 2024-08-06T12:04:33.765Z | 2024-08-10T12:18:18.730Z |
4753034 | 4753034 | 20240730113954_fOnAW | US0027 | 2024-08-05T12:07:16.831Z | 2024-08-08T12:20:23.539Z |
4752951 | 4752951 | 20240730112916_9C2bU | US0027 | 2024-08-05T12:07:09.862Z | 2024-08-08T12:20:20.715Z |
4752942 | 4752942 | 20240730112806_9cpno | US0027 | 2024-08-05T12:07:09.066Z | 2024-08-08T12:20:20.516Z |
4746982 | 4746982 | 20240730071546_k4UT3 | US0027 | 2024-08-04T12:09:42.443Z | 2024-08-08T12:19:15.354Z |
4746712 | 4746712 | 20240730061832_wAZW3 | US0027 | 2024-08-04T12:09:25.118Z | 2024-08-08T12:19:02.140Z |
4746662 | 4746662 | 20240730060133_NQafa | US0027 | 2024-08-04T12:09:21.526Z | 2024-08-08T12:18:59.356Z |
4738524 | 4738524 | 20240729112136_zPWuS | US0027 | 2024-08-03T12:08:34.952Z | 2024-08-06T12:15:09.959Z |
4738328 | 4738328 | 20240729104612_b68ue | US0027 | 2024-08-03T12:08:12.021Z | 2024-08-06T12:15:09.217Z |
4738305 | 4738305 | 20240729103837_22mop | US0027 | 2024-08-03T12:08:08.777Z | 2024-08-06T12:15:08.966Z |
4738302 | 4738302 | 20240729103832_BxrIg | US0027 | 2024-08-03T12:08:08.392Z | 2024-08-06T12:15:08.966Z |
4738213 | 4738213 | 20240729100626_pcgvl | US0027 | 2024-08-03T12:07:52.660Z | 2024-08-06T12:15:08.578Z |
4738178 | 4738178 | 20240729095338_S0xtJ | US0027 | 2024-08-03T12:07:47.447Z | 2024-08-06T12:15:08.489Z |
4738167 | 4738167 | 20240729094632_gEpUh | US0027 | 2024-08-03T12:07:46.192Z | 2024-08-06T12:15:08.458Z |
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);