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

2,105 rows where station_code = "MA0003" 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
9358064 9358064 20260219223811_mKg3i MA0003 2026-02-21T14:17:33.276Z 2026-02-28T14:44:48.011Z
9357985 9357985 20260219211214_1HPhN MA0003 2026-02-21T14:17:17.822Z 2026-02-28T14:44:46.123Z
9357983 9357983 20260219211058_kl3N0 MA0003 2026-02-21T14:17:17.331Z 2026-02-28T14:44:46.096Z
9357964 9357964 20260219210335_iwI1f MA0003 2026-02-21T14:17:15.143Z 2026-02-28T14:44:45.794Z
9352307 9352307 20260220045624_bDL7G MA0003 2026-02-21T14:01:28.312Z 2026-03-01T14:21:35.706Z
9352287 9352287 20260220043435_zWVL2 MA0003 2026-02-21T14:01:23.769Z 2026-03-01T14:21:35.314Z
9352226 9352226 20260220033758_ysumC MA0003 2026-02-21T14:01:07.234Z 2026-03-01T14:21:34.291Z
9352155 9352155 20260220024137_6maH2 MA0003 2026-02-21T14:00:49.762Z 2026-03-01T14:21:33.193Z
9352121 9352121 20260220021357_xwNMU MA0003 2026-02-21T14:00:41.297Z 2026-03-01T14:21:32.491Z
9352115 9352115 20260220021036_HXq1p MA0003 2026-02-21T14:00:39.555Z 2026-03-01T14:21:32.408Z
9352052 9352052 20260220010949_e3hNy MA0003 2026-02-21T14:00:23.395Z 2026-03-01T14:21:31.491Z
9351312 9351312 20260217191620_Tgfw3 MA0003 2026-02-20T14:02:43.003Z 2026-02-26T14:40:05.409Z
9344482 9344482 20260218032727_uqVQX MA0003 2026-02-20T14:01:14.077Z 2026-02-27T14:34:10.020Z
9344333 9344333 20260218024824_B1eND MA0003 2026-02-20T14:01:07.537Z 2026-02-27T14:34:07.262Z
9344303 9344303 20260218024044_dJaZj MA0003 2026-02-20T14:01:05.513Z 2026-02-27T14:34:06.683Z
9341013 9341013 20260219014612_SDsT4 MA0003 2026-02-20T14:00:54.989Z 2026-02-28T14:43:40.310Z
9340723 9340723 20260216002750_UrRrg MA0003 2026-02-18T14:32:56.446Z 2026-02-24T14:43:34.907Z
9339076 9339076 20260216042201_NZB34 MA0003 2026-02-18T14:15:27.513Z 2026-02-25T14:41:42.071Z
9339074 9339074 20260216024035_q9p2h MA0003 2026-02-18T14:14:34.025Z 2026-02-25T14:41:31.718Z
9330136 9330136 20260215002018_rZE8F MA0003 2026-02-16T14:22:41.617Z 2026-02-23T14:47:41.839Z
9329955 9329955 20260214215707_Bh9Uh MA0003 2026-02-16T14:21:50.986Z 2026-02-23T14:47:38.984Z
9327150 9327150 20260215041643_mvlCZ MA0003 2026-02-16T14:02:46.329Z 2026-02-24T14:41:48.048Z
9327050 9327050 20260215034801_mVkzA MA0003 2026-02-16T14:02:13.808Z 2026-02-24T14:41:40.778Z
9326924 9326924 20260215030245_QZXD2 MA0003 2026-02-16T14:01:33.061Z 2026-02-24T14:41:38.551Z
9326869 9326869 20260215024715_dMTap MA0003 2026-02-16T14:01:11.952Z 2026-02-24T14:41:37.658Z
9326802 9326802 20260215021956_LWawc MA0003 2026-02-16T14:00:47.157Z 2026-02-24T14:41:34.478Z
9326775 9326775 20260215020940_el209 MA0003 2026-02-16T14:00:34.282Z 2026-02-24T14:41:33.236Z
9326741 9326741 20260215013216_nRZTD MA0003 2026-02-16T14:00:18.257Z 2026-02-24T14:41:32.258Z
9322405 9322405 20260214030003_Vwwja MA0003 2026-02-15T14:02:14.896Z 2026-02-23T14:46:16.084Z
9319341 9319341 20260212011635_5OhCg MA0003 2026-02-13T14:23:05.737Z 2026-02-20T14:05:30.364Z
9319339 9319339 20260212011402_R3jPm MA0003 2026-02-13T14:23:05.027Z 2026-02-20T14:05:30.363Z
9319297 9319297 20260212003006_gxjcC MA0003 2026-02-13T14:22:54.819Z 2026-02-20T14:05:30.219Z
9319290 9319290 20260212002614_g2VG6 MA0003 2026-02-13T14:22:53.207Z 2026-02-20T14:05:30.155Z
9260636 9260636 20260125060828_38WBE MA0003 2026-01-26T14:22:41.269Z 2026-02-02T14:50:10.858Z
9260608 9260608 20260125055244_iXukr MA0003 2026-01-26T14:22:34.140Z 2026-02-02T14:50:08.892Z
9260430 9260430 20260125042214_P5aj3 MA0003 2026-01-26T14:21:47.598Z 2026-02-02T14:49:50.160Z
9260367 9260367 20260125040103_kjasr MA0003 2026-01-26T14:21:25.094Z 2026-02-02T14:49:44.597Z
9244141 9244141 20260121062120_r3fiQ MA0003 2026-01-22T14:24:16.097Z 2026-01-29T15:05:53.272Z
9244021 9244021 20260121055621_g5cCu MA0003 2026-01-22T14:23:57.402Z 2026-01-29T15:05:48.780Z
9243912 9243912 20260121053157_SBOeX MA0003 2026-01-22T14:23:29.816Z 2026-01-29T15:05:34.189Z
9243180 9243180 20260121035455_NO9Xl MA0003 2026-01-22T14:20:51.241Z 2026-01-29T15:04:49.712Z
9242607 9242607 20260121022349_ZZ581 MA0003 2026-01-22T14:18:32.988Z 2026-01-29T15:04:13.613Z
9242092 9242092 20260121002605_Tjk38 MA0003 2026-01-22T14:16:20.091Z 2026-01-29T15:03:29.761Z
9242004 9242004 20260120235819_3UH23 MA0003 2026-01-22T14:15:49.905Z 2026-01-29T15:03:24.852Z
9241899 9241899 20260120232332_rCQ5u MA0003 2026-01-22T14:15:17.365Z 2026-01-29T15:03:11.327Z
9241862 9241862 20260120230714_ZrVV6 MA0003 2026-01-22T14:14:58.906Z 2026-01-29T15:03:06.767Z
9241807 9241807 20260120224224_E53jZ MA0003 2026-01-22T14:14:46.399Z 2026-01-29T15:03:03.565Z
9239100 9239100 20260115230823_tAUQa MA0003 2026-01-21T14:50:44.770Z 2026-01-24T15:11:02.560Z
9239098 9239098 20260115223843_OaTjx MA0003 2026-01-21T14:50:42.427Z 2026-01-24T15:10:59.653Z
9237401 9237401 20260120051253_36jiZ MA0003 2026-01-21T14:26:25.468Z 2026-01-28T15:01:23.926Z
9236534 9236534 20260120033138_kl6j0 MA0003 2026-01-21T14:23:06.687Z 2026-01-28T15:00:07.848Z
9236278 9236278 20260120025440_9qd3L MA0003 2026-01-21T14:22:14.382Z 2026-01-28T14:59:52.967Z
9235153 9235153 20260120003734_Xwr0C MA0003 2026-01-21T14:17:46.364Z 2026-01-28T14:58:33.267Z
9223054 9223054 20260117224357_Z6b75 MA0003 2026-01-19T14:17:27.832Z 2026-01-26T15:01:33.750Z
8906100 8906100 20251214053948_vItMg MA0003 2025-12-23T14:08:03.985Z 2025-12-24T14:21:00.922Z
8904744 8904744 20251214052143_aA0tF MA0003 2025-12-23T14:07:32.937Z 2025-12-24T14:20:31.300Z
8903997 8903997 20251214051229_UeRxA MA0003 2025-12-23T14:06:48.609Z 2025-12-24T14:20:15.012Z
8903954 8903954 20251214051205_K5zK2 MA0003 2025-12-23T14:06:46.732Z 2025-12-24T14:20:12.389Z
8903415 8903415 20251214050506_QyUWp MA0003 2025-12-23T14:06:21.274Z 2025-12-24T14:19:40.506Z
8903281 8903281 20251214050327_PwPyM MA0003 2025-12-23T14:06:13.589Z 2025-12-24T14:19:38.388Z
8902953 8902953 20251214045940_b59Xi MA0003 2025-12-23T14:05:55.909Z 2025-12-24T14:19:33.360Z
8899913 8899913 20251214042937_v3RL2 MA0003 2025-12-23T14:04:35.381Z 2025-12-24T14:17:53.531Z
8899198 8899198 20251214042313_KLoXt MA0003 2025-12-23T14:04:07.973Z 2025-12-24T14:17:41.144Z
8878747 8878747 20251214032233_82Qjc MA0003 2025-12-22T14:01:57.843Z 2025-12-24T14:14:06.829Z
8878666 8878666 20251214032204_DfyGd MA0003 2025-12-22T14:01:57.236Z 2025-12-24T14:14:04.226Z
8877770 8877770 20251214031601_VrRuM MA0003 2025-12-22T14:01:36.442Z 2025-12-24T14:13:40.179Z
8840601 8840601 20251213222018_LUxFL MA0003 2025-12-18T14:42:29.964Z 2025-12-23T14:25:15.727Z
8840474 8840474 20251213221849_YYjCf MA0003 2025-12-18T14:42:27.840Z 2025-12-23T14:25:15.596Z
8795047 8795047 20251213043220_Z8mfk MA0003 2025-12-16T14:07:35.128Z 2025-12-23T14:17:24.078Z
8752233 8752233 20251209223837_4zP3U MA0003 2025-12-13T15:40:44.786Z 2025-12-17T15:27:26.876Z
8751784 8751784 20251209215433_1Fscb MA0003 2025-12-13T15:39:50.687Z 2025-12-17T15:27:22.976Z
8751716 8751716 20251209214508_eQ5fB MA0003 2025-12-13T15:39:48.477Z 2025-12-17T15:27:22.077Z
8751446 8751446 20251209211021_2HDJ7 MA0003 2025-12-13T15:39:38.524Z 2025-12-17T15:27:19.272Z
8737804 8737804 20251212013458_oiLx7 MA0003 2025-12-13T15:00:51.278Z 2025-12-20T14:25:29.785Z
8737785 8737785 20251212013207_ZS4mH MA0003 2025-12-13T15:00:42.631Z 2025-12-20T14:25:29.579Z
8737645 8737645 20251212011730_pcsC6 MA0003 2025-12-13T15:00:01.688Z 2025-12-20T14:25:28.755Z
8737505 8737505 20251212005859_nXyuH MA0003 2025-12-13T14:59:28.681Z 2025-12-20T14:25:27.841Z
8737497 8737497 20251212005725_iVuts MA0003 2025-12-13T14:59:28.001Z 2025-12-20T14:25:27.750Z
8737367 8737367 20251212004301_Oz3Nj MA0003 2025-12-13T14:59:16.710Z 2025-12-20T14:25:26.896Z
8737357 8737357 20251212004140_Au3z6 MA0003 2025-12-13T14:59:16.245Z 2025-12-20T14:25:26.891Z
8737334 8737334 20251212003756_pWDjL MA0003 2025-12-13T14:59:14.213Z 2025-12-20T14:25:26.764Z
8737281 8737281 20251212002813_EE3xe MA0003 2025-12-13T14:59:09.441Z 2025-12-20T14:25:26.387Z
8737279 8737279 20251212002748_f7Sox MA0003 2025-12-13T14:59:09.142Z 2025-12-20T14:25:26.386Z
8737275 8737275 20251212002729_WPBVj MA0003 2025-12-13T14:59:08.788Z 2025-12-20T14:25:26.346Z
8737203 8737203 20251212001924_K4uYq MA0003 2025-12-13T14:58:46.693Z 2025-12-20T14:25:26.050Z
8737192 8737192 20251212001850_qtAGT MA0003 2025-12-13T14:58:45.694Z 2025-12-20T14:25:26.039Z
8737173 8737173 20251212001629_MpM6Q MA0003 2025-12-13T14:58:44.219Z 2025-12-20T14:25:25.890Z
8737164 8737164 20251212001548_FrhXo MA0003 2025-12-13T14:58:43.750Z 2025-12-20T14:25:25.832Z
8737129 8737129 20251212001223_jAUgi MA0003 2025-12-13T14:58:41.054Z 2025-12-20T14:25:25.653Z
8737113 8737113 20251212001110_34C1z MA0003 2025-12-13T14:58:39.697Z 2025-12-20T14:25:25.605Z
8737111 8737111 20251212001048_C6sAq MA0003 2025-12-13T14:58:39.530Z 2025-12-20T14:25:25.602Z
8737070 8737070 20251212000428_L3rI6 MA0003 2025-12-13T14:58:36.988Z 2025-12-20T14:25:25.461Z
8737023 8737023 20251212000058_2bp6O MA0003 2025-12-13T14:58:32.768Z 2025-12-20T14:25:25.228Z
8737006 8737006 20251211235828_7KqkE MA0003 2025-12-13T14:58:23.207Z 2025-12-20T14:25:25.025Z
8736946 8736946 20251211234837_yreQA MA0003 2025-12-13T14:58:11.410Z 2025-12-20T14:25:24.502Z
8736816 8736816 20251211233142_sDJv0 MA0003 2025-12-13T14:57:59.586Z 2025-12-20T14:25:23.069Z
8736551 8736551 20251211225725_B72oO MA0003 2025-12-13T14:57:00.392Z 2025-12-20T14:25:21.426Z
8736455 8736455 20251211224158_ajptI MA0003 2025-12-13T14:56:49.308Z 2025-12-20T14:25:20.927Z
8736442 8736442 20251211223841_nI00Y MA0003 2025-12-13T14:56:45.405Z 2025-12-20T14:25:20.774Z
8736437 8736437 20251211223834_Oqebl MA0003 2025-12-13T14:56:43.676Z 2025-12-20T14:25:20.746Z

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