home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

1,256 rows where station_code = "MX000E" sorted by created_at descending

✎ View and edit SQL

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
8484153 8484153 20251115092409_Wtwk3 MX000E 2025-11-17T14:32:20.869Z 2025-11-23T15:19:28.301Z
8483166 8483166 20251115080535_uxt4T MX000E 2025-11-17T14:31:02.390Z 2025-11-23T15:18:44.581Z
8470544 8470544 20251115051145_09Fpa MX000E 2025-11-16T14:23:00.984Z 2025-11-23T15:18:14.372Z
8470495 8470495 20251115050827_ctc4k MX000E 2025-11-16T14:22:56.757Z 2025-11-23T15:18:12.880Z
8469976 8469976 20251115035636_R69JA MX000E 2025-11-16T14:21:34.907Z 2025-11-23T15:17:59.232Z
8461857 8461857 20251114101110_ByI9G MX000E 2025-11-15T14:24:58.345Z 2025-11-22T15:23:43.434Z
8461527 8461527 20251114093019_0nKqf MX000E 2025-11-15T14:24:27.801Z 2025-11-22T15:23:29.361Z
8460693 8460693 20251114073654_qzREB MX000E 2025-11-15T14:22:41.060Z 2025-11-22T15:22:45.504Z
8459883 8459883 20251114050242_cwkHX MX000E 2025-11-15T14:20:44.866Z 2025-11-22T15:22:16.497Z
8459754 8459754 20251114044053_3DuIC MX000E 2025-11-15T14:20:33.798Z 2025-11-22T15:22:11.324Z
8440695 8440695 20251112072718_8601c MX000E 2025-11-13T14:29:14.211Z 2025-11-20T15:25:56.905Z
8440536 8440536 20251112065348_Xt4JU MX000E 2025-11-13T14:28:59.408Z 2025-11-20T15:25:52.810Z
8440002 8440002 20251112050832_YmXDc MX000E 2025-11-13T14:27:59.504Z 2025-11-20T15:25:39.910Z
8407654 8407654 20251109113040_8Bejd MX000E 2025-11-10T14:19:39.185Z 2025-11-17T14:59:27.261Z
8387765 8387765 20251106113130_ngg66 MX000E 2025-11-07T14:15:58.626Z 2025-11-14T15:08:55.052Z
8387735 8387735 20251106112755_kMN9A MX000E 2025-11-07T14:15:56.016Z 2025-11-14T15:08:54.876Z
8387512 8387512 20251106102635_zVUtK MX000E 2025-11-07T14:14:52.187Z 2025-11-14T15:08:52.835Z
8386987 8386987 20251106081759_eQG42 MX000E 2025-11-07T14:12:54.472Z 2025-11-14T15:08:47.400Z
8266096 8266096 20251026091239_bAlkE MX000E 2025-10-28T12:39:25.890Z 2025-11-03T15:17:06.437Z
8265560 8265560 20251026081625_48hwu MX000E 2025-10-28T12:38:35.965Z 2025-11-03T15:17:04.744Z
8265207 8265207 20251026072637_yJamT MX000E 2025-10-28T12:38:21.823Z 2025-11-03T15:17:03.280Z
8247116 8247116 20251025111751_E0usL MX000E 2025-10-27T12:42:22.664Z 2025-11-02T15:05:52.140Z
8246187 8246187 20251025100652_6mYJl MX000E 2025-10-27T12:40:37.308Z 2025-11-02T15:05:49.353Z
8246032 8246032 20251025095405_5RpNI MX000E 2025-10-27T12:40:33.437Z 2025-11-02T15:05:48.679Z
8245693 8245693 20251025093157_x7VGq MX000E 2025-10-27T12:40:24.559Z 2025-11-02T15:05:47.595Z
8245339 8245339 20251025090738_071Ih MX000E 2025-10-27T12:39:30.391Z 2025-11-02T15:05:46.866Z
8244370 8244370 20251025075316_poqcE MX000E 2025-10-27T12:37:46.663Z 2025-11-02T15:05:43.105Z
8244201 8244201 20251025073724_3uOwa MX000E 2025-10-27T12:37:40.817Z 2025-11-02T15:05:42.624Z
8225949 8225949 20251024085002_Vipcc MX000E 2025-10-26T12:44:15.180Z 2025-11-01T13:11:23.431Z
8225466 8225466 20251024080802_X2ulr MX000E 2025-10-26T12:43:17.341Z 2025-11-01T13:11:21.960Z
8150683 8150683 20251019111532_fhGCw MX000E 2025-10-20T12:30:59.275Z 2025-10-27T13:11:28.021Z
8149714 8149714 20251019094609_8rVt3 MX000E 2025-10-20T12:29:44.684Z 2025-10-27T13:11:20.678Z
8148371 8148371 20251019074614_nOCsW MX000E 2025-10-20T12:26:56.645Z 2025-10-27T13:11:04.392Z
8111513 8111513 20251016012221_k3ktu MX000E 2025-10-17T12:10:33.339Z 2025-10-24T13:16:23.407Z
8092983 8092983 20251013022115_2IPvn MX000E 2025-10-14T12:12:02.633Z 2025-10-21T13:09:33.344Z
7975215 7975215 20250925032138_WSaTH MX000E 2025-09-27T12:21:01.052Z 2025-10-03T13:04:37.098Z
7966772 7966772 20250925110649_7KlFS MX000E 2025-09-27T12:04:45.202Z 2025-10-04T13:05:53.278Z
7950430 7950430 20250924024819_N4qWq MX000E 2025-09-25T12:35:14.843Z 2025-10-02T13:27:55.667Z
7899070 7899070 20250920020442_ElUj5 MX000E 2025-09-22T12:09:05.623Z 2025-09-29T13:02:42.861Z
7867263 7867263 20250918090320_mqGMk MX000E 2025-09-19T12:13:34.396Z 2025-09-27T12:46:48.057Z
7867258 7867258 20250918090102_XKtzV MX000E 2025-09-19T12:13:33.589Z 2025-09-27T12:46:47.939Z
7867066 7867066 20250918072624_0luuV MX000E 2025-09-19T12:12:52.979Z 2025-09-27T12:46:43.001Z
7615113 7615113 20250821033226_4Ufjo MX000E 2025-08-23T12:36:33.469Z 2025-08-29T12:57:01.635Z
7615104 7615104 20250821025110_RuUPg MX000E 2025-08-23T12:36:18.258Z 2025-08-29T12:56:54.520Z
7605879 7605879 20250821102140_AQY5F MX000E 2025-08-23T12:08:46.222Z 2025-08-30T12:58:58.324Z
7605122 7605122 20250821064725_pSkEA MX000E 2025-08-23T12:05:31.735Z 2025-08-30T12:58:33.837Z
7578689 7578689 20250819094321_EU2RV MX000E 2025-08-21T12:09:07.141Z 2025-08-28T12:51:58.413Z
7397404 7397404 20250806062713_A3pm7 MX000E 2025-08-08T12:23:47.951Z 2025-08-14T12:59:06.646Z
7384001 7384001 20250805112116_4i4v8 MX000E 2025-08-07T12:20:28.477Z 2025-08-13T13:00:33.173Z
7383953 7383953 20250805111728_ab4hR MX000E 2025-08-07T12:20:27.444Z 2025-08-13T13:00:32.542Z
7383824 7383824 20250805110839_c2fGK MX000E 2025-08-07T12:20:24.899Z 2025-08-13T13:00:29.972Z
7382988 7382988 20250805095506_ZjqYN MX000E 2025-08-07T12:19:27.207Z 2025-08-13T13:00:09.160Z
7381888 7381888 20250805082209_db9jk MX000E 2025-08-07T12:18:12.893Z 2025-08-13T12:59:56.383Z
7381668 7381668 20250805075949_JwJug MX000E 2025-08-07T12:17:55.089Z 2025-08-13T12:59:53.543Z
7381361 7381361 20250805072626_WdK14 MX000E 2025-08-07T12:17:43.767Z 2025-08-13T12:59:49.605Z
7381244 7381244 20250805071135_hL3Ll MX000E 2025-08-07T12:17:38.938Z 2025-08-13T12:59:48.311Z
7381050 7381050 20250805064739_3ZhsT MX000E 2025-08-07T12:17:26.668Z 2025-08-13T12:59:43.855Z
7370144 7370144 20250804111204_Ckzqq MX000E 2025-08-06T12:17:56.536Z 2025-08-06T12:17:56.536Z
7370021 7370021 20250804110321_lKL0I MX000E 2025-08-06T12:17:54.276Z 2025-08-12T12:57:37.849Z
7369909 7369909 20250804105913_D8Nqr MX000E 2025-08-06T12:17:52.593Z 2025-08-12T12:57:37.494Z
7369286 7369286 20250804101617_33x2P MX000E 2025-08-06T12:17:15.813Z 2025-08-12T12:57:35.419Z
7368918 7368918 20250804094950_9MbEJ MX000E 2025-08-06T12:16:58.957Z 2025-08-12T12:57:34.073Z
7368479 7368479 20250804091840_iL2TK MX000E 2025-08-06T12:16:45.869Z 2025-08-12T12:57:32.759Z
7366885 7366885 20250804072122_gCF4x MX000E 2025-08-06T12:15:48.606Z 2025-08-12T12:57:16.944Z
7366512 7366512 20250804063515_EDK8W MX000E 2025-08-06T12:15:37.064Z 2025-08-12T12:57:06.603Z
7366474 7366474 20250804063026_DAeAs MX000E 2025-08-06T12:15:35.666Z 2025-08-12T12:57:06.396Z
7366384 7366384 20250804061807_z3zwb MX000E 2025-08-06T12:15:32.426Z 2025-08-12T12:57:04.977Z
7366382 7366382 20250804061754_7Gevv MX000E 2025-08-06T12:15:32.311Z 2025-08-12T12:57:04.973Z
7294700 7294700 20250731071240_fEWRO MX000E 2025-08-02T12:21:58.893Z 2025-08-08T12:56:35.089Z
7294493 7294493 20250731064450_9ri1r MX000E 2025-08-02T12:21:53.530Z 2025-08-08T12:56:34.821Z
7294431 7294431 20250731063441_GCERo MX000E 2025-08-02T12:21:52.283Z 2025-08-08T12:56:34.696Z
7294193 7294193 20250731060009_aXVvY MX000E 2025-08-02T12:21:42.105Z 2025-08-08T12:56:34.339Z
7294175 7294175 20250731055647_jk228 MX000E 2025-08-02T12:21:41.713Z 2025-08-08T12:56:34.270Z
7294153 7294153 20250731055426_z272O MX000E 2025-08-02T12:21:41.012Z 2025-08-08T12:56:34.234Z
7293638 7293638 20250731042717_5QrV2 MX000E 2025-08-02T12:21:12.711Z 2025-08-08T12:56:33.345Z
7293429 7293429 20250731033532_Eu2do MX000E 2025-08-02T12:20:53.247Z 2025-08-08T12:56:32.884Z
7283098 7283098 20250731090533_0cPit MX000E 2025-08-02T12:02:23.215Z 2025-08-09T13:02:57.247Z
7282785 7282785 20250731082340_820SS MX000E 2025-08-02T12:01:36.454Z 2025-08-09T13:02:52.055Z
7282258 7282258 20250731072028_L3wZo MX000E 2025-08-02T12:00:23.309Z 2025-08-09T13:02:43.187Z
7282224 7282224 20250731071647_4u6zS MX000E 2025-08-02T12:00:17.671Z 2025-08-09T13:02:42.742Z
7269917 7269917 20250730094534_3fQT0 MX000E 2025-08-01T12:01:14.692Z 2025-08-08T12:55:33.389Z
7220749 7220749 20250727030714_4Sk8Q MX000E 2025-07-29T12:04:21.941Z 2025-08-05T12:39:02.316Z
7205025 7205025 20250726045118_cZK2t MX000E 2025-07-28T12:03:24.805Z 2025-08-04T12:48:03.012Z
7161393 7161393 20250724055244_2kJ6v MX000E 2025-07-25T12:00:17.550Z 2025-08-01T12:15:48.702Z
7161234 7161234 20250724045237_S3c2Y MX000E 2025-07-25T12:00:17.143Z 2025-08-01T12:15:47.932Z
7153709 7153709 20250723074733_sOfeO MX000E 2025-07-24T12:00:13.353Z 2025-07-31T12:22:48.994Z
7153703 7153703 20250723074357_rymIX MX000E 2025-07-24T12:00:13.343Z 2025-07-31T12:22:48.976Z
7153565 7153565 20250723071917_x2XGg MX000E 2025-07-24T12:00:13.085Z 2025-07-31T12:22:46.621Z
7119105 7119105 20250720071124_R8Zg2 MX000E 2025-07-21T12:00:36.301Z 2025-07-28T12:48:31.890Z
7047792 7047792 20250707070453_nrT8A MX000E 2025-07-08T12:00:56.742Z 2025-07-16T12:42:11.519Z
7037924 7037924 20250705092636_DlTvE MX000E 2025-07-06T12:04:37.211Z 2025-07-14T12:45:52.492Z
6874236 6874236 20250608084111_zOpOB MX000E 2025-06-09T12:04:32.713Z 2025-06-16T12:25:36.938Z
6874042 6874042 20250608074121_9mOIz MX000E 2025-06-09T12:03:50.370Z 2025-06-16T12:25:31.640Z
6640910 6640910 20250503105117_YqTGi MX000E 2025-05-04T12:20:58.684Z 2025-05-11T12:37:33.540Z
6564808 6564808 20250424105711_vyh8n MX000E 2025-04-26T12:11:01.359Z 2025-05-03T12:32:18.163Z
6564701 6564701 20250424095922_OO3Q8 MX000E 2025-04-26T12:10:22.808Z 2025-05-03T12:32:17.127Z
6562610 6562610 20250425100922_Q4aOt MX000E 2025-04-26T12:03:01.693Z 2025-05-04T12:36:08.130Z
6513901 6513901 20250415111917_23IbK MX000E 2025-04-16T12:02:49.635Z 2025-04-24T12:36:22.775Z
6512003 6512003 20250414103902_TNpo8 MX000E 2025-04-15T12:02:52.452Z 2025-04-23T12:33:04.697Z
6496995 6496995 20250410104949_auq8E MX000E 2025-04-11T12:06:26.952Z 2025-04-18T12:22:30.407Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network