participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,396 rows where station_code = "MX0009" 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 |
---|---|---|---|---|---|
5506234 | 5506234 | 20241109075907_U8UYu | MX0009 | 2024-11-10T14:01:37.844Z | 2024-11-12T14:18:20.683Z |
5505770 | 5505770 | 20241109063413_RNbT3 | MX0009 | 2024-11-10T14:00:21.323Z | 2024-11-12T14:18:12.042Z |
5499241 | 5499241 | 20241108114220_6rrBI | MX0009 | 2024-11-09T14:03:36.470Z | 2024-11-12T14:22:29.682Z |
5499113 | 5499113 | 20241108111123_INwZ6 | MX0009 | 2024-11-09T14:03:14.161Z | 2024-11-12T14:22:27.371Z |
5497727 | 5497727 | 20241107044449_0SnCg | MX0009 | 2024-11-08T14:14:16.445Z | 2024-11-12T14:26:13.897Z |
5497522 | 5497522 | 20241107035447_htc3L | MX0009 | 2024-11-08T14:13:55.957Z | 2024-11-12T14:26:12.491Z |
5497214 | 5497214 | 20241107025820_AePPx | MX0009 | 2024-11-08T14:13:22.384Z | 2024-11-12T14:26:10.023Z |
5493311 | 5493311 | 20241107114552_DLONf | MX0009 | 2024-11-08T14:03:31.673Z | 2024-11-12T14:24:09.624Z |
5493187 | 5493187 | 20241107111509_jWnt6 | MX0009 | 2024-11-08T14:03:04.859Z | 2024-11-12T14:24:08.161Z |
5492937 | 5492937 | 20241107102213_UzQ3K | MX0009 | 2024-11-08T14:02:36.317Z | 2024-11-12T14:24:04.003Z |
5492876 | 5492876 | 20241107101412_f0j6S | MX0009 | 2024-11-08T14:02:22.159Z | 2024-11-12T14:24:02.934Z |
5492711 | 5492711 | 20241107093835_2Zx62 | MX0009 | 2024-11-08T14:01:56.207Z | 2024-11-12T14:24:00.339Z |
5492532 | 5492532 | 20241107085435_NMy9Z | MX0009 | 2024-11-08T14:01:21.891Z | 2024-11-12T14:23:57.706Z |
5492504 | 5492504 | 20241107084559_yZkHz | MX0009 | 2024-11-08T14:01:18.468Z | 2024-11-12T14:23:57.320Z |
5492392 | 5492392 | 20241107082200_j5Z36 | MX0009 | 2024-11-08T14:00:59.036Z | 2024-11-12T14:23:55.796Z |
5492263 | 5492263 | 20241107075037_MVjez | MX0009 | 2024-11-08T14:00:39.994Z | 2024-11-12T14:23:54.263Z |
5486002 | 5486002 | 20241106090539_sksJi | MX0009 | 2024-11-07T14:01:27.283Z | 2024-11-12T14:25:25.447Z |
5484785 | 5484785 | 20241105033028_xuJ78 | MX0009 | 2024-11-06T14:17:16.844Z | 2024-11-12T14:27:35.469Z |
5483568 | 5483568 | 20241105005843_cVU4A | MX0009 | 2024-11-06T14:15:29.337Z | 2024-11-12T14:27:28.960Z |
5479961 | 5479961 | 20241105110908_oE1Nz | MX0009 | 2024-11-06T14:04:04.772Z | 2024-11-12T14:26:27.055Z |
5479938 | 5479938 | 20241105110532_s65cG | MX0009 | 2024-11-06T14:03:59.471Z | 2024-11-12T14:26:26.987Z |
5479518 | 5479518 | 20241105094819_oJsZw | MX0009 | 2024-11-06T14:02:37.456Z | 2024-11-12T14:26:24.496Z |
5479016 | 5479016 | 20241105072911_OF54p | MX0009 | 2024-11-06T14:00:39.944Z | 2024-11-12T14:26:19.963Z |
5478900 | 5478900 | 20241105064824_7u26G | MX0009 | 2024-11-06T14:00:16.504Z | 2024-11-12T14:26:18.539Z |
5478774 | 5478774 | 20241104055832_GwNvj | MX0009 | 2024-11-05T14:18:49.042Z | 2024-11-12T14:28:16.955Z |
5470767 | 5470767 | 20241104094626_OUQ3d | MX0009 | 2024-11-05T14:01:47.486Z | 2024-11-12T14:27:01.027Z |
5470719 | 5470719 | 20241104093023_MdnOP | MX0009 | 2024-11-05T14:01:39.197Z | 2024-11-12T14:27:00.612Z |
5401680 | 5401680 | 20241026092008_G4Pxr | MX0009 | 2024-10-29T12:03:03.063Z | 2024-11-04T14:28:27.214Z |
5400194 | 5400194 | 20241026055756_O34ep | MX0009 | 2024-10-28T12:20:27.149Z | 2024-11-03T14:27:41.622Z |
5390199 | 5390199 | 20241026091501_GrgPk | MX0009 | 2024-10-28T12:02:21.112Z | 2024-11-04T14:28:26.983Z |
5389984 | 5389984 | 20241026083144_WN9hZ | MX0009 | 2024-10-28T12:01:41.755Z | 2024-11-04T14:28:25.925Z |
5388534 | 5388534 | 20241025052037_EF75W | MX0009 | 2024-10-27T12:22:19.888Z | 2024-11-02T12:28:34.407Z |
5387400 | 5387400 | 20241025023100_RLdUn | MX0009 | 2024-10-27T12:21:18.534Z | 2024-11-02T12:28:32.478Z |
5380428 | 5380428 | 20241025104719_ZEfqI | MX0009 | 2024-10-27T12:05:59.189Z | 2024-11-03T14:27:10.976Z |
5380037 | 5380037 | 20241025094920_Gp8NU | MX0009 | 2024-10-27T12:04:57.706Z | 2024-11-03T14:27:09.749Z |
5379841 | 5379841 | 20241025092323_0Ek9M | MX0009 | 2024-10-27T12:04:19.938Z | 2024-11-03T14:27:08.469Z |
5379042 | 5379042 | 20241025074823_CE3jO | MX0009 | 2024-10-27T12:01:53.661Z | 2024-11-03T14:27:05.713Z |
5378838 | 5378838 | 20241025071850_R3H3q | MX0009 | 2024-10-27T12:01:02.393Z | 2024-11-03T14:27:05.166Z |
5378449 | 5378449 | 20241024063259_xOsr3 | MX0009 | 2024-10-26T12:23:01.865Z | 2024-11-01T12:27:04.237Z |
5378401 | 5378401 | 20241024061856_Ixgvv | MX0009 | 2024-10-26T12:23:01.291Z | 2024-11-01T12:27:04.139Z |
5375766 | 5375766 | 20241024032858_7NycX | MX0009 | 2024-10-26T12:21:39.040Z | 2024-11-01T12:27:01.189Z |
5374542 | 5374542 | 20241024023327_AVFfe | MX0009 | 2024-10-26T12:20:52.779Z | 2024-11-01T12:26:59.463Z |
5368059 | 5368059 | 20241024082550_hGiV3 | MX0009 | 2024-10-26T12:02:25.027Z | 2024-11-02T12:28:14.999Z |
5367763 | 5367763 | 20241024073603_rgKyT | MX0009 | 2024-10-26T12:01:28.133Z | 2024-11-02T12:28:14.557Z |
5367458 | 5367458 | 20241024064818_RVhkn | MX0009 | 2024-10-26T12:00:31.558Z | 2024-11-02T12:28:13.858Z |
5313690 | 5313690 | 20241016093518_e9z63 | MX0009 | 2024-10-17T12:00:50.930Z | 2024-10-25T12:24:26.688Z |
5313633 | 5313633 | 20241016091141_2JWK6 | MX0009 | 2024-10-17T12:00:42.953Z | 2024-10-25T12:24:26.213Z |
5313441 | 5313441 | 20241016065924_r3D3v | MX0009 | 2024-10-17T12:00:16.412Z | 2024-10-25T12:24:24.787Z |
5307795 | 5307795 | 20241015110534_P3Qyc | MX0009 | 2024-10-16T12:02:16.564Z | 2024-10-24T12:27:46.726Z |
5307542 | 5307542 | 20241015102657_62Usr | MX0009 | 2024-10-16T12:01:42.715Z | 2024-10-24T12:27:44.819Z |
5307385 | 5307385 | 20241015094435_3qETr | MX0009 | 2024-10-16T12:01:24.670Z | 2024-10-24T12:27:43.153Z |
5307306 | 5307306 | 20241015092702_CTmYO | MX0009 | 2024-10-16T12:01:10.042Z | 2024-10-24T12:27:42.401Z |
5307221 | 5307221 | 20241015084950_SbxsB | MX0009 | 2024-10-16T12:00:57.844Z | 2024-10-24T12:27:41.187Z |
5296741 | 5296741 | 20241012110156_DhKg0 | MX0009 | 2024-10-14T12:06:46.270Z | 2024-10-21T12:23:08.581Z |
5296352 | 5296352 | 20241012100131_K850t | MX0009 | 2024-10-14T12:05:49.040Z | 2024-10-21T12:23:02.938Z |
5295642 | 5295642 | 20241013083739_9tODy | MX0009 | 2024-10-14T12:03:00.046Z | 2024-10-22T12:24:13.874Z |
5286420 | 5286420 | 20241012083558_LRHla | MX0009 | 2024-10-13T12:02:27.664Z | 2024-10-21T12:22:54.107Z |
5286377 | 5286377 | 20241012082815_3qYMD | MX0009 | 2024-10-13T12:02:22.186Z | 2024-10-21T12:22:53.305Z |
5271234 | 5271234 | 20241010112941_V7uI1 | MX0009 | 2024-10-11T12:06:25.264Z | 2024-10-19T12:27:04.037Z |
5153092 | 5153092 | 20240923111958_de3jP | MX0009 | 2024-09-24T12:05:55.208Z | 2024-10-01T12:22:17.041Z |
5151193 | 5151193 | 20240923032726_f21Nr | MX0009 | 2024-09-24T12:02:19.380Z | 2024-10-01T12:22:05.626Z |
5151175 | 5151175 | 20240923032053_M2G9W | MX0009 | 2024-09-24T12:02:14.972Z | 2024-10-01T12:22:05.566Z |
5150847 | 5150847 | 20240923012801_EW5Px | MX0009 | 2024-09-24T12:01:27.606Z | 2024-10-01T12:22:03.453Z |
5150820 | 5150820 | 20240923011850_MNUhU | MX0009 | 2024-09-24T12:01:19.252Z | 2024-10-01T12:22:03.335Z |
5147115 | 5147115 | 20240922041423_GL0Ey | MX0009 | 2024-09-23T12:04:31.856Z | 2024-09-30T12:22:41.685Z |
5146943 | 5146943 | 20240922032318_I282L | MX0009 | 2024-09-23T12:04:05.973Z | 2024-09-30T12:22:40.946Z |
4904703 | 4904703 | 20240808065551_qPInV | MX0009 | 2024-08-28T12:20:41.661Z | 2024-08-28T12:20:41.661Z |
4904494 | 4904494 | 20240808060158_wzai8 | MX0009 | 2024-08-28T12:20:32.429Z | 2024-08-28T12:20:32.429Z |
4868865 | 4868865 | 20240806071816_DJmyc | MX0009 | 2024-08-18T12:24:33.707Z | 2024-08-19T12:29:05.339Z |
4868750 | 4868750 | 20240806070825_DDpia | MX0009 | 2024-08-18T12:24:28.104Z | 2024-08-19T12:28:58.957Z |
4868696 | 4868696 | 20240806070132_3Qk4O | MX0009 | 2024-08-18T12:24:23.758Z | 2024-08-19T12:28:55.828Z |
4868129 | 4868129 | 20240806054739_iveKG | MX0009 | 2024-08-18T12:23:59.837Z | 2024-08-19T12:28:34.930Z |
4868039 | 4868039 | 20240806052408_8QY0E | MX0009 | 2024-08-18T12:23:57.355Z | 2024-08-19T12:28:32.744Z |
4867933 | 4867933 | 20240806044722_yAAzf | MX0009 | 2024-08-18T12:23:54.181Z | 2024-08-19T12:28:30.799Z |
4867823 | 4867823 | 20240806041012_RCKX3 | MX0009 | 2024-08-18T12:23:49.956Z | 2024-08-19T12:28:27.819Z |
4860884 | 4860884 | 20240806110841_wpQks | MX0009 | 2024-08-18T12:03:12.416Z | 2024-08-27T12:03:10.808Z |
4859137 | 4859137 | 20240806091712_G3OkP | MX0009 | 2024-08-18T12:01:31.062Z | 2024-08-27T12:01:39.645Z |
4858490 | 4858490 | 20240806083148_6zppC | MX0009 | 2024-08-18T12:00:55.965Z | 2024-08-27T12:01:03.862Z |
4847890 | 4847890 | 20240805062710_KWFFC | MX0009 | 2024-08-16T12:21:16.657Z | 2024-08-17T12:33:20.162Z |
4847888 | 4847888 | 20240805062709_450jC | MX0009 | 2024-08-16T12:21:16.568Z | 2024-08-17T12:33:20.103Z |
4847654 | 4847654 | 20240805050754_tuQ7k | MX0009 | 2024-08-16T12:21:04.984Z | 2024-08-17T12:33:10.456Z |
4837304 | 4837304 | 20240805065454_jxqY5 | MX0009 | 2024-08-16T12:00:33.755Z | 2024-08-19T12:14:54.413Z |
4837259 | 4837259 | 20240805064856_LmiML | MX0009 | 2024-08-16T12:00:28.314Z | 2024-08-19T12:14:50.819Z |
4826605 | 4826605 | 20240804045844_fwM26 | MX0009 | 2024-08-14T12:21:15.816Z | 2024-08-15T12:26:22.424Z |
4818674 | 4818674 | 20240804100135_5qbn3 | MX0009 | 2024-08-14T12:03:18.398Z | 2024-08-17T12:24:46.067Z |
4818453 | 4818453 | 20240804092644_jRoKM | MX0009 | 2024-08-14T12:02:50.312Z | 2024-08-17T12:24:39.191Z |
4817972 | 4817972 | 20240804081145_vuPjC | MX0009 | 2024-08-14T12:01:38.633Z | 2024-08-17T12:24:06.091Z |
4817676 | 4817676 | 20240804071551_6EY1Y | MX0009 | 2024-08-14T12:00:54.642Z | 2024-08-17T12:23:37.413Z |
4817432 | 4817432 | 20240804053521_Z8PnU | MX0009 | 2024-08-14T12:00:12.751Z | 2024-08-17T12:23:18.303Z |
4746301 | 4746301 | 20240730032612_jksjT | MX0009 | 2024-08-04T12:08:22.757Z | 2024-08-08T12:18:39.351Z |
4675993 | 4675993 | 20240722032318_7XLEt | MX0009 | 2024-07-23T12:02:00.164Z | 2024-07-30T12:18:10.307Z |
4651104 | 4651104 | 20240715042918_zbMpV | MX0009 | 2024-07-17T12:09:46.971Z | 2024-07-23T12:08:48.772Z |
4643937 | 4643937 | 20240715104114_Og2jJ | MX0009 | 2024-07-17T12:00:47.698Z | 2024-07-24T12:16:38.119Z |
4643803 | 4643803 | 20240715095954_zKMFx | MX0009 | 2024-07-17T12:00:33.529Z | 2024-07-24T12:16:33.765Z |
4643794 | 4643794 | 20240715095729_I5adz | MX0009 | 2024-07-17T12:00:31.451Z | 2024-07-24T12:16:33.529Z |
4643782 | 4643782 | 20240715095354_gPF0X | MX0009 | 2024-07-17T12:00:29.115Z | 2024-07-24T12:16:33.340Z |
4599046 | 4599046 | 20240708104508_mCM86 | MX0009 | 2024-07-11T12:05:34.690Z | 2024-07-16T12:09:19.004Z |
4599024 | 4599024 | 20240708103914_tSB02 | MX0009 | 2024-07-11T12:05:33.150Z | 2024-07-16T12:09:18.829Z |
4598907 | 4598907 | 20240708102128_OTfJk | MX0009 | 2024-07-11T12:05:22.028Z | 2024-07-16T12:09:18.124Z |
4598288 | 4598288 | 20240708081712_LBicA | MX0009 | 2024-07-11T12:04:17.107Z | 2024-07-16T12:09:15.739Z |
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);