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

3,358 rows where station_code = "AU0007" 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
3074406 3074406 20230928143106_nkuyd AU0007 2024-01-06T00:02:15.185Z 2024-01-06T00:02:15.185Z
3049504 3049504 20230923181056_LgfNd AU0007 2024-01-06T00:02:07.375Z 2024-01-06T00:02:07.375Z
3048593 3048593 20230923143007_vCqq2 AU0007 2024-01-06T00:02:05.942Z 2024-01-06T00:02:05.942Z
2983272 2983272 20230912165759_RpHZy AU0007 2024-01-06T00:01:46.534Z 2024-01-06T00:01:46.534Z
2983260 2983260 20230912165411_iUiIu AU0007 2024-01-06T00:01:46.532Z 2024-01-06T00:01:46.532Z
2983147 2983147 20230912162042_EL0Qt AU0007 2024-01-06T00:01:46.518Z 2024-01-06T00:01:46.518Z
2982493 2982493 20230912122554_tgWNP AU0007 2024-01-06T00:01:46.439Z 2024-01-06T00:01:46.439Z
2383533 2383533 20230414203234_lnvwZ AU0007 2024-01-05T23:56:54.253Z 2024-01-05T23:56:54.253Z
2383351 2383351 20230414170643_CaACk AU0007 2024-01-05T23:56:54.229Z 2024-01-05T23:56:54.229Z
2383011 2383011 20230414135209_Mcd58 AU0007 2024-01-05T23:56:54.189Z 2024-01-05T23:56:54.189Z
2382830 2382830 20230414120621_1axJs AU0007 2024-01-05T23:56:52.922Z 2024-01-05T23:56:52.922Z
2380372 2380372 20230413172110_A5S0b AU0007 2024-01-05T23:56:52.631Z 2024-01-05T23:56:52.631Z
2378932 2378932 20230412203139_NTyEp AU0007 2024-01-05T23:56:51.279Z 2024-01-05T23:56:51.279Z
2378843 2378843 20230412184351_2SYxo AU0007 2024-01-05T23:56:51.267Z 2024-01-05T23:56:51.267Z
2378819 2378819 20230412181518_f3NlC AU0007 2024-01-05T23:56:51.263Z 2024-01-05T23:56:51.263Z
2378754 2378754 20230412164310_BIB3h AU0007 2024-01-05T23:56:51.256Z 2024-01-05T23:56:51.256Z
2378556 2378556 20230412125038_hD5mo AU0007 2024-01-05T23:56:51.231Z 2024-01-05T23:56:51.231Z
2373622 2373622 20230410130753_2OMtD AU0007 2024-01-05T23:56:47.827Z 2024-01-05T23:56:47.827Z
2372057 2372057 20230409184940_0al4Q AU0007 2024-01-05T23:56:45.230Z 2024-01-05T23:56:45.230Z
2372049 2372049 20230409183537_RqiLM AU0007 2024-01-05T23:56:45.227Z 2024-01-05T23:56:45.227Z
2372033 2372033 20230409181446_1vmKh AU0007 2024-01-05T23:56:45.221Z 2024-01-05T23:56:45.221Z
2371991 2371991 20230409170703_wjxnl AU0007 2024-01-05T23:56:45.207Z 2024-01-05T23:56:45.207Z
2371957 2371957 20230409161916_UDTJI AU0007 2024-01-05T23:56:45.195Z 2024-01-05T23:56:45.195Z
2371929 2371929 20230409155217_rt6lm AU0007 2024-01-05T23:56:45.186Z 2024-01-05T23:56:45.186Z
2371848 2371848 20230409124443_2RKnp AU0007 2024-01-05T23:56:45.157Z 2024-01-05T23:56:45.157Z
2367598 2367598 20230406205007_s2NY3 AU0007 2024-01-05T23:56:40.429Z 2024-01-05T23:56:40.429Z
2367568 2367568 20230406190334_ILklK AU0007 2024-01-05T23:56:40.425Z 2024-01-05T23:56:40.425Z
2367550 2367550 20230406174522_CJ1Xm AU0007 2024-01-05T23:56:40.423Z 2024-01-05T23:56:40.423Z
2367553 2367553 20230406174917_n5g5N AU0007 2024-01-05T23:56:40.423Z 2024-01-05T23:56:40.423Z
2367495 2367495 20230406153735_5wRf5 AU0007 2024-01-05T23:56:40.415Z 2024-01-05T23:56:40.415Z
2367160 2367160 20230405212118_8d7ZP AU0007 2024-01-05T23:56:39.270Z 2024-01-05T23:56:39.270Z
2367132 2367132 20230405205351_mhEZy AU0007 2024-01-05T23:56:39.268Z 2024-01-05T23:56:39.268Z
2367120 2367120 20230405204947_Th3cK AU0007 2024-01-05T23:56:39.266Z 2024-01-05T23:56:39.266Z
2367055 2367055 20230405194846_nhfgb AU0007 2024-01-05T23:56:39.259Z 2024-01-05T23:56:39.259Z
2367060 2367060 20230405195112_PUHzS AU0007 2024-01-05T23:56:39.259Z 2024-01-05T23:56:39.259Z
2367042 2367042 20230405194546_A8oy5 AU0007 2024-01-05T23:56:39.258Z 2024-01-05T23:56:39.258Z
2366991 2366991 20230405184525_IHcPM AU0007 2024-01-05T23:56:39.251Z 2024-01-05T23:56:39.251Z
2366997 2366997 20230405185736_uXN2J AU0007 2024-01-05T23:56:39.251Z 2024-01-05T23:56:39.251Z
2366980 2366980 20230405181738_NqNAS AU0007 2024-01-05T23:56:39.249Z 2024-01-05T23:56:39.249Z
2366973 2366973 20230405175828_Gd9qg AU0007 2024-01-05T23:56:39.248Z 2024-01-05T23:56:39.248Z
2366975 2366975 20230405180310_YeecJ AU0007 2024-01-05T23:56:39.248Z 2024-01-05T23:56:39.248Z
2366953 2366953 20230405172315_UkYie AU0007 2024-01-05T23:56:39.246Z 2024-01-05T23:56:39.246Z
2366947 2366947 20230405170501_SboZG AU0007 2024-01-05T23:56:39.245Z 2024-01-05T23:56:39.245Z
2366906 2366906 20230405144728_C3GsS AU0007 2024-01-05T23:56:39.239Z 2024-01-05T23:56:39.239Z
2366045 2366045 20230404212005_V8yCT AU0007 2024-01-05T23:56:38.042Z 2024-01-05T23:56:38.042Z
2366037 2366037 20230404211722_WHy4T AU0007 2024-01-05T23:56:38.041Z 2024-01-05T23:56:38.041Z
2366014 2366014 20230404205052_HY5J5 AU0007 2024-01-05T23:56:38.038Z 2024-01-05T23:56:38.038Z
2366020 2366020 20230404205200_AZ43a AU0007 2024-01-05T23:56:38.038Z 2024-01-05T23:56:38.038Z
2365993 2365993 20230404202624_oFMrU AU0007 2024-01-05T23:56:38.036Z 2024-01-05T23:56:38.036Z
2365969 2365969 20230404194346_SSsoh AU0007 2024-01-05T23:56:38.033Z 2024-01-05T23:56:38.033Z
2365957 2365957 20230404193732_tuaAf AU0007 2024-01-05T23:56:38.032Z 2024-01-05T23:56:38.032Z
2365952 2365952 20230404193346_f73pW AU0007 2024-01-05T23:56:38.031Z 2024-01-05T23:56:38.031Z
2365934 2365934 20230404190545_7ok4G AU0007 2024-01-05T23:56:38.029Z 2024-01-05T23:56:38.029Z
2365924 2365924 20230404185526_Fv5AC AU0007 2024-01-05T23:56:38.028Z 2024-01-05T23:56:38.028Z
2365919 2365919 20230404184253_cLPNa AU0007 2024-01-05T23:56:38.027Z 2024-01-05T23:56:38.027Z
2365900 2365900 20230404181916_pVSDN AU0007 2024-01-05T23:56:38.025Z 2024-01-05T23:56:38.025Z
2365903 2365903 20230404181936_gqT2E AU0007 2024-01-05T23:56:38.025Z 2024-01-05T23:56:38.025Z
2365884 2365884 20230404180058_y8Ovd AU0007 2024-01-05T23:56:38.024Z 2024-01-05T23:56:38.024Z
2365891 2365891 20230404181314_EL8WZ AU0007 2024-01-05T23:56:38.024Z 2024-01-05T23:56:38.024Z
2365876 2365876 20230404175945_zAjcA AU0007 2024-01-05T23:56:38.023Z 2024-01-05T23:56:38.023Z
2365880 2365880 20230404180056_744EI AU0007 2024-01-05T23:56:38.023Z 2024-01-05T23:56:38.023Z
2365866 2365866 20230404174933_99BQg AU0007 2024-01-05T23:56:38.022Z 2024-01-05T23:56:38.022Z
2365871 2365871 20230404175829_mee7O AU0007 2024-01-05T23:56:38.022Z 2024-01-05T23:56:38.022Z
2365853 2365853 20230404173755_Wo3LN AU0007 2024-01-05T23:56:38.020Z 2024-01-05T23:56:38.020Z
2365815 2365815 20230404165148_OjOPO AU0007 2024-01-05T23:56:38.015Z 2024-01-05T23:56:38.015Z
2365779 2365779 20230404161739_Y3kr7 AU0007 2024-01-05T23:56:38.011Z 2024-01-05T23:56:38.011Z
2363900 2363900 20230403184512_7iLEF AU0007 2024-01-05T23:56:36.715Z 2024-01-05T23:56:36.715Z
2363886 2363886 20230403182339_2iTP4 AU0007 2024-01-05T23:56:36.713Z 2024-01-05T23:56:36.713Z
2363849 2363849 20230403172758_IaU6A AU0007 2024-01-05T23:56:36.708Z 2024-01-05T23:56:36.708Z
2363796 2363796 20230403164827_r4OD9 AU0007 2024-01-05T23:56:36.701Z 2024-01-05T23:56:36.701Z
2363799 2363799 20230403165114_322Gx AU0007 2024-01-05T23:56:36.701Z 2024-01-05T23:56:36.701Z
2363786 2363786 20230403164424_TnNwb AU0007 2024-01-05T23:56:36.700Z 2024-01-05T23:56:36.700Z
2363691 2363691 20230403150306_MZGf2 AU0007 2024-01-05T23:56:36.686Z 2024-01-05T23:56:36.686Z
2361874 2361874 20230402210425_nIfXj AU0007 2024-01-05T23:56:35.357Z 2024-01-05T23:56:35.357Z
2361836 2361836 20230402205316_0BX2m AU0007 2024-01-05T23:56:35.352Z 2024-01-05T23:56:35.352Z
2361825 2361825 20230402205041_rv2i3 AU0007 2024-01-05T23:56:35.351Z 2024-01-05T23:56:35.351Z
2361812 2361812 20230402204210_Ulv3v AU0007 2024-01-05T23:56:35.350Z 2024-01-05T23:56:35.350Z
2361804 2361804 20230402204120_XKpcr AU0007 2024-01-05T23:56:35.349Z 2024-01-05T23:56:35.349Z
2361793 2361793 20230402203624_HR3zX AU0007 2024-01-05T23:56:35.348Z 2024-01-05T23:56:35.348Z
2361755 2361755 20230402201310_TyX06 AU0007 2024-01-05T23:56:35.344Z 2024-01-05T23:56:35.344Z
2361745 2361745 20230402200559_uvG0l AU0007 2024-01-05T23:56:35.343Z 2024-01-05T23:56:35.343Z
2361700 2361700 20230402194842_mx4yj AU0007 2024-01-05T23:56:35.339Z 2024-01-05T23:56:35.339Z
2361678 2361678 20230402193332_R2RSQ AU0007 2024-01-05T23:56:35.337Z 2024-01-05T23:56:35.337Z
2361665 2361665 20230402192317_yO9aY AU0007 2024-01-05T23:56:35.336Z 2024-01-05T23:56:35.336Z
2361638 2361638 20230402191703_LDcMo AU0007 2024-01-05T23:56:35.334Z 2024-01-05T23:56:35.334Z
2361626 2361626 20230402190454_gdp1b AU0007 2024-01-05T23:56:35.333Z 2024-01-05T23:56:35.333Z
2361612 2361612 20230402185656_m3wVT AU0007 2024-01-05T23:56:35.332Z 2024-01-05T23:56:35.332Z
2361596 2361596 20230402184135_3haUw AU0007 2024-01-05T23:56:35.329Z 2024-01-05T23:56:35.329Z
2361575 2361575 20230402182448_RBgCg AU0007 2024-01-05T23:56:35.327Z 2024-01-05T23:56:35.327Z
2361544 2361544 20230402180458_Vh623 AU0007 2024-01-05T23:56:35.324Z 2024-01-05T23:56:35.324Z
2361512 2361512 20230402174126_x2LML AU0007 2024-01-05T23:56:35.321Z 2024-01-05T23:56:35.321Z
2361513 2361513 20230402174128_Ez4Q0 AU0007 2024-01-05T23:56:35.321Z 2024-01-05T23:56:35.321Z
2361413 2361413 20230402165829_bORXG AU0007 2024-01-05T23:56:35.309Z 2024-01-05T23:56:35.309Z
2361373 2361373 20230402163554_MFlZA AU0007 2024-01-05T23:56:35.305Z 2024-01-05T23:56:35.305Z
2361314 2361314 20230402155931_i0Lh0 AU0007 2024-01-05T23:56:35.298Z 2024-01-05T23:56:35.298Z
2361205 2361205 20230402145142_zYMQM AU0007 2024-01-05T23:56:35.283Z 2024-01-05T23:56:35.283Z
2361163 2361163 20230402134837_N4WjQ AU0007 2024-01-05T23:56:35.278Z 2024-01-05T23:56:35.278Z
2361062 2361062 20230402120205_rzA5y AU0007 2024-01-05T23:56:35.265Z 2024-01-05T23:56:35.265Z
2360235 2360235 20230401203557_DvYBB AU0007 2024-01-05T23:56:34.010Z 2024-01-05T23:56:34.010Z
2360223 2360223 20230401200953_F8BKm AU0007 2024-01-05T23:56:34.009Z 2024-01-05T23:56:34.009Z

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