participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
386 rows where station_code = "MX000B" 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 |
---|---|---|---|---|---|
4930755 | 4930755 | 20240810085722_s2veb | MX000B | 2024-08-31T12:23:51.493Z | 2024-09-02T12:30:25.131Z |
4930748 | 4930748 | 20240810085632_v1x5s | MX000B | 2024-08-31T12:23:51.322Z | 2024-09-02T12:30:24.999Z |
4930574 | 4930574 | 20240810083003_zUYAZ | MX000B | 2024-08-31T12:23:41.045Z | 2024-09-02T12:30:19.817Z |
4930405 | 4930405 | 20240810080842_exZCN | MX000B | 2024-08-31T12:23:27.944Z | 2024-09-02T12:30:11.781Z |
4905379 | 4905379 | 20240808093348_qDPMO | MX000B | 2024-08-28T12:21:23.082Z | 2024-08-28T12:21:23.082Z |
4905176 | 4905176 | 20240808084015_r9Y39 | MX000B | 2024-08-28T12:21:09.248Z | 2024-08-28T12:21:09.248Z |
4905169 | 4905169 | 20240808083955_ondCK | MX000B | 2024-08-28T12:21:08.911Z | 2024-08-28T12:21:08.911Z |
4905114 | 4905114 | 20240808083100_IK2O5 | MX000B | 2024-08-28T12:21:05.786Z | 2024-08-28T12:21:05.786Z |
4905093 | 4905093 | 20240808082550_EzaNy | MX000B | 2024-08-28T12:21:03.100Z | 2024-08-28T12:21:03.100Z |
4904955 | 4904955 | 20240808075809_cgHi2 | MX000B | 2024-08-28T12:20:51.167Z | 2024-08-28T12:20:51.167Z |
4893395 | 4893395 | 20240809092935_85Mlt | MX000B | 2024-08-28T12:11:25.246Z | 2024-08-30T12:22:56.192Z |
4893096 | 4893096 | 20240809083005_aIBTr | MX000B | 2024-08-28T12:11:01.031Z | 2024-08-30T12:22:46.270Z |
4893068 | 4893068 | 20240809082021_2ZbVG | MX000B | 2024-08-28T12:10:58.937Z | 2024-08-30T12:22:44.696Z |
4893023 | 4893023 | 20240809081021_rHeTH | MX000B | 2024-08-28T12:10:56.761Z | 2024-08-30T12:22:43.125Z |
4892913 | 4892913 | 20240809073924_sFe2F | MX000B | 2024-08-28T12:10:50.260Z | 2024-08-30T12:22:39.434Z |
4892855 | 4892855 | 20240809071950_SrpQz | MX000B | 2024-08-28T12:10:46.745Z | 2024-08-30T12:22:37.316Z |
4892822 | 4892822 | 20240809070350_Ka9T3 | MX000B | 2024-08-28T12:10:44.468Z | 2024-08-30T12:22:35.926Z |
4892752 | 4892752 | 20240809064148_2PuTG | MX000B | 2024-08-28T12:10:35.850Z | 2024-08-30T12:22:30.986Z |
4892684 | 4892684 | 20240809061010_rEGkV | MX000B | 2024-08-28T12:10:31.186Z | 2024-08-30T12:22:26.165Z |
4892660 | 4892660 | 20240809053101_eP434 | MX000B | 2024-08-28T12:10:28.422Z | 2024-08-30T12:22:24.856Z |
4892611 | 4892611 | 20240809041213_JDyr8 | MX000B | 2024-08-28T12:10:24.910Z | 2024-08-30T12:22:20.523Z |
4885670 | 4885670 | 20240808110003_cku3t | MX000B | 2024-08-28T12:01:02.599Z | 2024-08-30T12:15:46.923Z |
4885526 | 4885526 | 20240808103055_Rg635 | MX000B | 2024-08-28T12:00:48.465Z | 2024-08-30T12:15:37.559Z |
4885428 | 4885428 | 20240808101453_V2ewa | MX000B | 2024-08-28T12:00:37.650Z | 2024-08-30T12:15:33.241Z |
4885285 | 4885285 | 20240808095459_3vNRz | MX000B | 2024-08-28T12:00:20.955Z | 2024-08-30T12:15:26.786Z |
4580757 | 4580757 | 20240707094754_JTQLf | MX000B | 2024-07-09T12:03:44.313Z | 2024-07-15T12:12:15.371Z |
4580494 | 4580494 | 20240707085259_fECbz | MX000B | 2024-07-09T12:03:28.313Z | 2024-07-15T12:12:12.696Z |
4580472 | 4580472 | 20240707084547_n7IMb | MX000B | 2024-07-09T12:03:27.224Z | 2024-07-15T12:12:12.508Z |
4570959 | 4570959 | 20240706040629_JC38G | MX000B | 2024-07-08T12:03:19.451Z | 2024-07-14T12:13:54.768Z |
4481974 | 4481974 | 20240618103907_dC4VO | MX000B | 2024-06-20T12:01:46.850Z | 2024-06-27T12:11:14.341Z |
4481597 | 4481597 | 20240618092316_9wB3I | MX000B | 2024-06-20T12:01:06.804Z | 2024-06-27T12:11:09.443Z |
4476016 | 4476016 | 20240617094759_hf02H | MX000B | 2024-06-19T12:02:57.712Z | 2024-06-26T12:14:15.675Z |
4475508 | 4475508 | 20240617071912_quhU6 | MX000B | 2024-06-19T12:01:56.833Z | 2024-06-26T12:14:12.408Z |
4473020 | 4473020 | 20240616101800_hxPBm | MX000B | 2024-06-18T12:03:16.945Z | 2024-06-24T12:11:17.939Z |
4472986 | 4472986 | 20240616100919_GieTk | MX000B | 2024-06-18T12:03:13.945Z | 2024-06-24T12:11:17.166Z |
4472913 | 4472913 | 20240616095333_1rT7u | MX000B | 2024-06-18T12:03:07.701Z | 2024-06-24T12:11:15.417Z |
4472753 | 4472753 | 20240616090013_EIK3J | MX000B | 2024-06-18T12:02:50.506Z | 2024-06-24T12:11:12.217Z |
4472723 | 4472723 | 20240616085030_tM8bB | MX000B | 2024-06-18T12:02:46.858Z | 2024-06-24T12:11:11.602Z |
4472181 | 4472181 | 20240616061822_3b1ou | MX000B | 2024-06-18T12:01:44.660Z | 2024-06-24T12:11:04.892Z |
4472057 | 4472057 | 20240616052917_JTg1c | MX000B | 2024-06-18T12:01:28.811Z | 2024-06-24T12:11:02.385Z |
4465359 | 4465359 | 20240615093250_3mMP9 | MX000B | 2024-06-16T12:04:17.941Z | 2024-06-23T12:12:07.818Z |
4465192 | 4465192 | 20240615084446_uGpKV | MX000B | 2024-06-16T12:03:56.223Z | 2024-06-23T12:12:03.896Z |
4464682 | 4464682 | 20240615064718_3QYuI | MX000B | 2024-06-16T12:02:58.892Z | 2024-06-23T12:11:53.408Z |
4464472 | 4464472 | 20240615051418_V5Pfv | MX000B | 2024-06-16T12:02:25.047Z | 2024-06-23T12:11:47.837Z |
4464373 | 4464373 | 20240615043516_sum2S | MX000B | 2024-06-16T12:02:14.081Z | 2024-06-23T12:11:46.048Z |
4464321 | 4464321 | 20240615041025_seFxD | MX000B | 2024-06-16T12:01:58.464Z | 2024-06-23T12:11:44.044Z |
4461060 | 4461060 | 20240614092436_V2MfZ | MX000B | 2024-06-15T12:03:58.305Z | 2024-06-22T12:16:29.998Z |
4461055 | 4461055 | 20240614092336_9IqNf | MX000B | 2024-06-15T12:03:57.777Z | 2024-06-22T12:16:29.897Z |
4460693 | 4460693 | 20240614054841_rwwq4 | MX000B | 2024-06-15T12:02:45.696Z | 2024-06-22T12:16:24.437Z |
4460667 | 4460667 | 20240614051733_UaRft | MX000B | 2024-06-15T12:02:41.719Z | 2024-06-22T12:16:24.236Z |
4460658 | 4460658 | 20240614051355_kMddl | MX000B | 2024-06-15T12:02:40.809Z | 2024-06-22T12:16:24.159Z |
4457257 | 4457257 | 20240613070657_9LZNp | MX000B | 2024-06-14T12:02:46.657Z | 2024-06-21T12:11:38.259Z |
4457067 | 4457067 | 20240613061345_QxcO8 | MX000B | 2024-06-14T12:02:33.326Z | 2024-06-21T12:11:36.920Z |
4457064 | 4457064 | 20240613061344_ZGTDO | MX000B | 2024-06-14T12:02:33.143Z | 2024-06-21T12:11:36.915Z |
4456855 | 4456855 | 20240613040953_Nx2DK | MX000B | 2024-06-14T12:02:15.885Z | 2024-06-21T12:11:34.616Z |
4450652 | 4450652 | 20240612095359_UQYNs | MX000B | 2024-06-13T12:02:58.694Z | 2024-06-20T12:12:00.157Z |
4450644 | 4450644 | 20240612095206_H3Q7g | MX000B | 2024-06-13T12:02:58.047Z | 2024-06-20T12:12:00.060Z |
4450137 | 4450137 | 20240612065330_osanU | MX000B | 2024-06-13T12:02:23.069Z | 2024-06-20T12:11:57.438Z |
4449905 | 4449905 | 20240612052301_2y3k2 | MX000B | 2024-06-13T12:02:00.933Z | 2024-06-20T12:11:55.807Z |
4398680 | 4398680 | 20240601110151_gQNVq | MX000B | 2024-06-03T12:01:51.243Z | 2024-06-10T12:06:44.330Z |
4394757 | 4394757 | 20240531095842_w75S7 | MX000B | 2024-06-01T12:01:17.408Z | 2024-06-09T12:05:58.105Z |
4389527 | 4389527 | 20240530065211_vMQmE | MX000B | 2024-05-31T12:00:19.618Z | 2024-06-08T12:14:00.694Z |
4389517 | 4389517 | 20240530064616_CAU6G | MX000B | 2024-05-31T12:00:18.327Z | 2024-06-08T12:14:00.662Z |
4368926 | 4368926 | 20240518110557_6iTG9 | MX000B | 2024-05-26T12:07:15.279Z | 2024-05-26T12:09:53.096Z |
4195544 | 4195544 | 20240415085318_b5npa | MX000B | 2024-04-17T12:06:17.791Z | 2024-04-23T12:25:01.812Z |
4195424 | 4195424 | 20240415080220_f5g9l | MX000B | 2024-04-17T12:05:54.161Z | 2024-04-23T12:24:59.561Z |
4176685 | 4176685 | 20240412104615_1kQQT | MX000B | 2024-04-13T12:08:48.103Z | 2024-04-20T12:25:42.290Z |
4176531 | 4176531 | 20240412094548_N9sKD | MX000B | 2024-04-13T12:08:31.497Z | 2024-04-20T12:25:40.167Z |
4144635 | 4144635 | 20240403110730_41pAZ | MX000B | 2024-04-05T12:09:55.703Z | 2024-04-11T12:23:55.827Z |
4143493 | 4143493 | 20240404085139_YC2V1 | MX000B | 2024-04-05T12:05:16.032Z | 2024-04-12T12:19:50.456Z |
4143180 | 4143180 | 20240404060731_WY9CQ | MX000B | 2024-04-05T12:04:28.652Z | 2024-04-12T12:19:48.542Z |
4124905 | 4124905 | 20240330053851_vPA9u | MX000B | 2024-03-31T12:08:45.995Z | 2024-04-07T12:24:27.393Z |
4114770 | 4114770 | 20240327073322_jCYKo | MX000B | 2024-03-29T12:01:41.811Z | 2024-04-04T12:17:14.308Z |
4113313 | 4113313 | 20240326045645_kKQSN | MX000B | 2024-03-27T12:02:49.951Z | 2024-04-03T12:18:08.311Z |
4111049 | 4111049 | 20240324113323_4RYo5 | MX000B | 2024-03-25T12:04:24.051Z | 2024-04-01T12:16:18.946Z |
4105653 | 4105653 | 20240322110856_pI0lG | MX000B | 2024-03-23T12:09:05.749Z | 2024-03-30T12:18:24.145Z |
4102064 | 4102064 | 20240320100835_87XWC | MX000B | 2024-03-22T12:13:31.239Z | 2024-03-28T12:21:10.215Z |
4101783 | 4101783 | 20240320090009_PjvBK | MX000B | 2024-03-22T12:13:10.557Z | 2024-03-28T12:21:06.370Z |
4101578 | 4101578 | 20240320080610_ZtXe9 | MX000B | 2024-03-22T12:12:49.945Z | 2024-03-28T12:21:03.100Z |
4088499 | 4088499 | 20240318095330_Pdvw2 | MX000B | 2024-03-19T12:14:15.830Z | 2024-03-26T12:21:19.318Z |
4088302 | 4088302 | 20240317094524_eJEDn | MX000B | 2024-03-19T12:13:45.543Z | 2024-03-25T12:22:33.830Z |
4088142 | 4088142 | 20240317082819_j2Iow | MX000B | 2024-03-19T12:13:33.538Z | 2024-03-25T12:22:30.726Z |
4082584 | 4082584 | 20240317104425_vFFOn | MX000B | 2024-03-19T12:00:14.650Z | 2024-03-26T12:20:25.660Z |
4082573 | 4082573 | 20240315074353_0FMHR | MX000B | 2024-03-18T12:13:24.793Z | 2024-03-23T12:26:03.246Z |
4072626 | 4072626 | 20240314094323_KD8Q5 | MX000B | 2024-03-16T12:13:09.593Z | 2024-03-22T12:17:46.014Z |
4068763 | 4068763 | 20240313092021_zm5h6 | MX000B | 2024-03-15T12:09:26.112Z | 2024-03-21T12:22:24.744Z |
4066032 | 4066032 | 20240313105243_McAgN | MX000B | 2024-03-15T12:00:28.978Z | 2024-03-22T12:17:28.328Z |
4063469 | 4063469 | 20240312073353_LNzBz | MX000B | 2024-03-13T12:06:16.023Z | 2024-03-20T12:21:39.877Z |
4061824 | 4061824 | 20240312102032_XxX40 | MX000B | 2024-03-13T12:00:13.296Z | 2024-03-21T12:21:54.198Z |
4052498 | 4052498 | 20240309094938_8BxaP | MX000B | 2024-03-10T12:10:46.442Z | 2024-03-17T12:18:37.444Z |
4052191 | 4052191 | 20240309065550_wCRH3 | MX000B | 2024-03-10T12:10:18.874Z | 2024-03-17T12:18:32.817Z |
4052169 | 4052169 | 20240309062757_Pvm3c | MX000B | 2024-03-10T12:10:16.087Z | 2024-03-17T12:18:32.369Z |
4052128 | 4052128 | 20240309054834_B2elv | MX000B | 2024-03-10T12:10:12.949Z | 2024-03-17T12:18:31.059Z |
4047850 | 4047850 | 20240308103713_RtK3G | MX000B | 2024-03-10T12:01:22.933Z | 2024-03-17T12:17:47.010Z |
4041896 | 4041896 | 20240307071747_nfBns | MX000B | 2024-03-08T14:09:27.269Z | 2024-03-15T12:19:41.351Z |
4036989 | 4036989 | 20240307114455_wm7tb | MX000B | 2024-03-08T14:00:52.818Z | 2024-03-16T12:21:10.635Z |
4036713 | 4036713 | 20240307102908_Z0Sht | MX000B | 2024-03-08T14:00:17.148Z | 2024-03-16T12:21:06.944Z |
4036539 | 4036539 | 20240306100358_hmC3f | MX000B | 2024-03-07T14:09:41.623Z | 2024-03-14T12:25:40.713Z |
4036347 | 4036347 | 20240306083217_ysb27 | MX000B | 2024-03-07T14:09:20.607Z | 2024-03-14T12:25:36.411Z |
4036248 | 4036248 | 20240306072948_4S6PT | MX000B | 2024-03-07T14:09:12.385Z | 2024-03-14T12:25:34.888Z |
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);