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

776 rows where station_code = "MX0005" 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
2345460 2345460 20230324113359_VFNep MX0005 2024-01-05T23:56:22.390Z 2024-01-05T23:56:22.390Z
2340477 2340477 20230322085441_S8U3C MX0005 2024-01-05T23:56:18.671Z 2024-01-05T23:56:18.671Z
2340323 2340323 20230322060734_3MFwd MX0005 2024-01-05T23:56:18.621Z 2024-01-05T23:56:18.621Z
2340170 2340170 20230322024307_DiDMb MX0005 2024-01-05T23:56:17.225Z 2024-01-05T23:56:17.225Z
2339259 2339259 20230321101303_I9sJ8 MX0005 2024-01-05T23:56:17.097Z 2024-01-05T23:56:17.097Z
2339207 2339207 20230321043402_BryPP MX0005 2024-01-05T23:56:15.975Z 2024-01-05T23:56:15.975Z
2338522 2338522 20230320095316_Z20bM MX0005 2024-01-05T23:56:15.878Z 2024-01-05T23:56:15.878Z
2338512 2338512 20230320094622_9lwAY MX0005 2024-01-05T23:56:15.877Z 2024-01-05T23:56:15.877Z
2338504 2338504 20230320090824_xMepD MX0005 2024-01-05T23:56:15.876Z 2024-01-05T23:56:15.876Z
2338473 2338473 20230320075736_lBEfb MX0005 2024-01-05T23:56:15.870Z 2024-01-05T23:56:15.870Z
2338443 2338443 20230320070015_W43vh MX0005 2024-01-05T23:56:15.865Z 2024-01-05T23:56:15.865Z
2338408 2338408 20230320054647_VINlH MX0005 2024-01-05T23:56:15.859Z 2024-01-05T23:56:15.859Z
2333642 2333642 20230318100740_TtJVy MX0005 2024-01-05T23:56:13.020Z 2024-01-05T23:56:13.020Z
2331596 2331596 20230317093127_2yjeH MX0005 2024-01-05T23:56:11.565Z 2024-01-05T23:56:11.565Z
2316644 2316644 20230304102828_gxS8b MX0005 2024-01-05T23:55:51.056Z 2024-01-05T23:55:51.056Z
2315837 2315837 20230303114139_Dvsms MX0005 2024-01-05T23:55:49.850Z 2024-01-05T23:55:49.850Z
2315684 2315684 20230303100222_YJB2l MX0005 2024-01-05T23:55:49.833Z 2024-01-05T23:55:49.833Z
2315570 2315570 20230303084855_k2iH3 MX0005 2024-01-05T23:55:49.818Z 2024-01-05T23:55:49.818Z
2313978 2313978 20230302111902_0NlBw MX0005 2024-01-05T23:55:48.484Z 2024-01-05T23:55:48.484Z
2313934 2313934 20230302103624_qzd1w MX0005 2024-01-05T23:55:48.478Z 2024-01-05T23:55:48.478Z
2310243 2310243 20230228100819_vEsGc MX0005 2024-01-05T23:55:45.810Z 2024-01-05T23:55:45.810Z
2310028 2310028 20230228083024_GYa6o MX0005 2024-01-05T23:55:45.788Z 2024-01-05T23:55:45.788Z
2303319 2303319 20230226113956_rTzP9 MX0005 2024-01-05T23:55:42.835Z 2024-01-05T23:55:42.835Z
2297347 2297347 20230224120815_atwzs MX0005 2024-01-05T23:55:39.834Z 2024-01-05T23:55:39.834Z
2295706 2295706 20230223055203_nTG2a MX0005 2024-01-05T23:55:38.066Z 2024-01-05T23:55:38.066Z
2294493 2294493 20230222090219_PgTbn MX0005 2024-01-05T23:55:36.813Z 2024-01-05T23:55:36.813Z
2294454 2294454 20230222061347_xn7Mo MX0005 2024-01-05T23:55:36.807Z 2024-01-05T23:55:36.807Z
2294405 2294405 20230222042332_1bGOz MX0005 2024-01-05T23:55:35.692Z 2024-01-05T23:55:35.692Z
2290121 2290121 20230220103856_sE12R MX0005 2024-01-05T23:55:34.017Z 2024-01-05T23:55:34.017Z
2289898 2289898 20230220085054_sUbpY MX0005 2024-01-05T23:55:33.994Z 2024-01-05T23:55:33.994Z
2287647 2287647 20230219111708_FEwwD MX0005 2024-01-05T23:55:32.558Z 2024-01-05T23:55:32.558Z
2287594 2287594 20230219105739_B4u2r MX0005 2024-01-05T23:55:32.552Z 2024-01-05T23:55:32.552Z
2287409 2287409 20230219094846_bFNoF MX0005 2024-01-05T23:55:32.533Z 2024-01-05T23:55:32.533Z
2287365 2287365 20230219093205_bzMYd MX0005 2024-01-05T23:55:32.529Z 2024-01-05T23:55:32.529Z
2282109 2282109 20230216110254_RztcW MX0005 2024-01-05T23:55:28.496Z 2024-01-05T23:55:28.496Z
2282077 2282077 20230216105711_uALSr MX0005 2024-01-05T23:55:28.492Z 2024-01-05T23:55:28.492Z
2282047 2282047 20230216105035_Txzna MX0005 2024-01-05T23:55:28.489Z 2024-01-05T23:55:28.489Z
2281840 2281840 20230216093709_17LgW MX0005 2024-01-05T23:55:28.468Z 2024-01-05T23:55:28.468Z
2279721 2279721 20230215115515_fTBY1 MX0005 2024-01-05T23:55:26.140Z 2024-01-05T23:55:26.140Z
2279717 2279717 20230215115146_7XBP8 MX0005 2024-01-05T23:55:26.139Z 2024-01-05T23:55:26.139Z
2279660 2279660 20230215100442_pzSyU MX0005 2024-01-05T23:55:26.121Z 2024-01-05T23:55:26.121Z
2279626 2279626 20230215080846_qSaXy MX0005 2024-01-05T23:55:26.111Z 2024-01-05T23:55:26.111Z
2279617 2279617 20230215075506_p6iB4 MX0005 2024-01-05T23:55:26.109Z 2024-01-05T23:55:26.109Z
2279597 2279597 20230215071100_eo8WY MX0005 2024-01-05T23:55:26.103Z 2024-01-05T23:55:26.103Z
2279516 2279516 20230215054610_L0uGg MX0005 2024-01-05T23:55:24.694Z 2024-01-05T23:55:24.694Z
2277436 2277436 20230214115059_zqW0U MX0005 2024-01-05T23:55:23.023Z 2024-01-05T23:55:23.023Z
2262477 2262477 20230207100047_chEGx MX0005 2024-01-05T23:55:05.161Z 2024-01-05T23:55:05.161Z
2262448 2262448 20230207095338_dBdxi MX0005 2024-01-05T23:55:05.158Z 2024-01-05T23:55:05.158Z
2260997 2260997 20230206102845_yQsTW MX0005 2024-01-05T23:55:03.777Z 2024-01-05T23:55:03.777Z
2261004 2261004 20230206103133_JSATQ MX0005 2024-01-05T23:55:03.777Z 2024-01-05T23:55:03.777Z
2258859 2258859 20230204115102_ybDr0 MX0005 2024-01-05T23:55:01.317Z 2024-01-05T23:55:01.317Z
2258800 2258800 20230204110140_53D9A MX0005 2024-01-05T23:55:01.311Z 2024-01-05T23:55:01.311Z
2258803 2258803 20230204110529_KPBGh MX0005 2024-01-05T23:55:01.311Z 2024-01-05T23:55:01.311Z
2258783 2258783 20230204103407_RU2Vq MX0005 2024-01-05T23:55:01.310Z 2024-01-05T23:55:01.310Z
2252097 2252097 20230131115327_aPYFZ MX0005 2024-01-05T23:54:53.710Z 2024-01-05T23:54:53.710Z
2250081 2250081 20230130121935_qOrEz MX0005 2024-01-05T23:54:51.781Z 2024-01-05T23:54:51.781Z
2246764 2246764 20230129115447_9iCDQ MX0005 2024-01-05T23:54:49.083Z 2024-01-05T23:54:49.083Z
2246645 2246645 20230129113756_9jGq2 MX0005 2024-01-05T23:54:49.072Z 2024-01-05T23:54:49.072Z
2246185 2246185 20230129100407_LKe82 MX0005 2024-01-05T23:54:49.030Z 2024-01-05T23:54:49.030Z
2246189 2246189 20230129100448_Le82i MX0005 2024-01-05T23:54:49.030Z 2024-01-05T23:54:49.030Z
2243183 2243183 20230128105133_jiuSp MX0005 2024-01-05T23:54:47.460Z 2024-01-05T23:54:47.460Z
2242975 2242975 20230128100932_e0OQm MX0005 2024-01-05T23:54:47.427Z 2024-01-05T23:54:47.427Z
2236628 2236628 20230126110528_fLlHO MX0005 2024-01-05T23:54:44.071Z 2024-01-05T23:54:44.071Z
2236473 2236473 20230126101716_XnOPw MX0005 2024-01-05T23:54:44.035Z 2024-01-05T23:54:44.035Z
2236395 2236395 20230126095545_Jxhvo MX0005 2024-01-05T23:54:44.017Z 2024-01-05T23:54:44.017Z
2236319 2236319 20230126094121_ArK6Y MX0005 2024-01-05T23:54:44.002Z 2024-01-05T23:54:44.002Z
2235910 2235910 20230126064003_thIqo MX0005 2024-01-05T23:54:43.899Z 2024-01-05T23:54:43.899Z
2232438 2232438 20230125115705_WWAK1 MX0005 2024-01-05T23:54:41.767Z 2024-01-05T23:54:41.767Z
2232330 2232330 20230125112750_YOJER MX0005 2024-01-05T23:54:41.741Z 2024-01-05T23:54:41.741Z
2232296 2232296 20230125112216_ZDGEY MX0005 2024-01-05T23:54:41.733Z 2024-01-05T23:54:41.733Z
2231754 2231754 20230125094025_TGBJI MX0005 2024-01-05T23:54:41.614Z 2024-01-05T23:54:41.614Z
2231415 2231415 20230125084002_3BZoj MX0005 2024-01-05T23:54:41.541Z 2024-01-05T23:54:41.541Z
2231330 2231330 20230125082205_TDr7X MX0005 2024-01-05T23:54:41.523Z 2024-01-05T23:54:41.523Z
2230960 2230960 20230125050722_XnBSW MX0005 2024-01-05T23:54:41.430Z 2024-01-05T23:54:41.430Z
2229148 2229148 20230124103657_IZ9Km MX0005 2024-01-05T23:54:39.344Z 2024-01-05T23:54:39.344Z
2229038 2229038 20230124090502_MOXzn MX0005 2024-01-05T23:54:39.277Z 2024-01-05T23:54:39.277Z
2229032 2229032 20230124085357_BFeqG MX0005 2024-01-05T23:54:39.276Z 2024-01-05T23:54:39.276Z
2224066 2224066 20230122112727_LqD88 MX0005 2024-01-05T23:54:34.465Z 2024-01-05T23:54:34.465Z
2223384 2223384 20230122083228_duBDp MX0005 2024-01-05T23:54:34.309Z 2024-01-05T23:54:34.309Z
2223208 2223208 20230122071429_EEKB6 MX0005 2024-01-05T23:54:34.270Z 2024-01-05T23:54:34.270Z
2220272 2220272 20230121112213_oAtnl MX0005 2024-01-05T23:54:32.081Z 2024-01-05T23:54:32.081Z
2220235 2220235 20230121110836_jQED8 MX0005 2024-01-05T23:54:32.070Z 2024-01-05T23:54:32.070Z
2209756 2209756 20230119114058_ugXCu MX0005 2024-01-05T23:54:25.398Z 2024-01-05T23:54:25.398Z
2208799 2208799 20230119063436_i9PbN MX0005 2024-01-05T23:54:25.058Z 2024-01-05T23:54:25.058Z
2205101 2205101 20230118104413_ZBtsZ MX0005 2024-01-05T23:54:22.118Z 2024-01-05T23:54:22.118Z
2205070 2205070 20230118100937_KDjB9 MX0005 2024-01-05T23:54:22.110Z 2024-01-05T23:54:22.110Z
2204776 2204776 20230118062229_ako5U MX0005 2024-01-05T23:54:22.049Z 2024-01-05T23:54:22.049Z
2201492 2201492 20230117113518_3TIPv MX0005 2024-01-05T23:54:20.574Z 2024-01-05T23:54:20.574Z
2201471 2201471 20230117105135_i1VAs MX0005 2024-01-05T23:54:20.571Z 2024-01-05T23:54:20.571Z
2201436 2201436 20230117094358_DpoL2 MX0005 2024-01-05T23:54:20.565Z 2024-01-05T23:54:20.565Z
2200954 2200954 20230117052328_tjJW3 MX0005 2024-01-05T23:54:20.514Z 2024-01-05T23:54:20.514Z
2200938 2200938 20230117052203_nJ7sU MX0005 2024-01-05T23:54:20.513Z 2024-01-05T23:54:20.513Z
2200882 2200882 20230117051516_U3Qnl MX0005 2024-01-05T23:54:20.507Z 2024-01-05T23:54:20.507Z
2198217 2198217 20230116103239_6uXPu MX0005 2024-01-05T23:54:19.079Z 2024-01-05T23:54:19.079Z
2198213 2198213 20230116102927_P18iE MX0005 2024-01-05T23:54:19.078Z 2024-01-05T23:54:19.078Z
2198038 2198038 20230116054844_7w1cZ MX0005 2024-01-05T23:54:19.051Z 2024-01-05T23:54:19.051Z
2198017 2198017 20230116053123_PU6s3 MX0005 2024-01-05T23:54:19.047Z 2024-01-05T23:54:19.047Z
2194517 2194517 20230114012652_ONJKF MX0005 2024-01-05T23:54:16.363Z 2024-01-05T23:54:16.363Z
2185205 2185205 20230108120651_Y2Sja MX0005 2024-01-05T23:54:08.595Z 2024-01-05T23:54:08.595Z
2185102 2185102 20230108104856_3emG3 MX0005 2024-01-05T23:54:08.584Z 2024-01-05T23:54:08.584Z

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