participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,333 rows where station_code = "MX0004" 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 |
---|---|---|---|---|---|
4495808 | 4495808 | 20240623060738_UP21C | MX0004 | 2024-06-24T12:02:56.033Z | 2024-07-01T12:12:25.787Z |
4494330 | 4494330 | 20240623092910_vLLrV | MX0004 | 2024-06-24T12:00:16.651Z | 2024-07-02T12:10:13.254Z |
4494295 | 4494295 | 20240623081619_tNSKQ | MX0004 | 2024-06-24T12:00:12.440Z | 2024-07-02T12:10:13.157Z |
4398350 | 4398350 | 20240601094733_2m22s | MX0004 | 2024-06-03T12:01:01.596Z | 2024-06-10T12:06:43.560Z |
4322752 | 4322752 | 20240508064538_ukW59 | MX0004 | 2024-05-16T12:11:12.758Z | 2024-05-17T12:12:55.016Z |
4176009 | 4176009 | 20240412060931_bCBn0 | MX0004 | 2024-04-13T12:07:26.187Z | 2024-04-20T12:25:34.810Z |
4114787 | 4114787 | 20240327075942_y8xqP | MX0004 | 2024-03-29T12:01:46.412Z | 2024-04-04T12:17:14.514Z |
4114643 | 4114643 | 20240327080643_aAqAz | MX0004 | 2024-03-28T12:03:40.144Z | 2024-04-04T12:17:14.641Z |
4111306 | 4111306 | 20240323113006_2ZVqS | MX0004 | 2024-03-25T12:09:11.570Z | 2024-03-31T12:17:03.584Z |
4111006 | 4111006 | 20240324091415_zET2o | MX0004 | 2024-03-25T12:04:17.603Z | 2024-04-01T12:16:15.684Z |
4082621 | 4082621 | 20240317105457_n6QTC | MX0004 | 2024-03-19T12:00:23.265Z | 2024-03-26T12:20:26.058Z |
4063513 | 4063513 | 20240312075158_xmx9E | MX0004 | 2024-03-13T12:06:28.923Z | 2024-03-20T12:21:40.209Z |
4063367 | 4063367 | 20240312063310_BsAmK | MX0004 | 2024-03-13T12:06:03.116Z | 2024-03-20T12:21:39.295Z |
4061881 | 4061881 | 20240312104040_dO3g1 | MX0004 | 2024-03-13T12:00:22.976Z | 2024-03-21T12:21:55.403Z |
4027762 | 4027762 | 20240304092047_Tq2jW | MX0004 | 2024-03-05T14:09:51.173Z | 2024-03-12T12:15:39.009Z |
4027051 | 4027051 | 20240304045359_Na30R | MX0004 | 2024-03-05T14:08:50.947Z | 2024-03-12T12:15:34.328Z |
4022054 | 4022054 | 20240303100016_Cemxt | MX0004 | 2024-03-04T14:08:25.096Z | 2024-03-11T12:18:47.170Z |
4021614 | 4021614 | 20240303064238_dbSWo | MX0004 | 2024-03-04T14:07:32.335Z | 2024-03-11T12:18:43.642Z |
3917010 | 3917010 | 20240204092546_rkEkn | MX0004 | 2024-02-05T14:04:56.238Z | 2024-02-12T14:23:21.186Z |
3916977 | 3916977 | 20240204091718_wFn5A | MX0004 | 2024-02-05T14:04:52.254Z | 2024-02-12T14:23:20.597Z |
3890001 | 3890001 | 20240127091506_t45rX | MX0004 | 2024-01-28T14:05:01.184Z | 2024-02-04T14:18:53.132Z |
3885177 | 3885177 | 20240124122058_5IMJb | MX0004 | 2024-01-26T14:05:25.994Z | 2024-02-01T14:18:08.063Z |
3884986 | 3884986 | 20240124094723_12NI4 | MX0004 | 2024-01-26T14:05:02.933Z | 2024-02-01T14:18:03.173Z |
3884961 | 3884961 | 20240124085811_i0hrY | MX0004 | 2024-01-26T14:05:00.405Z | 2024-02-01T14:18:02.963Z |
3884953 | 3884953 | 20240124081600_30L26 | MX0004 | 2024-01-26T14:04:58.712Z | 2024-02-01T14:18:02.715Z |
3884951 | 3884951 | 20240124080436_KGOQc | MX0004 | 2024-01-26T14:04:58.329Z | 2024-02-01T14:18:02.690Z |
3850716 | 3850716 | 20240117055112_neV1n | MX0004 | 2024-01-20T14:09:07.642Z | 2024-01-21T14:20:08.702Z |
3842110 | 3842110 | 20240116114848_nQKVP | MX0004 | 2024-01-19T14:08:25.875Z | 2024-01-25T14:21:58.157Z |
3841631 | 3841631 | 20240116110438_aKWDF | MX0004 | 2024-01-19T14:07:36.606Z | 2024-01-25T14:21:51.206Z |
3841462 | 3841462 | 20240116104934_3HaSp | MX0004 | 2024-01-19T14:07:20.524Z | 2024-01-25T14:21:49.152Z |
3841455 | 3841455 | 20240116104709_dStQl | MX0004 | 2024-01-19T14:07:19.297Z | 2024-01-25T14:21:49.050Z |
3841335 | 3841335 | 20240116103527_Cc2CN | MX0004 | 2024-01-19T14:07:01.309Z | 2024-01-25T14:21:47.116Z |
3841072 | 3841072 | 20240116094723_Bycg2 | MX0004 | 2024-01-19T14:06:23.465Z | 2024-01-25T14:21:43.595Z |
3841015 | 3841015 | 20240116093954_V0APq | MX0004 | 2024-01-19T14:06:18.727Z | 2024-01-25T14:21:42.658Z |
3840807 | 3840807 | 20240116090250_za728 | MX0004 | 2024-01-19T14:05:47.952Z | 2024-01-25T14:21:39.937Z |
3840713 | 3840713 | 20240116083530_HQ8SX | MX0004 | 2024-01-19T14:05:32.168Z | 2024-01-25T14:21:38.432Z |
3840452 | 3840452 | 20240116073642_zfnOU | MX0004 | 2024-01-19T14:05:01.244Z | 2024-01-25T14:21:34.406Z |
3839582 | 3839582 | 20240116053030_I0dyr | MX0004 | 2024-01-19T14:03:26.085Z | 2024-01-25T14:21:22.603Z |
3838788 | 3838788 | 20240116030918_NZ8M6 | MX0004 | 2024-01-19T14:01:28.020Z | 2024-01-25T14:21:09.609Z |
3814887 | 3814887 | 20240113061636_hGbxX | MX0004 | 2024-01-15T14:14:47.075Z | 2024-01-22T14:21:57.786Z |
3809957 | 3809957 | 20240112112016_dowIb | MX0004 | 2024-01-15T14:07:43.998Z | 2024-01-21T14:27:42.564Z |
3796167 | 3796167 | 20240110094259_aW285 | MX0004 | 2024-01-13T14:09:01.078Z | 2024-01-19T14:27:16.372Z |
3795615 | 3795615 | 20240110075454_w3V9L | MX0004 | 2024-01-13T14:07:42.088Z | 2024-01-19T14:27:10.247Z |
3795568 | 3795568 | 20240110073353_WEN7P | MX0004 | 2024-01-13T14:07:35.937Z | 2024-01-19T14:27:09.773Z |
3793830 | 3793830 | 20240110043724_U9jlb | MX0004 | 2024-01-13T14:04:23.729Z | 2024-01-19T14:26:50.485Z |
3786975 | 3786975 | 20240109112840_0tJTG | MX0004 | 2024-01-12T14:05:25.890Z | 2024-01-18T14:25:34.487Z |
3786935 | 3786935 | 20240109111936_CptX6 | MX0004 | 2024-01-12T14:05:13.640Z | 2024-01-18T14:25:33.498Z |
3781209 | 3781209 | 20240108105158_tuEe0 | MX0004 | 2024-01-11T14:05:57.557Z | 2024-01-17T14:23:24.460Z |
3780867 | 3780867 | 20240108090722_PMM7M | MX0004 | 2024-01-11T14:05:02.281Z | 2024-01-17T14:23:22.719Z |
3780857 | 3780857 | 20240108090256_V2B0d | MX0004 | 2024-01-11T14:05:00.092Z | 2024-01-17T14:23:22.700Z |
3764692 | 3764692 | 20240106120856_kn2J3 | MX0004 | 2024-01-09T14:02:53.909Z | 2024-01-15T14:24:03.681Z |
3757272 | 3757272 | 20240106074905_4ljJ0 | MX0004 | 2024-01-08T14:03:40.876Z | 2024-01-15T14:23:48.683Z |
3752066 | 3752066 | 20240104114812_wBZY4 | MX0004 | 2024-01-07T14:04:36.842Z | 2024-01-13T14:25:55.901Z |
3751735 | 3751735 | 20240104101153_tAT5x | MX0004 | 2024-01-07T14:03:45.264Z | 2024-01-13T14:25:52.769Z |
3751692 | 3751692 | 20240104095642_RyC21 | MX0004 | 2024-01-07T14:03:37.778Z | 2024-01-13T14:25:52.339Z |
3751665 | 3751665 | 20240104094329_mbFXR | MX0004 | 2024-01-07T14:03:27.929Z | 2024-01-13T14:25:51.720Z |
3751627 | 3751627 | 20240104092828_fpbyp | MX0004 | 2024-01-07T14:03:23.189Z | 2024-01-13T14:25:51.494Z |
3751417 | 3751417 | 20240104065931_AYRbQ | MX0004 | 2024-01-07T14:02:43.055Z | 2024-01-13T14:25:49.765Z |
3725877 | 3725877 | 20231231115001_LGD8n | MX0004 | 2024-01-06T00:06:08.821Z | 2024-01-09T14:31:04.098Z |
3725840 | 3725840 | 20231231113616_8gitF | MX0004 | 2024-01-06T00:06:08.816Z | 2024-01-09T14:31:02.897Z |
3725747 | 3725747 | 20231231110904_9mck6 | MX0004 | 2024-01-06T00:06:08.806Z | 2024-01-09T14:31:00.066Z |
3724931 | 3724931 | 20231231025905_AlyBC | MX0004 | 2024-01-06T00:06:07.384Z | 2024-01-08T14:25:31.090Z |
3719766 | 3719766 | 20231228111058_Uhv5O | MX0004 | 2024-01-06T00:06:04.132Z | 2024-01-06T14:20:27.610Z |
3719661 | 3719661 | 20231228091449_wUEI1 | MX0004 | 2024-01-06T00:06:04.117Z | 2024-01-06T14:20:24.075Z |
3719653 | 3719653 | 20231228090812_HMFUy | MX0004 | 2024-01-06T00:06:04.116Z | 2024-01-06T14:20:23.836Z |
3719257 | 3719257 | 20231228011349_PWAYc | MX0004 | 2024-01-06T00:06:02.804Z | 2024-01-06T01:01:35.437Z |
3702449 | 3702449 | 20231221114348_1R627 | MX0004 | 2024-01-06T00:05:51.653Z | 2024-01-06T00:05:51.653Z |
3701774 | 3701774 | 20231221091734_AhfqS | MX0004 | 2024-01-06T00:05:49.989Z | 2024-01-06T00:05:49.989Z |
3697175 | 3697175 | 20231220091250_aMz93 | MX0004 | 2024-01-06T00:05:46.492Z | 2024-01-06T00:05:46.492Z |
3697013 | 3697013 | 20231220080523_gxZ9y | MX0004 | 2024-01-06T00:05:46.415Z | 2024-01-06T00:05:46.415Z |
3697000 | 3697000 | 20231220075221_UzaR1 | MX0004 | 2024-01-06T00:05:46.409Z | 2024-01-06T00:05:46.409Z |
3696890 | 3696890 | 20231220065514_anD1n | MX0004 | 2024-01-06T00:05:46.325Z | 2024-01-06T00:05:46.325Z |
3696618 | 3696618 | 20231220055729_cxEPf | MX0004 | 2024-01-06T00:05:46.151Z | 2024-01-06T00:05:46.151Z |
3696594 | 3696594 | 20231220055343_eTz2G | MX0004 | 2024-01-06T00:05:46.127Z | 2024-01-06T00:05:46.127Z |
3694395 | 3694395 | 20231220021148_OH9Zj | MX0004 | 2024-01-06T00:05:45.247Z | 2024-01-06T00:05:45.247Z |
3689303 | 3689303 | 20231219111303_m1G72 | MX0004 | 2024-01-06T00:05:41.346Z | 2024-01-06T00:05:41.346Z |
3689246 | 3689246 | 20231219105050_qaHDs | MX0004 | 2024-01-06T00:05:41.330Z | 2024-01-06T00:05:41.330Z |
3688959 | 3688959 | 20231219085926_qRaWK | MX0004 | 2024-01-06T00:05:41.252Z | 2024-01-06T00:05:41.252Z |
3688934 | 3688934 | 20231219083756_GXF40 | MX0004 | 2024-01-06T00:05:41.245Z | 2024-01-06T00:05:41.245Z |
3688809 | 3688809 | 20231219061126_WNQ2t | MX0004 | 2024-01-06T00:05:41.212Z | 2024-01-06T00:05:41.212Z |
3685194 | 3685194 | 20231218115256_plSU0 | MX0004 | 2024-01-06T00:05:38.658Z | 2024-01-06T00:05:38.658Z |
3684591 | 3684591 | 20231218092334_U7sXK | MX0004 | 2024-01-06T00:05:38.590Z | 2024-01-06T00:05:38.590Z |
3684289 | 3684289 | 20231218073945_9wmPc | MX0004 | 2024-01-06T00:05:38.556Z | 2024-01-06T00:05:38.556Z |
3684252 | 3684252 | 20231218072908_zhmOe | MX0004 | 2024-01-06T00:05:38.552Z | 2024-01-06T00:05:38.552Z |
3684209 | 3684209 | 20231218071450_XsVyK | MX0004 | 2024-01-06T00:05:38.548Z | 2024-01-06T00:05:38.548Z |
3684159 | 3684159 | 20231218065415_jBo14 | MX0004 | 2024-01-06T00:05:38.542Z | 2024-01-06T00:05:38.542Z |
3684140 | 3684140 | 20231218064808_IlzMT | MX0004 | 2024-01-06T00:05:38.540Z | 2024-01-06T00:05:38.540Z |
3683954 | 3683954 | 20231218053635_33PCZ | MX0004 | 2024-01-06T00:05:38.517Z | 2024-01-06T00:05:38.517Z |
3682901 | 3682901 | 20231218022712_NP1ZB | MX0004 | 2024-01-06T00:05:38.364Z | 2024-01-06T00:05:38.364Z |
3676136 | 3676136 | 20231217082824_IPHdz | MX0004 | 2024-01-06T00:05:36.225Z | 2024-01-06T00:05:36.225Z |
3579163 | 3579163 | 20231212063318_fWfeP | MX0004 | 2024-01-06T00:05:15.328Z | 2024-01-06T00:05:15.328Z |
3579119 | 3579119 | 20231212062259_wAnZH | MX0004 | 2024-01-06T00:05:15.322Z | 2024-01-06T00:05:15.322Z |
3579089 | 3579089 | 20231212061618_EqHGl | MX0004 | 2024-01-06T00:05:15.318Z | 2024-01-06T00:05:15.318Z |
3579047 | 3579047 | 20231212060622_jPqOA | MX0004 | 2024-01-06T00:05:15.313Z | 2024-01-06T00:05:15.313Z |
3578982 | 3578982 | 20231212060025_jVGpS | MX0004 | 2024-01-06T00:05:15.305Z | 2024-01-06T00:05:15.305Z |
3578847 | 3578847 | 20231212053459_4agHH | MX0004 | 2024-01-06T00:05:15.289Z | 2024-01-06T00:05:15.289Z |
3561759 | 3561759 | 20231210061624_NfBME | MX0004 | 2024-01-06T00:05:10.652Z | 2024-01-06T00:05:10.652Z |
3559143 | 3559143 | 20231210023929_DNW3Q | MX0004 | 2024-01-06T00:05:10.393Z | 2024-01-06T00:05:10.393Z |
3553223 | 3553223 | 20231209121142_Wohgx | MX0004 | 2024-01-06T00:05:08.501Z | 2024-01-06T00:05:08.501Z |
3552837 | 3552837 | 20231209113628_Xkgx7 | MX0004 | 2024-01-06T00:05:08.462Z | 2024-01-06T00:05:08.462Z |
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);