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

58 rows where station_code = "AU0021" 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
3146681 3146681 20231013200257_JhnCN AU0021 2024-01-06T00:02:43.811Z 2024-01-06T00:02:43.811Z
3146475 3146475 20231013193809_1iQz5 AU0021 2024-01-06T00:02:43.793Z 2024-01-06T00:02:43.793Z
3146450 3146450 20231013193341_OC02F AU0021 2024-01-06T00:02:43.791Z 2024-01-06T00:02:43.791Z
3146446 3146446 20231013193106_3RW4q AU0021 2024-01-06T00:02:43.790Z 2024-01-06T00:02:43.790Z
3146409 3146409 20231013192612_YeW7A AU0021 2024-01-06T00:02:43.786Z 2024-01-06T00:02:43.786Z
3146275 3146275 20231013190703_sANPf AU0021 2024-01-06T00:02:43.772Z 2024-01-06T00:02:43.772Z
3145959 3145959 20231013181349_ldfmd AU0021 2024-01-06T00:02:43.734Z 2024-01-06T00:02:43.734Z
3145903 3145903 20231013175155_psgOu AU0021 2024-01-06T00:02:43.726Z 2024-01-06T00:02:43.726Z
3145847 3145847 20231013174039_UL2cP AU0021 2024-01-06T00:02:43.719Z 2024-01-06T00:02:43.719Z
3145832 3145832 20231013173516_jYV0e AU0021 2024-01-06T00:02:43.716Z 2024-01-06T00:02:43.716Z
3145785 3145785 20231013172119_7zn2h AU0021 2024-01-06T00:02:43.710Z 2024-01-06T00:02:43.710Z
3145759 3145759 20231013171119_MeygV AU0021 2024-01-06T00:02:43.706Z 2024-01-06T00:02:43.706Z
3145722 3145722 20231013165103_v2rdh AU0021 2024-01-06T00:02:43.701Z 2024-01-06T00:02:43.701Z
3145704 3145704 20231013164810_raYiz AU0021 2024-01-06T00:02:43.699Z 2024-01-06T00:02:43.699Z
3145657 3145657 20231013163607_hXcOK AU0021 2024-01-06T00:02:43.693Z 2024-01-06T00:02:43.693Z
3145648 3145648 20231013163505_7lWnL AU0021 2024-01-06T00:02:43.692Z 2024-01-06T00:02:43.692Z
3145557 3145557 20231013161942_yH3B0 AU0021 2024-01-06T00:02:43.681Z 2024-01-06T00:02:43.681Z
3145471 3145471 20231013155137_kEolZ AU0021 2024-01-06T00:02:43.671Z 2024-01-06T00:02:43.671Z
3145311 3145311 20231013151904_KYw2Z AU0021 2024-01-06T00:02:43.651Z 2024-01-06T00:02:43.651Z
3145217 3145217 20231013144737_t2dGH AU0021 2024-01-06T00:02:43.639Z 2024-01-06T00:02:43.639Z
3145109 3145109 20231013134035_nyLUN AU0021 2024-01-06T00:02:43.625Z 2024-01-06T00:02:43.625Z
3141860 3141860 20231012201929_k1O2V AU0021 2024-01-06T00:02:41.920Z 2024-01-06T00:02:41.920Z
3141857 3141857 20231012201821_NDN1m AU0021 2024-01-06T00:02:41.919Z 2024-01-06T00:02:41.919Z
3141824 3141824 20231012200445_7xA4p AU0021 2024-01-06T00:02:41.915Z 2024-01-06T00:02:41.915Z
3141779 3141779 20231012194913_kHFBo AU0021 2024-01-06T00:02:41.909Z 2024-01-06T00:02:41.909Z
3141695 3141695 20231012192224_4B6Rd AU0021 2024-01-06T00:02:41.898Z 2024-01-06T00:02:41.898Z
3141699 3141699 20231012192326_6sifp AU0021 2024-01-06T00:02:41.898Z 2024-01-06T00:02:41.898Z
3141669 3141669 20231012191510_Rr2UM AU0021 2024-01-06T00:02:41.895Z 2024-01-06T00:02:41.895Z
3141594 3141594 20231012185533_TOBX2 AU0021 2024-01-06T00:02:41.885Z 2024-01-06T00:02:41.885Z
3141562 3141562 20231012184921_RodYx AU0021 2024-01-06T00:02:41.881Z 2024-01-06T00:02:41.881Z
3141417 3141417 20231012181011_dywoA AU0021 2024-01-06T00:02:41.866Z 2024-01-06T00:02:41.866Z
3141340 3141340 20231012174324_7btyk AU0021 2024-01-06T00:02:41.857Z 2024-01-06T00:02:41.857Z
3141217 3141217 20231012170918_hb1wb AU0021 2024-01-06T00:02:41.842Z 2024-01-06T00:02:41.842Z
3141196 3141196 20231012170625_t96r3 AU0021 2024-01-06T00:02:41.840Z 2024-01-06T00:02:41.840Z
3141148 3141148 20231012164429_SyYl0 AU0021 2024-01-06T00:02:41.834Z 2024-01-06T00:02:41.834Z
3141139 3141139 20231012164317_wQaek AU0021 2024-01-06T00:02:41.833Z 2024-01-06T00:02:41.833Z
3141144 3141144 20231012164349_fmxe3 AU0021 2024-01-06T00:02:41.833Z 2024-01-06T00:02:41.833Z
3140856 3140856 20231012150824_b3E43 AU0021 2024-01-06T00:02:41.797Z 2024-01-06T00:02:41.797Z
3140825 3140825 20231012145416_IyJ1P AU0021 2024-01-06T00:02:41.794Z 2024-01-06T00:02:41.794Z
3140695 3140695 20231012140749_dvuY5 AU0021 2024-01-06T00:02:41.777Z 2024-01-06T00:02:41.777Z
3140499 3140499 20231012124423_KhUOw AU0021 2024-01-06T00:02:41.752Z 2024-01-06T00:02:41.752Z
3135220 3135220 20231011203014_wOhha AU0021 2024-01-06T00:02:39.830Z 2024-01-06T00:02:39.830Z
3135059 3135059 20231011201035_qpz8Y AU0021 2024-01-06T00:02:39.812Z 2024-01-06T00:02:39.812Z
3134415 3134415 20231011185558_XcFD4 AU0021 2024-01-06T00:02:39.741Z 2024-01-06T00:02:39.741Z
3134268 3134268 20231011183452_eChik AU0021 2024-01-06T00:02:39.723Z 2024-01-06T00:02:39.723Z
3134232 3134232 20231011182914_1rf0I AU0021 2024-01-06T00:02:39.719Z 2024-01-06T00:02:39.719Z
3134225 3134225 20231011182739_9HaCf AU0021 2024-01-06T00:02:39.718Z 2024-01-06T00:02:39.718Z
3134075 3134075 20231011181230_sPh26 AU0021 2024-01-06T00:02:39.704Z 2024-01-06T00:02:39.704Z
3133737 3133737 20231011173644_i9XGs AU0021 2024-01-06T00:02:39.669Z 2024-01-06T00:02:39.669Z
3133681 3133681 20231011173143_52rlW AU0021 2024-01-06T00:02:39.664Z 2024-01-06T00:02:39.664Z
3133677 3133677 20231011173030_mADrA AU0021 2024-01-06T00:02:39.663Z 2024-01-06T00:02:39.663Z
3133654 3133654 20231011172645_UTpLC AU0021 2024-01-06T00:02:39.661Z 2024-01-06T00:02:39.661Z
3133317 3133317 20231011161445_Z0vWO AU0021 2024-01-06T00:02:39.622Z 2024-01-06T00:02:39.622Z
3132960 3132960 20231011152611_2cknt AU0021 2024-01-06T00:02:39.584Z 2024-01-06T00:02:39.584Z
3132893 3132893 20231011151945_mvMmr AU0021 2024-01-06T00:02:39.577Z 2024-01-06T00:02:39.577Z
3132783 3132783 20231011145929_MIqz3 AU0021 2024-01-06T00:02:39.566Z 2024-01-06T00:02:39.566Z
3132621 3132621 20231011143354_69we0 AU0021 2024-01-06T00:02:39.551Z 2024-01-06T00:02:39.551Z
3132558 3132558 20231011142353_A122i AU0021 2024-01-06T00:02:39.545Z 2024-01-06T00:02:39.545Z

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