participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,067 rows where station_code = "MX0001" 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 |
---|---|---|---|---|---|
5518045 | 5518045 | 20241110054650_fBYfW | MX0001 | 2024-11-11T14:15:10.031Z | 2024-11-12T14:22:01.328Z |
5485712 | 5485712 | 20241106065211_uTor4 | MX0001 | 2024-11-07T14:00:22.454Z | 2024-11-12T14:25:23.215Z |
5485408 | 5485408 | 20241105052813_YUugT | MX0001 | 2024-11-06T14:18:13.005Z | 2024-11-12T14:27:38.599Z |
5485334 | 5485334 | 20241105045257_FTh22 | MX0001 | 2024-11-06T14:18:08.028Z | 2024-11-12T14:27:38.352Z |
5479520 | 5479520 | 20241105094845_ECfhS | MX0001 | 2024-11-06T14:02:38.741Z | 2024-11-12T14:26:24.497Z |
5479412 | 5479412 | 20241105092439_nLb2w | MX0001 | 2024-11-06T14:02:13.524Z | 2024-11-12T14:26:23.673Z |
5432917 | 5432917 | 20241029051531_267sR | MX0001 | 2024-10-31T12:21:38.786Z | 2024-11-06T14:27:29.282Z |
5390131 | 5390131 | 20241026085858_f2iGR | MX0001 | 2024-10-28T12:02:09.751Z | 2024-11-04T14:28:26.334Z |
5389999 | 5389999 | 20241026083504_o0wfG | MX0001 | 2024-10-28T12:01:45.430Z | 2024-11-04T14:28:25.975Z |
5389982 | 5389982 | 20241026083144_WN9hZ | MX0001 | 2024-10-28T12:01:41.728Z | 2024-11-04T14:28:25.925Z |
5389764 | 5389764 | 20241026075836_x8UQr | MX0001 | 2024-10-28T12:01:13.078Z | 2024-11-04T14:28:24.606Z |
5388815 | 5388815 | 20241025061317_ML3nU | MX0001 | 2024-10-27T12:22:32.097Z | 2024-11-02T12:28:35.034Z |
5388619 | 5388619 | 20241025054008_8F3P1 | MX0001 | 2024-10-27T12:22:23.747Z | 2024-11-02T12:28:34.684Z |
5388617 | 5388617 | 20241025053945_jJFan | MX0001 | 2024-10-27T12:22:23.695Z | 2024-11-02T12:28:34.683Z |
5379616 | 5379616 | 20241025085216_PiErS | MX0001 | 2024-10-27T12:03:34.436Z | 2024-11-03T14:27:07.994Z |
5379413 | 5379413 | 20241025083240_30uti | MX0001 | 2024-10-27T12:02:57.740Z | 2024-11-03T14:27:07.557Z |
5379400 | 5379400 | 20241025083033_6ijEm | MX0001 | 2024-10-27T12:02:56.319Z | 2024-11-03T14:27:07.543Z |
5379345 | 5379345 | 20241025082222_of3c8 | MX0001 | 2024-10-27T12:02:47.926Z | 2024-11-03T14:27:06.774Z |
5367804 | 5367804 | 20241024074428_iOQr7 | MX0001 | 2024-10-26T12:01:33.917Z | 2024-11-02T12:28:14.623Z |
5367686 | 5367686 | 20241024072407_3x62I | MX0001 | 2024-10-26T12:01:13.702Z | 2024-11-02T12:28:14.335Z |
5367456 | 5367456 | 20241024064818_RVhkn | MX0001 | 2024-10-26T12:00:31.546Z | 2024-11-02T12:28:13.858Z |
5356856 | 5356856 | 20241023080717_BI7vj | MX0001 | 2024-10-25T12:01:54.235Z | 2024-11-01T12:26:37.365Z |
5356420 | 5356420 | 20241023064704_XoEhU | MX0001 | 2024-10-25T12:00:30.434Z | 2024-11-01T12:26:35.714Z |
5356400 | 5356400 | 20241023064159_ry8yv | MX0001 | 2024-10-25T12:00:25.202Z | 2024-11-01T12:26:35.661Z |
5352823 | 5352823 | 20241023005216_UySV5 | MX0001 | 2024-10-24T12:19:16.231Z | 2024-10-31T12:30:03.355Z |
5313487 | 5313487 | 20241016074757_aqYy4 | MX0001 | 2024-10-17T12:00:23.459Z | 2024-10-25T12:24:25.306Z |
5313439 | 5313439 | 20241016065924_r3D3v | MX0001 | 2024-10-17T12:00:16.401Z | 2024-10-25T12:24:24.787Z |
5277841 | 5277841 | 20241011090018_wtXCP | MX0001 | 2024-10-12T12:04:39.315Z | 2024-10-20T12:23:34.605Z |
5277589 | 5277589 | 20241011082144_7dAXt | MX0001 | 2024-10-12T12:03:47.658Z | 2024-10-20T12:23:30.061Z |
5276892 | 5276892 | 20241011051643_W3H04 | MX0001 | 2024-10-12T12:01:59.924Z | 2024-10-20T12:23:15.096Z |
5221049 | 5221049 | 20241003084834_2wNxv | MX0001 | 2024-10-05T12:12:45.580Z | 2024-10-12T12:25:00.088Z |
5200777 | 5200777 | 20241001040801_dIhfU | MX0001 | 2024-10-02T12:02:48.512Z | 2024-10-10T12:24:32.634Z |
5150818 | 5150818 | 20240923011850_MNUhU | MX0001 | 2024-09-24T12:01:19.252Z | 2024-10-01T12:22:03.335Z |
4931750 | 4931750 | 20240810110638_y6C3o | MX0001 | 2024-08-31T12:25:02.762Z | 2024-09-02T12:31:10.685Z |
4931269 | 4931269 | 20240810100912_w3DHV | MX0001 | 2024-08-31T12:24:27.677Z | 2024-09-02T12:30:46.473Z |
4931253 | 4931253 | 20240810100758_yLZku | MX0001 | 2024-08-31T12:24:27.184Z | 2024-09-02T12:30:46.066Z |
4931067 | 4931067 | 20240810093953_99Meb | MX0001 | 2024-08-31T12:24:14.271Z | 2024-09-02T12:30:37.734Z |
4931002 | 4931002 | 20240810092904_Jnif1 | MX0001 | 2024-08-31T12:24:08.004Z | 2024-09-02T12:30:35.282Z |
4929760 | 4929760 | 20240810060949_8gV6f | MX0001 | 2024-08-31T12:22:38.411Z | 2024-09-02T12:29:44.884Z |
4905374 | 4905374 | 20240808093155_LUPMI | MX0001 | 2024-08-28T12:21:22.871Z | 2024-08-28T12:21:22.871Z |
4905288 | 4905288 | 20240808090419_zTJIf | MX0001 | 2024-08-28T12:21:15.305Z | 2024-08-28T12:21:15.305Z |
4904773 | 4904773 | 20240808071412_pwBpn | MX0001 | 2024-08-28T12:20:43.960Z | 2024-08-28T12:20:43.960Z |
4904593 | 4904593 | 20240808061742_zv3Jd | MX0001 | 2024-08-28T12:20:37.335Z | 2024-08-28T12:20:37.335Z |
4904181 | 4904181 | 20240808042558_Gv1qj | MX0001 | 2024-08-28T12:20:09.408Z | 2024-08-28T12:20:09.408Z |
4892730 | 4892730 | 20240809063231_ZNJnr | MX0001 | 2024-08-28T12:10:34.252Z | 2024-08-30T12:22:28.667Z |
4892668 | 4892668 | 20240809054816_v5T0T | MX0001 | 2024-08-28T12:10:29.035Z | 2024-08-30T12:22:25.358Z |
4892658 | 4892658 | 20240809052932_UM0Pl | MX0001 | 2024-08-28T12:10:28.277Z | 2024-08-30T12:22:24.580Z |
4885592 | 4885592 | 20240808104300_JsdNC | MX0001 | 2024-08-28T12:00:55.881Z | 2024-08-30T12:15:41.292Z |
4885387 | 4885387 | 20240808100949_EDFw1 | MX0001 | 2024-08-28T12:00:32.639Z | 2024-08-30T12:15:31.194Z |
4885349 | 4885349 | 20240808100433_5CBsC | MX0001 | 2024-08-28T12:00:28.096Z | 2024-08-30T12:15:29.520Z |
4826500 | 4826500 | 20240804034729_XlVTe | MX0001 | 2024-08-14T12:21:09.516Z | 2024-08-15T12:26:20.273Z |
4818744 | 4818744 | 20240804100856_8wdKu | MX0001 | 2024-08-14T12:03:25.242Z | 2024-08-17T12:24:48.689Z |
4818609 | 4818609 | 20240804095409_CF4cJ | MX0001 | 2024-08-14T12:03:12.562Z | 2024-08-17T12:24:44.483Z |
4818527 | 4818527 | 20240804093746_mNzga | MX0001 | 2024-08-14T12:03:02.691Z | 2024-08-17T12:24:41.731Z |
4818450 | 4818450 | 20240804092601_36C8m | MX0001 | 2024-08-14T12:02:49.770Z | 2024-08-17T12:24:39.091Z |
4818407 | 4818407 | 20240804092059_S0YBB | MX0001 | 2024-08-14T12:02:44.591Z | 2024-08-17T12:24:37.193Z |
4817485 | 4817485 | 20240804060734_EFjds | MX0001 | 2024-08-14T12:00:24.204Z | 2024-08-17T12:23:21.273Z |
4808705 | 4808705 | 20240803111619_Hphvs | MX0001 | 2024-08-13T12:05:52.286Z | 2024-08-15T12:19:16.317Z |
4808613 | 4808613 | 20240803111104_81KDJ | MX0001 | 2024-08-13T12:05:42.930Z | 2024-08-15T12:19:12.824Z |
4808146 | 4808146 | 20240803104633_2TdqE | MX0001 | 2024-08-13T12:04:55.951Z | 2024-08-15T12:18:55.899Z |
4807889 | 4807889 | 20240803103158_pH2i3 | MX0001 | 2024-08-13T12:04:19.757Z | 2024-08-15T12:18:43.211Z |
4807673 | 4807673 | 20240803101811_sOz5D | MX0001 | 2024-08-13T12:03:44.156Z | 2024-08-15T12:18:36.215Z |
4807528 | 4807528 | 20240803100928_lvUXE | MX0001 | 2024-08-13T12:03:30.837Z | 2024-08-15T12:18:31.272Z |
4807216 | 4807216 | 20240803094120_pvgqr | MX0001 | 2024-08-13T12:02:40.995Z | 2024-08-15T12:18:23.356Z |
4807121 | 4807121 | 20240803093134_DmoGY | MX0001 | 2024-08-13T12:02:28.496Z | 2024-08-15T12:18:20.753Z |
4798295 | 4798295 | 20240803083230_vh8H4 | MX0001 | 2024-08-12T12:03:19.652Z | 2024-08-15T12:17:45.364Z |
4797966 | 4797966 | 20240803074927_SqvqW | MX0001 | 2024-08-12T12:02:11.444Z | 2024-08-15T12:17:28.549Z |
4786926 | 4786926 | 20240802033353_QYekv | MX0001 | 2024-08-11T12:00:22.667Z | 2024-08-13T12:15:11.727Z |
4746416 | 4746416 | 20240730043621_C8utb | MX0001 | 2024-08-04T12:08:41.616Z | 2024-08-08T12:18:44.342Z |
4651102 | 4651102 | 20240715042918_zbMpV | MX0001 | 2024-07-17T12:09:46.971Z | 2024-07-23T12:08:48.772Z |
4644068 | 4644068 | 20240715111230_yWg93 | MX0001 | 2024-07-17T12:01:04.096Z | 2024-07-24T12:16:40.604Z |
4581299 | 4581299 | 20240706103850_nOkF3 | MX0001 | 2024-07-09T12:05:04.861Z | 2024-07-14T12:14:05.019Z |
4581277 | 4581277 | 20240706103645_vq1X0 | MX0001 | 2024-07-09T12:05:04.369Z | 2024-07-14T12:14:04.934Z |
4580880 | 4580880 | 20240707101430_aYUmG | MX0001 | 2024-07-09T12:03:50.174Z | 2024-07-15T12:12:16.470Z |
4580744 | 4580744 | 20240707094510_XxjE3 | MX0001 | 2024-07-09T12:03:43.849Z | 2024-07-15T12:12:15.338Z |
4580590 | 4580590 | 20240707091649_5Wi8P | MX0001 | 2024-07-09T12:03:36.977Z | 2024-07-15T12:12:13.613Z |
4580319 | 4580319 | 20240707075907_0GUeC | MX0001 | 2024-07-09T12:03:19.854Z | 2024-07-15T12:12:10.798Z |
4580258 | 4580258 | 20240707074724_VAGcG | MX0001 | 2024-07-09T12:03:16.874Z | 2024-07-15T12:12:10.423Z |
4580074 | 4580074 | 20240707070454_UZ6JW | MX0001 | 2024-07-09T12:03:07.212Z | 2024-07-15T12:12:09.016Z |
4579627 | 4579627 | 20240707034028_4DHoH | MX0001 | 2024-07-09T12:02:39.103Z | 2024-07-15T12:12:04.201Z |
4573078 | 4573078 | 20240706101425_F5bUm | MX0001 | 2024-07-08T12:06:03.764Z | 2024-07-14T12:14:04.570Z |
4572367 | 4572367 | 20240706090559_Wuk6U | MX0001 | 2024-07-08T12:05:19.605Z | 2024-07-14T12:14:01.730Z |
4571837 | 4571837 | 20240706075931_n2hcJ | MX0001 | 2024-07-08T12:04:40.414Z | 2024-07-14T12:13:59.427Z |
4571817 | 4571817 | 20240706075801_Gq9mF | MX0001 | 2024-07-08T12:04:38.918Z | 2024-07-14T12:13:59.409Z |
4494376 | 4494376 | 20240623102620_43meO | MX0001 | 2024-06-24T12:00:21.854Z | 2024-07-02T12:10:13.356Z |
4494361 | 4494361 | 20240623100526_kNsj0 | MX0001 | 2024-06-24T12:00:20.361Z | 2024-07-02T12:10:13.310Z |
4494339 | 4494339 | 20240623094122_UOPzV | MX0001 | 2024-06-24T12:00:18.181Z | 2024-07-02T12:10:13.295Z |
4494329 | 4494329 | 20240623092910_vLLrV | MX0001 | 2024-06-24T12:00:16.651Z | 2024-07-02T12:10:13.254Z |
4486590 | 4486590 | 20240619102724_372ia | MX0001 | 2024-06-21T12:02:40.528Z | 2024-06-28T12:09:29.297Z |
4481543 | 4481543 | 20240618090641_xfk8I | MX0001 | 2024-06-20T12:01:01.692Z | 2024-06-27T12:11:08.873Z |
4476180 | 4476180 | 20240617104125_L33Th | MX0001 | 2024-06-19T12:03:10.921Z | 2024-06-26T12:14:17.717Z |
4475899 | 4475899 | 20240617091615_W3esf | MX0001 | 2024-06-19T12:02:41.981Z | 2024-06-26T12:14:14.816Z |
4475857 | 4475857 | 20240617090747_GwAjW | MX0001 | 2024-06-19T12:02:35.271Z | 2024-06-26T12:14:14.530Z |
4475438 | 4475438 | 20240617070102_WHRxw | MX0001 | 2024-06-19T12:01:49.564Z | 2024-06-26T12:14:11.980Z |
4475369 | 4475369 | 20240617061518_L0cLI | MX0001 | 2024-06-19T12:01:41.047Z | 2024-06-26T12:14:10.501Z |
4475214 | 4475214 | 20240617025713_ghto5 | MX0001 | 2024-06-19T12:01:15.917Z | 2024-06-26T12:14:07.899Z |
4472769 | 4472769 | 20240616090909_mJPeN | MX0001 | 2024-06-18T12:02:53.835Z | 2024-06-24T12:11:12.590Z |
4472597 | 4472597 | 20240616081733_Qdum1 | MX0001 | 2024-06-18T12:02:31.472Z | 2024-06-24T12:11:10.017Z |
4472466 | 4472466 | 20240616074015_qnNau | MX0001 | 2024-06-18T12:02:16.956Z | 2024-06-24T12:11:08.773Z |
4472277 | 4472277 | 20240616064024_oJ9DB | MX0001 | 2024-06-18T12:01:56.018Z | 2024-06-24T12:11:07.032Z |
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);