participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,719 rows where station_code = "MX0003" 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 |
---|---|---|---|---|---|
5550693 | 5550693 | 20241118111049_JEumd | MX0003 | 2024-11-19T14:02:55.721Z | 2024-11-23T14:24:55.861Z |
5539184 | 5539184 | 20241114054632_G8ZX6 | MX0003 | 2024-11-15T14:00:19.155Z | 2024-11-23T14:26:01.134Z |
5525956 | 5525956 | 20241112073204_3yhvo | MX0003 | 2024-11-13T14:01:18.901Z | 2024-11-21T14:25:29.208Z |
5525794 | 5525794 | 20241112064555_bw0FT | MX0003 | 2024-11-13T14:00:46.427Z | 2024-11-21T14:25:26.727Z |
5506233 | 5506233 | 20241109075907_U8UYu | MX0003 | 2024-11-10T14:01:37.844Z | 2024-11-18T14:25:57.778Z |
5505769 | 5505769 | 20241109063413_RNbT3 | MX0003 | 2024-11-10T14:00:21.323Z | 2024-11-18T14:25:52.372Z |
5499240 | 5499240 | 20241108114220_6rrBI | MX0003 | 2024-11-09T14:03:36.470Z | 2024-11-17T14:23:08.257Z |
5499112 | 5499112 | 20241108111123_INwZ6 | MX0003 | 2024-11-09T14:03:14.161Z | 2024-11-17T14:23:06.262Z |
5493310 | 5493310 | 20241107114552_DLONf | MX0003 | 2024-11-08T14:03:31.673Z | 2024-11-16T14:27:33.445Z |
5493186 | 5493186 | 20241107111509_jWnt6 | MX0003 | 2024-11-08T14:03:04.859Z | 2024-11-16T14:27:32.839Z |
5492953 | 5492953 | 20241107102416_jPcgj | MX0003 | 2024-11-08T14:02:37.622Z | 2024-11-16T14:27:31.137Z |
5492710 | 5492710 | 20241107093835_2Zx62 | MX0003 | 2024-11-08T14:01:56.207Z | 2024-11-16T14:27:27.594Z |
5492391 | 5492391 | 20241107082200_j5Z36 | MX0003 | 2024-11-08T14:00:59.036Z | 2024-11-16T14:27:24.665Z |
5492262 | 5492262 | 20241107075037_MVjez | MX0003 | 2024-11-08T14:00:39.994Z | 2024-11-16T14:27:23.724Z |
5486001 | 5486001 | 20241106090539_sksJi | MX0003 | 2024-11-07T14:01:27.283Z | 2024-11-15T14:24:24.865Z |
5485713 | 5485713 | 20241106065211_uTor4 | MX0003 | 2024-11-07T14:00:22.489Z | 2024-11-15T14:24:22.718Z |
5485409 | 5485409 | 20241105052813_YUugT | MX0003 | 2024-11-06T14:18:13.005Z | 2024-11-13T14:27:42.125Z |
5485335 | 5485335 | 20241105045257_FTh22 | MX0003 | 2024-11-06T14:18:08.028Z | 2024-11-13T14:27:41.763Z |
5479960 | 5479960 | 20241105110908_oE1Nz | MX0003 | 2024-11-06T14:04:04.771Z | 2024-11-14T14:23:01.183Z |
5479937 | 5479937 | 20241105110532_s65cG | MX0003 | 2024-11-06T14:03:59.471Z | 2024-11-14T14:23:00.961Z |
5479521 | 5479521 | 20241105094845_ECfhS | MX0003 | 2024-11-06T14:02:38.741Z | 2024-11-14T14:22:59.193Z |
5479413 | 5479413 | 20241105092439_nLb2w | MX0003 | 2024-11-06T14:02:13.539Z | 2024-11-14T14:22:58.849Z |
5479015 | 5479015 | 20241105072911_OF54p | MX0003 | 2024-11-06T14:00:39.944Z | 2024-11-14T14:22:57.064Z |
5478899 | 5478899 | 20241105064824_7u26G | MX0003 | 2024-11-06T14:00:16.492Z | 2024-11-14T14:22:56.099Z |
5478773 | 5478773 | 20241104055832_GwNvj | MX0003 | 2024-11-05T14:18:49.042Z | 2024-11-12T14:28:16.955Z |
5470718 | 5470718 | 20241104093023_MdnOP | MX0003 | 2024-11-05T14:01:39.197Z | 2024-11-13T14:27:22.746Z |
5390197 | 5390197 | 20241026091501_GrgPk | MX0003 | 2024-10-28T12:02:21.101Z | 2024-11-04T14:28:26.982Z |
5390003 | 5390003 | 20241026083506_RJJuG | MX0003 | 2024-10-28T12:01:46.293Z | 2024-11-04T14:28:25.977Z |
5389983 | 5389983 | 20241026083144_WN9hZ | MX0003 | 2024-10-28T12:01:41.728Z | 2024-11-04T14:28:25.925Z |
5388816 | 5388816 | 20241025061317_ML3nU | MX0003 | 2024-10-27T12:22:32.097Z | 2024-11-02T12:28:35.034Z |
5388618 | 5388618 | 20241025053945_jJFan | MX0003 | 2024-10-27T12:22:23.695Z | 2024-11-02T12:28:34.683Z |
5387398 | 5387398 | 20241025023100_RLdUn | MX0003 | 2024-10-27T12:21:18.525Z | 2024-11-02T12:28:32.478Z |
5380427 | 5380427 | 20241025104719_ZEfqI | MX0003 | 2024-10-27T12:05:59.189Z | 2024-11-03T14:27:10.976Z |
5379840 | 5379840 | 20241025092323_0Ek9M | MX0003 | 2024-10-27T12:04:19.938Z | 2024-11-03T14:27:08.469Z |
5379617 | 5379617 | 20241025085216_PiErS | MX0003 | 2024-10-27T12:03:34.436Z | 2024-11-03T14:27:07.994Z |
5379346 | 5379346 | 20241025082222_of3c8 | MX0003 | 2024-10-27T12:02:47.939Z | 2024-11-03T14:27:06.774Z |
5379041 | 5379041 | 20241025074823_CE3jO | MX0003 | 2024-10-27T12:01:53.661Z | 2024-11-03T14:27:05.713Z |
5378837 | 5378837 | 20241025071850_R3H3q | MX0003 | 2024-10-27T12:01:02.393Z | 2024-11-03T14:27:05.166Z |
5378400 | 5378400 | 20241024061856_Ixgvv | MX0003 | 2024-10-26T12:23:01.291Z | 2024-11-01T12:27:04.139Z |
5375765 | 5375765 | 20241024032858_7NycX | MX0003 | 2024-10-26T12:21:39.040Z | 2024-11-01T12:27:01.189Z |
5374541 | 5374541 | 20241024023327_AVFfe | MX0003 | 2024-10-26T12:20:52.779Z | 2024-11-01T12:26:59.463Z |
5373059 | 5373059 | 20241024012203_oCjBV | MX0003 | 2024-10-26T12:19:55.530Z | 2024-11-01T12:26:58.108Z |
5368058 | 5368058 | 20241024082550_hGiV3 | MX0003 | 2024-10-26T12:02:25.027Z | 2024-11-02T12:28:14.999Z |
5367805 | 5367805 | 20241024074428_iOQr7 | MX0003 | 2024-10-26T12:01:33.917Z | 2024-11-02T12:28:14.623Z |
5367762 | 5367762 | 20241024073603_rgKyT | MX0003 | 2024-10-26T12:01:28.133Z | 2024-11-02T12:28:14.557Z |
5367457 | 5367457 | 20241024064818_RVhkn | MX0003 | 2024-10-26T12:00:31.558Z | 2024-11-02T12:28:13.858Z |
5366826 | 5366826 | 20241023042053_LDtQ5 | MX0003 | 2024-10-25T12:21:32.968Z | 2024-10-31T12:30:08.913Z |
5313689 | 5313689 | 20241016093518_e9z63 | MX0003 | 2024-10-17T12:00:50.930Z | 2024-10-25T12:24:26.688Z |
5313632 | 5313632 | 20241016091141_2JWK6 | MX0003 | 2024-10-17T12:00:42.953Z | 2024-10-25T12:24:26.213Z |
5313440 | 5313440 | 20241016065924_r3D3v | MX0003 | 2024-10-17T12:00:16.411Z | 2024-10-25T12:24:24.787Z |
5307794 | 5307794 | 20241015110534_P3Qyc | MX0003 | 2024-10-16T12:02:16.564Z | 2024-10-24T12:27:46.726Z |
5307541 | 5307541 | 20241015102657_62Usr | MX0003 | 2024-10-16T12:01:42.715Z | 2024-10-24T12:27:44.819Z |
5307384 | 5307384 | 20241015094435_3qETr | MX0003 | 2024-10-16T12:01:24.670Z | 2024-10-24T12:27:43.153Z |
5307305 | 5307305 | 20241015092702_CTmYO | MX0003 | 2024-10-16T12:01:10.042Z | 2024-10-24T12:27:42.401Z |
5307220 | 5307220 | 20241015084950_SbxsB | MX0003 | 2024-10-16T12:00:57.834Z | 2024-10-24T12:27:41.187Z |
5296740 | 5296740 | 20241012110156_DhKg0 | MX0003 | 2024-10-14T12:06:46.270Z | 2024-10-21T12:23:08.581Z |
5296351 | 5296351 | 20241012100131_K850t | MX0003 | 2024-10-14T12:05:49.040Z | 2024-10-21T12:23:02.938Z |
5295641 | 5295641 | 20241013083739_9tODy | MX0003 | 2024-10-14T12:03:00.046Z | 2024-10-22T12:24:13.874Z |
5286419 | 5286419 | 20241012083558_LRHla | MX0003 | 2024-10-13T12:02:27.664Z | 2024-10-21T12:22:54.107Z |
5286376 | 5286376 | 20241012082815_3qYMD | MX0003 | 2024-10-13T12:02:22.185Z | 2024-10-21T12:22:53.305Z |
5200778 | 5200778 | 20241001040801_dIhfU | MX0003 | 2024-10-02T12:02:48.513Z | 2024-10-10T12:24:32.634Z |
5153091 | 5153091 | 20240923111958_de3jP | MX0003 | 2024-09-24T12:05:55.208Z | 2024-10-01T12:22:17.041Z |
5151174 | 5151174 | 20240923032053_M2G9W | MX0003 | 2024-09-24T12:02:14.972Z | 2024-10-01T12:22:05.566Z |
5150846 | 5150846 | 20240923012801_EW5Px | MX0003 | 2024-09-24T12:01:27.606Z | 2024-10-01T12:22:03.453Z |
5150819 | 5150819 | 20240923011850_MNUhU | MX0003 | 2024-09-24T12:01:19.252Z | 2024-10-01T12:22:03.335Z |
5146942 | 5146942 | 20240922032318_I282L | MX0003 | 2024-09-23T12:04:05.971Z | 2024-09-30T12:22:40.946Z |
4931751 | 4931751 | 20240810110638_y6C3o | MX0003 | 2024-08-31T12:25:02.762Z | 2024-09-02T12:31:10.685Z |
4931270 | 4931270 | 20240810100912_w3DHV | MX0003 | 2024-08-31T12:24:27.677Z | 2024-09-02T12:30:46.473Z |
4931254 | 4931254 | 20240810100758_yLZku | MX0003 | 2024-08-31T12:24:27.184Z | 2024-09-02T12:30:46.066Z |
4931068 | 4931068 | 20240810093953_99Meb | MX0003 | 2024-08-31T12:24:14.271Z | 2024-09-02T12:30:37.734Z |
4931003 | 4931003 | 20240810092904_Jnif1 | MX0003 | 2024-08-31T12:24:08.004Z | 2024-09-02T12:30:35.282Z |
4929761 | 4929761 | 20240810060949_8gV6f | MX0003 | 2024-08-31T12:22:38.424Z | 2024-09-02T12:29:44.884Z |
4905375 | 4905375 | 20240808093155_LUPMI | MX0003 | 2024-08-28T12:21:22.871Z | 2024-08-28T12:21:22.871Z |
4905289 | 4905289 | 20240808090419_zTJIf | MX0003 | 2024-08-28T12:21:15.305Z | 2024-08-28T12:21:15.305Z |
4904702 | 4904702 | 20240808065551_qPInV | MX0003 | 2024-08-28T12:20:41.661Z | 2024-08-28T12:20:41.661Z |
4904493 | 4904493 | 20240808060158_wzai8 | MX0003 | 2024-08-28T12:20:32.429Z | 2024-08-28T12:20:32.429Z |
4904182 | 4904182 | 20240808042558_Gv1qj | MX0003 | 2024-08-28T12:20:09.408Z | 2024-08-28T12:20:09.408Z |
4893013 | 4893013 | 20240809080825_Nmsyf | MX0003 | 2024-08-28T12:10:56.372Z | 2024-08-30T12:22:42.885Z |
4892659 | 4892659 | 20240809052932_UM0Pl | MX0003 | 2024-08-28T12:10:28.277Z | 2024-08-30T12:22:24.580Z |
4885388 | 4885388 | 20240808100949_EDFw1 | MX0003 | 2024-08-28T12:00:32.639Z | 2024-08-30T12:15:31.194Z |
4885350 | 4885350 | 20240808100433_5CBsC | MX0003 | 2024-08-28T12:00:28.111Z | 2024-08-30T12:15:29.520Z |
4868864 | 4868864 | 20240806071816_DJmyc | MX0003 | 2024-08-18T12:24:33.707Z | 2024-08-19T12:29:05.339Z |
4868749 | 4868749 | 20240806070825_DDpia | MX0003 | 2024-08-18T12:24:28.103Z | 2024-08-19T12:28:58.957Z |
4868695 | 4868695 | 20240806070132_3Qk4O | MX0003 | 2024-08-18T12:24:23.758Z | 2024-08-19T12:28:55.828Z |
4867932 | 4867932 | 20240806044722_yAAzf | MX0003 | 2024-08-18T12:23:54.181Z | 2024-08-19T12:28:30.799Z |
4860883 | 4860883 | 20240806110841_wpQks | MX0003 | 2024-08-18T12:03:12.416Z | 2024-08-27T12:03:10.808Z |
4859136 | 4859136 | 20240806091712_G3OkP | MX0003 | 2024-08-18T12:01:31.062Z | 2024-08-27T12:01:39.644Z |
4858489 | 4858489 | 20240806083148_6zppC | MX0003 | 2024-08-18T12:00:55.965Z | 2024-08-27T12:01:03.862Z |
4847889 | 4847889 | 20240805062710_KWFFC | MX0003 | 2024-08-16T12:21:16.657Z | 2024-08-17T12:33:20.162Z |
4847887 | 4847887 | 20240805062709_450jC | MX0003 | 2024-08-16T12:21:16.549Z | 2024-08-17T12:33:20.103Z |
4837303 | 4837303 | 20240805065454_jxqY5 | MX0003 | 2024-08-16T12:00:33.754Z | 2024-08-19T12:14:54.413Z |
4837258 | 4837258 | 20240805064856_LmiML | MX0003 | 2024-08-16T12:00:28.313Z | 2024-08-19T12:14:50.819Z |
4826604 | 4826604 | 20240804045844_fwM26 | MX0003 | 2024-08-14T12:21:15.816Z | 2024-08-15T12:26:22.424Z |
4818610 | 4818610 | 20240804095409_CF4cJ | MX0003 | 2024-08-14T12:03:12.562Z | 2024-08-17T12:24:44.483Z |
4818528 | 4818528 | 20240804093746_mNzga | MX0003 | 2024-08-14T12:03:02.691Z | 2024-08-17T12:24:41.731Z |
4818452 | 4818452 | 20240804092644_jRoKM | MX0003 | 2024-08-14T12:02:50.312Z | 2024-08-17T12:24:39.190Z |
4818451 | 4818451 | 20240804092601_36C8m | MX0003 | 2024-08-14T12:02:49.770Z | 2024-08-17T12:24:39.091Z |
4818408 | 4818408 | 20240804092059_S0YBB | MX0003 | 2024-08-14T12:02:44.591Z | 2024-08-17T12:24:37.193Z |
4817675 | 4817675 | 20240804071551_6EY1Y | MX0003 | 2024-08-14T12:00:54.642Z | 2024-08-17T12:23:37.413Z |
4817486 | 4817486 | 20240804060734_EFjds | MX0003 | 2024-08-14T12:00:24.204Z | 2024-08-17T12:23:21.273Z |
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);