participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
775 rows where station_code = "MX0002" 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 |
---|---|---|---|---|---|
4957947 | 4957947 | 20240811093921_siq0i | MX0002 | 2024-09-03T12:21:56.715Z | 2024-09-06T12:31:45.147Z |
4931142 | 4931142 | 20240810094726_AY4dM | MX0002 | 2024-08-31T12:24:17.584Z | 2024-09-02T12:30:40.826Z |
4930970 | 4930970 | 20240810092513_uI3y2 | MX0002 | 2024-08-31T12:24:04.648Z | 2024-09-02T12:30:33.706Z |
4930573 | 4930573 | 20240810083003_zUYAZ | MX0002 | 2024-08-31T12:23:41.045Z | 2024-09-02T12:30:19.817Z |
4930404 | 4930404 | 20240810080842_exZCN | MX0002 | 2024-08-31T12:23:27.935Z | 2024-09-02T12:30:11.781Z |
4905378 | 4905378 | 20240808093348_qDPMO | MX0002 | 2024-08-28T12:21:23.082Z | 2024-08-28T12:21:23.082Z |
4905341 | 4905341 | 20240808092319_m1a06 | MX0002 | 2024-08-28T12:21:21.533Z | 2024-08-28T12:21:21.533Z |
4905319 | 4905319 | 20240808091636_H50ce | MX0002 | 2024-08-28T12:21:20.204Z | 2024-08-28T12:21:20.204Z |
4905168 | 4905168 | 20240808083955_ondCK | MX0002 | 2024-08-28T12:21:08.911Z | 2024-08-28T12:21:08.911Z |
4905154 | 4905154 | 20240808083758_MgM3z | MX0002 | 2024-08-28T12:21:08.367Z | 2024-08-28T12:21:08.367Z |
4905096 | 4905096 | 20240808082753_IsMjN | MX0002 | 2024-08-28T12:21:03.197Z | 2024-08-28T12:21:03.197Z |
4904954 | 4904954 | 20240808075809_cgHi2 | MX0002 | 2024-08-28T12:20:51.167Z | 2024-08-28T12:20:51.167Z |
4904594 | 4904594 | 20240808061742_zv3Jd | MX0002 | 2024-08-28T12:20:37.335Z | 2024-08-28T12:20:37.335Z |
4904385 | 4904385 | 20240808053521_08prx | MX0002 | 2024-08-28T12:20:21.086Z | 2024-08-28T12:20:21.086Z |
4893541 | 4893541 | 20240809100004_1NN3p | MX0002 | 2024-08-28T12:11:32.246Z | 2024-08-30T12:23:00.656Z |
4893524 | 4893524 | 20240809095225_tB7NJ | MX0002 | 2024-08-28T12:11:31.187Z | 2024-08-30T12:23:00.170Z |
4893095 | 4893095 | 20240809083005_aIBTr | MX0002 | 2024-08-28T12:11:01.031Z | 2024-08-30T12:22:46.270Z |
4893067 | 4893067 | 20240809082021_2ZbVG | MX0002 | 2024-08-28T12:10:58.937Z | 2024-08-30T12:22:44.696Z |
4893063 | 4893063 | 20240809081807_0QPc2 | MX0002 | 2024-08-28T12:10:58.727Z | 2024-08-30T12:22:44.539Z |
4893022 | 4893022 | 20240809081021_rHeTH | MX0002 | 2024-08-28T12:10:56.760Z | 2024-08-30T12:22:43.125Z |
4892821 | 4892821 | 20240809070350_Ka9T3 | MX0002 | 2024-08-28T12:10:44.468Z | 2024-08-30T12:22:35.926Z |
4892728 | 4892728 | 20240809063208_90nOs | MX0002 | 2024-08-28T12:10:34.150Z | 2024-08-30T12:22:28.542Z |
4892683 | 4892683 | 20240809061010_rEGkV | MX0002 | 2024-08-28T12:10:31.178Z | 2024-08-30T12:22:26.165Z |
4892669 | 4892669 | 20240809054816_v5T0T | MX0002 | 2024-08-28T12:10:29.035Z | 2024-08-30T12:22:25.358Z |
4885675 | 4885675 | 20240808110245_QKZZg | MX0002 | 2024-08-28T12:01:03.233Z | 2024-08-30T12:15:47.259Z |
4885669 | 4885669 | 20240808110003_cku3t | MX0002 | 2024-08-28T12:01:02.599Z | 2024-08-30T12:15:46.923Z |
4885525 | 4885525 | 20240808103055_Rg635 | MX0002 | 2024-08-28T12:00:48.465Z | 2024-08-30T12:15:37.559Z |
4885481 | 4885481 | 20240808102520_KQipv | MX0002 | 2024-08-28T12:00:44.831Z | 2024-08-30T12:15:35.496Z |
4885427 | 4885427 | 20240808101453_V2ewa | MX0002 | 2024-08-28T12:00:37.634Z | 2024-08-30T12:15:33.241Z |
4885284 | 4885284 | 20240808095459_3vNRz | MX0002 | 2024-08-28T12:00:20.946Z | 2024-08-30T12:15:26.786Z |
4868291 | 4868291 | 20240806062044_hLgNb | MX0002 | 2024-08-18T12:24:05.050Z | 2024-08-19T12:28:43.472Z |
4867758 | 4867758 | 20240806035214_v7AoY | MX0002 | 2024-08-18T12:23:43.661Z | 2024-08-19T12:28:26.248Z |
4858271 | 4858271 | 20240806080855_78UK2 | MX0002 | 2024-08-18T12:00:40.653Z | 2024-08-27T12:00:47.999Z |
4858177 | 4858177 | 20240806080302_Xk0iB | MX0002 | 2024-08-18T12:00:32.755Z | 2024-08-27T12:00:41.225Z |
4858055 | 4858055 | 20240806075249_2BhwI | MX0002 | 2024-08-18T12:00:23.213Z | 2024-08-27T12:00:32.794Z |
4857921 | 4857921 | 20240806073640_6VWH8 | MX0002 | 2024-08-18T12:00:11.321Z | 2024-08-27T12:00:22.511Z |
4847911 | 4847911 | 20240805063022_rJ7GH | MX0002 | 2024-08-16T12:21:19.037Z | 2024-08-17T12:33:20.829Z |
4847882 | 4847882 | 20240805062559_6OfaJ | MX0002 | 2024-08-16T12:21:16.192Z | 2024-08-17T12:33:19.880Z |
4847847 | 4847847 | 20240805061523_pZN6d | MX0002 | 2024-08-16T12:21:14.242Z | 2024-08-17T12:33:18.046Z |
4847450 | 4847450 | 20240805034939_3oAG8 | MX0002 | 2024-08-16T12:20:53.634Z | 2024-08-17T12:33:02.279Z |
4840296 | 4840296 | 20240805112046_eFdyj | MX0002 | 2024-08-16T12:04:21.246Z | 2024-08-19T12:17:02.617Z |
4840142 | 4840142 | 20240805111005_Q7w4a | MX0002 | 2024-08-16T12:04:15.176Z | 2024-08-19T12:16:59.747Z |
4839364 | 4839364 | 20240805101654_RIwI4 | MX0002 | 2024-08-16T12:03:26.958Z | 2024-08-19T12:16:41.315Z |
4839049 | 4839049 | 20240805094734_xwARG | MX0002 | 2024-08-16T12:03:02.628Z | 2024-08-19T12:16:20.472Z |
4838640 | 4838640 | 20240805091149_LtXca | MX0002 | 2024-08-16T12:02:32.767Z | 2024-08-19T12:15:55.495Z |
4838454 | 4838454 | 20240805085612_dP5jp | MX0002 | 2024-08-16T12:02:21.387Z | 2024-08-19T12:15:46.098Z |
4838023 | 4838023 | 20240805082016_pRlQX | MX0002 | 2024-08-16T12:01:45.310Z | 2024-08-19T12:15:32.028Z |
4837987 | 4837987 | 20240805081442_3HLzb | MX0002 | 2024-08-16T12:01:39.980Z | 2024-08-19T12:15:30.627Z |
4837916 | 4837916 | 20240805080720_OGZPC | MX0002 | 2024-08-16T12:01:33.174Z | 2024-08-19T12:15:28.757Z |
4837856 | 4837856 | 20240805075814_qv8zN | MX0002 | 2024-08-16T12:01:28.366Z | 2024-08-19T12:15:26.781Z |
4837673 | 4837673 | 20240805073207_5uEYi | MX0002 | 2024-08-16T12:01:11.659Z | 2024-08-19T12:15:20.510Z |
4837453 | 4837453 | 20240805071013_iGxYz | MX0002 | 2024-08-16T12:00:49.574Z | 2024-08-19T12:15:08.191Z |
4837359 | 4837359 | 20240805070145_1kUDr | MX0002 | 2024-08-16T12:00:41.012Z | 2024-08-19T12:15:00.528Z |
4837311 | 4837311 | 20240805065642_HzRlD | MX0002 | 2024-08-16T12:00:35.115Z | 2024-08-19T12:14:55.340Z |
4837245 | 4837245 | 20240805064818_cy3aP | MX0002 | 2024-08-16T12:00:27.064Z | 2024-08-19T12:14:50.252Z |
4826647 | 4826647 | 20240804052557_4sLBA | MX0002 | 2024-08-14T12:21:17.870Z | 2024-08-15T12:26:23.372Z |
4826503 | 4826503 | 20240804034734_yNS3S | MX0002 | 2024-08-14T12:21:09.594Z | 2024-08-15T12:26:20.341Z |
4826501 | 4826501 | 20240804034729_XlVTe | MX0002 | 2024-08-14T12:21:09.516Z | 2024-08-15T12:26:20.273Z |
4826463 | 4826463 | 20240804033404_4mFQe | MX0002 | 2024-08-14T12:21:07.650Z | 2024-08-15T12:26:19.662Z |
4818781 | 4818781 | 20240804101229_zEfoq | MX0002 | 2024-08-14T12:03:30.722Z | 2024-08-17T12:24:49.955Z |
4818625 | 4818625 | 20240804095552_21NqL | MX0002 | 2024-08-14T12:03:13.965Z | 2024-08-17T12:24:44.924Z |
4818580 | 4818580 | 20240804094841_oP2KI | MX0002 | 2024-08-14T12:03:09.548Z | 2024-08-17T12:24:43.334Z |
4818546 | 4818546 | 20240804094338_vCAcJ | MX0002 | 2024-08-14T12:03:05.868Z | 2024-08-17T12:24:42.283Z |
4817535 | 4817535 | 20240804063307_2O0u9 | MX0002 | 2024-08-14T12:00:32.806Z | 2024-08-17T12:23:26.636Z |
4817499 | 4817499 | 20240804061405_r2Trh | MX0002 | 2024-08-14T12:00:27.003Z | 2024-08-17T12:23:22.691Z |
4817478 | 4817478 | 20240804060444_rFB7u | MX0002 | 2024-08-14T12:00:23.177Z | 2024-08-17T12:23:20.633Z |
4817441 | 4817441 | 20240804054448_2CoUr | MX0002 | 2024-08-14T12:00:14.757Z | 2024-08-17T12:23:18.783Z |
4817430 | 4817430 | 20240804053509_UINs2 | MX0002 | 2024-08-14T12:00:12.294Z | 2024-08-17T12:23:18.186Z |
4807890 | 4807890 | 20240803103158_pH2i3 | MX0002 | 2024-08-13T12:04:19.757Z | 2024-08-15T12:18:43.211Z |
4807751 | 4807751 | 20240803102220_0LZm2 | MX0002 | 2024-08-13T12:03:55.599Z | 2024-08-15T12:18:40.034Z |
4807734 | 4807734 | 20240803102120_bQgmE | MX0002 | 2024-08-13T12:03:53.254Z | 2024-08-15T12:18:39.463Z |
4807685 | 4807685 | 20240803101825_xdYUB | MX0002 | 2024-08-13T12:03:45.464Z | 2024-08-15T12:18:36.797Z |
4807265 | 4807265 | 20240803094610_ANfPs | MX0002 | 2024-08-13T12:02:54.975Z | 2024-08-15T12:18:24.726Z |
4807065 | 4807065 | 20240803092707_ppdig | MX0002 | 2024-08-13T12:02:19.013Z | 2024-08-15T12:18:19.161Z |
4806939 | 4806939 | 20240803091604_daeMc | MX0002 | 2024-08-13T12:01:58.203Z | 2024-08-15T12:18:15.666Z |
4798452 | 4798452 | 20240803085106_Xyhxs | MX0002 | 2024-08-12T12:03:39.892Z | 2024-08-15T12:18:02.647Z |
4798393 | 4798393 | 20240803084223_1joll | MX0002 | 2024-08-12T12:03:30.522Z | 2024-08-15T12:17:53.089Z |
4798296 | 4798296 | 20240803083230_vh8H4 | MX0002 | 2024-08-12T12:03:19.652Z | 2024-08-15T12:17:45.364Z |
4798289 | 4798289 | 20240803083152_Odges | MX0002 | 2024-08-12T12:03:18.903Z | 2024-08-15T12:17:44.462Z |
4797967 | 4797967 | 20240803074927_SqvqW | MX0002 | 2024-08-12T12:02:11.514Z | 2024-08-15T12:17:28.549Z |
4797806 | 4797806 | 20240803072500_2tUB2 | MX0002 | 2024-08-12T12:01:42.116Z | 2024-08-15T12:17:21.608Z |
4797730 | 4797730 | 20240803071428_k5uwd | MX0002 | 2024-08-12T12:01:28.051Z | 2024-08-15T12:17:19.247Z |
4797726 | 4797726 | 20240803071209_RJJ5G | MX0002 | 2024-08-12T12:01:26.970Z | 2024-08-15T12:17:19.093Z |
4797095 | 4797095 | 20240802025121_Gvezd | MX0002 | 2024-08-11T12:16:18.089Z | 2024-08-11T12:16:18.089Z |
4787038 | 4787038 | 20240802041049_pa504 | MX0002 | 2024-08-11T12:00:43.176Z | 2024-08-13T12:15:15.236Z |
4746401 | 4746401 | 20240730043237_ocSfp | MX0002 | 2024-08-04T12:08:38.594Z | 2024-08-08T12:18:43.504Z |
4581192 | 4581192 | 20240706102952_mbgl3 | MX0002 | 2024-07-09T12:05:02.481Z | 2024-07-14T12:14:04.783Z |
4581017 | 4581017 | 20240707104900_3PRi8 | MX0002 | 2024-07-09T12:03:55.138Z | 2024-07-15T12:12:17.284Z |
4580756 | 4580756 | 20240707094754_JTQLf | MX0002 | 2024-07-09T12:03:44.313Z | 2024-07-15T12:12:15.371Z |
4580745 | 4580745 | 20240707094510_XxjE3 | MX0002 | 2024-07-09T12:03:43.849Z | 2024-07-15T12:12:15.338Z |
4580493 | 4580493 | 20240707085259_fECbz | MX0002 | 2024-07-09T12:03:28.313Z | 2024-07-15T12:12:12.696Z |
4580359 | 4580359 | 20240707081334_YZzjT | MX0002 | 2024-07-09T12:03:21.916Z | 2024-07-15T12:12:11.340Z |
4572533 | 4572533 | 20240706092021_pdvyV | MX0002 | 2024-07-08T12:05:31.135Z | 2024-07-14T12:14:02.100Z |
4571838 | 4571838 | 20240706075931_n2hcJ | MX0002 | 2024-07-08T12:04:40.414Z | 2024-07-14T12:13:59.427Z |
4571630 | 4571630 | 20240706072655_wDXQE | MX0002 | 2024-07-08T12:04:22.191Z | 2024-07-14T12:13:58.683Z |
4571543 | 4571543 | 20240706070928_W42Yk | MX0002 | 2024-07-08T12:04:14.241Z | 2024-07-14T12:13:58.143Z |
4571148 | 4571148 | 20240706053050_wbB7F | MX0002 | 2024-07-08T12:03:39.090Z | 2024-07-14T12:13:56.360Z |
4570958 | 4570958 | 20240706040629_JC38G | MX0002 | 2024-07-08T12:03:19.445Z | 2024-07-14T12:13:54.768Z |
4486591 | 4486591 | 20240619102724_372ia | MX0002 | 2024-06-21T12:02:40.528Z | 2024-06-28T12:09:29.297Z |
4481973 | 4481973 | 20240618103907_dC4VO | MX0002 | 2024-06-20T12:01:46.850Z | 2024-06-27T12:11:14.341Z |
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);