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

8,358 rows where station_code = "AU000R" 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
9918709 9918709 20260512200204_5iJa0 AU000R 2026-05-14T12:34:04.194Z 2026-05-14T12:41:30.099Z
9918688 9918688 20260512195418_0Ru4V AU000R 2026-05-14T12:34:01.426Z 2026-05-14T12:41:30.092Z
9918674 9918674 20260512195003_LDiWM AU000R 2026-05-14T12:33:59.449Z 2026-05-14T12:41:30.086Z
9918567 9918567 20260512192505_wa5Ec AU000R 2026-05-14T12:33:32.097Z 2026-05-14T12:41:30.042Z
9918544 9918544 20260512192026_ZhVpq AU000R 2026-05-14T12:33:24.765Z 2026-05-14T12:41:30.033Z
9918522 9918522 20260512191459_HqAnL AU000R 2026-05-14T12:33:09.075Z 2026-05-14T12:41:30.023Z
9918480 9918480 20260512190324_2hEdV AU000R 2026-05-14T12:32:57.840Z 2026-05-14T12:41:30.002Z
9918422 9918422 20260512184021_SCSA0 AU000R 2026-05-14T12:32:26.323Z 2026-05-14T12:41:29.951Z
9918410 9918410 20260512183705_Z2Mix AU000R 2026-05-14T12:32:23.715Z 2026-05-14T12:41:29.945Z
9918340 9918340 20260512181550_aXzDM AU000R 2026-05-14T12:31:55.455Z 2026-05-14T12:41:29.907Z
9918318 9918318 20260512180729_Ijg5F AU000R 2026-05-14T12:31:44.141Z 2026-05-14T12:41:29.884Z
9918308 9918308 20260512180432_CE334 AU000R 2026-05-14T12:31:30.446Z 2026-05-14T12:41:29.874Z
9918274 9918274 20260512175518_wGeCc AU000R 2026-05-14T12:31:16.273Z 2026-05-14T12:41:29.852Z
9918181 9918181 20260512172014_B73aE AU000R 2026-05-14T12:30:11.731Z 2026-05-14T12:41:29.677Z
9918151 9918151 20260512170524_OM4Bp AU000R 2026-05-14T12:29:30.308Z 2026-05-14T12:41:29.589Z
9918084 9918084 20260512163632_rUSwW AU000R 2026-05-14T12:28:40.948Z 2026-05-14T12:41:29.508Z
9918074 9918074 20260512163237_KVWAN AU000R 2026-05-14T12:28:26.668Z 2026-05-14T12:41:29.493Z
9917939 9917939 20260512153354_6vCD3 AU000R 2026-05-14T12:27:16.515Z 2026-05-14T12:41:28.413Z
9917808 9917808 20260512144417_A27BG AU000R 2026-05-14T12:26:28.621Z 2026-05-14T12:41:28.288Z
9917778 9917778 20260512142700_Z5t4z AU000R 2026-05-14T12:26:15.883Z 2026-05-14T12:41:28.216Z
9917747 9917747 20260512141505_Ndnra AU000R 2026-05-14T12:26:00.368Z 2026-05-14T12:41:28.186Z
9917741 9917741 20260512141256_pDGeL AU000R 2026-05-14T12:25:58.736Z 2026-05-14T12:41:28.180Z
9917551 9917551 20260512122711_3Xa5H AU000R 2026-05-14T12:24:46.586Z 2026-05-14T12:41:27.950Z
9917513 9917513 20260512115909_ahQyi AU000R 2026-05-14T12:24:28.528Z 2026-05-14T12:41:27.883Z
9917477 9917477 20260512111508_JFcYI AU000R 2026-05-14T12:24:09.091Z 2026-05-14T12:41:27.766Z
9917439 9917439 20260512102509_hmazp AU000R 2026-05-14T12:23:26.717Z 2026-05-14T12:41:27.532Z
9917252 9917252 20260513155226_bwlD0 AU000R 2026-05-14T12:19:05.748Z 2026-05-14T12:19:05.748Z
9917063 9917063 20260513154523_GZu8c AU000R 2026-05-14T12:18:36.751Z 2026-05-14T12:18:36.751Z
9916860 9916860 20260513153418_DBXJr AU000R 2026-05-14T12:18:09.144Z 2026-05-14T12:18:09.144Z
9915626 9915626 20260513141255_8Ez9Y AU000R 2026-05-14T12:15:02.016Z 2026-05-14T12:15:02.016Z
9914944 9914944 20260513130305_YQncS AU000R 2026-05-14T12:13:14.874Z 2026-05-14T12:13:14.874Z
9914934 9914934 20260513130222_gCEgE AU000R 2026-05-14T12:13:13.454Z 2026-05-14T12:13:13.454Z
9914767 9914767 20260513123921_ZXm6y AU000R 2026-05-14T12:12:45.519Z 2026-05-14T12:12:45.519Z
9914764 9914764 20260513123918_MHITn AU000R 2026-05-14T12:12:44.751Z 2026-05-14T12:12:44.751Z
9914761 9914761 20260513123851_XDRfm AU000R 2026-05-14T12:12:42.363Z 2026-05-14T12:12:42.363Z
9914598 9914598 20260513122414_joQnl AU000R 2026-05-14T12:12:11.747Z 2026-05-14T12:12:11.747Z
9914241 9914241 20260513114611_TYvQW AU000R 2026-05-14T12:11:12.479Z 2026-05-14T12:11:12.479Z
9908930 9908930 20260511200342_WEEDL AU000R 2026-05-13T12:33:33.622Z 2026-05-14T12:51:03.999Z
9908879 9908879 20260511195734_kGDu5 AU000R 2026-05-13T12:33:12.126Z 2026-05-14T12:50:58.978Z
9908478 9908478 20260511181939_315UW AU000R 2026-05-13T12:31:28.155Z 2026-05-14T12:50:18.834Z
9908460 9908460 20260511181656_qQ3eM AU000R 2026-05-13T12:31:22.254Z 2026-05-14T12:50:17.468Z
9908373 9908373 20260511174209_JTk2T AU000R 2026-05-13T12:30:41.363Z 2026-05-14T12:49:53.845Z
9908150 9908150 20260511151639_aqEc3 AU000R 2026-05-13T12:28:41.202Z 2026-05-14T12:48:36.789Z
9908023 9908023 20260511104304_DLL0W AU000R 2026-05-13T12:26:33.929Z 2026-05-14T12:46:55.975Z
9898566 9898566 20260510200805_57g7c AU000R 2026-05-12T12:34:09.607Z 2026-05-14T13:01:57.245Z
9898466 9898466 20260510194738_CtIuM AU000R 2026-05-12T12:34:00.509Z 2026-05-14T13:01:39.404Z
9898351 9898351 20260510192807_DL3yq AU000R 2026-05-12T12:33:31.526Z 2026-05-14T13:01:33.531Z
9898347 9898347 20260510192733_7xS28 AU000R 2026-05-12T12:33:31.186Z 2026-05-14T13:01:33.436Z
9898303 9898303 20260510191928_rxvE8 AU000R 2026-05-12T12:33:26.221Z 2026-05-14T13:01:31.947Z
9898181 9898181 20260510190258_3AYde AU000R 2026-05-12T12:32:54.907Z 2026-05-14T13:01:25.412Z
9898173 9898173 20260510190110_kjese AU000R 2026-05-12T12:32:51.535Z 2026-05-14T13:01:25.054Z
9898162 9898162 20260510190021_TZKYs AU000R 2026-05-12T12:32:50.940Z 2026-05-14T13:01:24.535Z
9898055 9898055 20260510183234_Nuy0t AU000R 2026-05-12T12:32:14.308Z 2026-05-14T13:01:00.099Z
9898023 9898023 20260510182133_wKKxx AU000R 2026-05-12T12:32:03.493Z 2026-05-14T13:00:56.522Z
9898007 9898007 20260510182048_MgQDZ AU000R 2026-05-12T12:32:01.576Z 2026-05-14T13:00:55.144Z
9897989 9897989 20260510181829_chVrq AU000R 2026-05-12T12:31:45.514Z 2026-05-14T13:00:53.447Z
9897892 9897892 20260510175344_hKEZD AU000R 2026-05-12T12:30:56.900Z 2026-05-14T13:00:32.658Z
9897828 9897828 20260510173832_5DFuB AU000R 2026-05-12T12:30:15.205Z 2026-05-14T13:00:21.465Z
9897822 9897822 20260510173505_8QyUm AU000R 2026-05-12T12:30:11.076Z 2026-05-14T13:00:18.941Z
9897716 9897716 20260510165638_H02SC AU000R 2026-05-12T12:29:00.192Z 2026-05-14T12:59:21.013Z
9897644 9897644 20260510163431_iuvXL AU000R 2026-05-12T12:28:30.610Z 2026-05-14T12:59:10.553Z
9897620 9897620 20260510162329_qv2Kx AU000R 2026-05-12T12:28:15.103Z 2026-05-14T12:59:07.120Z
9897587 9897587 20260510161230_3fhAp AU000R 2026-05-12T12:28:00.755Z 2026-05-14T12:59:01.048Z
9897409 9897409 20260510150557_S9wZD AU000R 2026-05-12T12:26:55.452Z 2026-05-14T12:58:23.553Z
9897371 9897371 20260510145303_5B2kH AU000R 2026-05-12T12:26:34.932Z 2026-05-14T12:58:04.590Z
9897263 9897263 20260510140711_d16La AU000R 2026-05-12T12:25:57.861Z 2026-05-14T12:57:47.110Z
9897148 9897148 20260510131235_2ogqz AU000R 2026-05-12T12:25:08.956Z 2026-05-14T12:57:19.072Z
9897126 9897126 20260510130154_GJ2Gh AU000R 2026-05-12T12:25:02.749Z 2026-05-14T12:57:16.528Z
9896923 9896923 20260510092423_V7NpH AU000R 2026-05-12T12:22:59.756Z 2026-05-14T12:55:51.176Z
9896910 9896910 20260511193219_byVye AU000R 2026-05-12T12:20:26.915Z 2026-05-14T12:50:52.858Z
9896905 9896905 20260511192630_QO85V AU000R 2026-05-12T12:20:22.448Z 2026-05-14T12:50:51.033Z
9896902 9896902 20260511192202_WWtWB AU000R 2026-05-12T12:20:18.134Z 2026-05-12T12:20:18.134Z
9896897 9896897 20260511191446_aX9WK AU000R 2026-05-12T12:20:17.159Z 2026-05-14T12:50:48.011Z
9896893 9896893 20260511191027_RIkeH AU000R 2026-05-12T12:20:16.283Z 2026-05-14T12:50:47.023Z
9896877 9896877 20260511184945_BDNv1 AU000R 2026-05-12T12:20:10.327Z 2026-05-14T12:50:29.816Z
9896873 9896873 20260511184407_tny7I AU000R 2026-05-12T12:20:09.248Z 2026-05-14T12:50:27.545Z
9896848 9896848 20260511182819_1PucW AU000R 2026-05-12T12:20:06.725Z 2026-05-14T12:50:21.125Z
9896843 9896843 20260511182727_6g23p AU000R 2026-05-12T12:20:05.837Z 2026-05-14T12:50:20.766Z
9896749 9896749 20260511181351_dQCfW AU000R 2026-05-12T12:19:56.719Z 2026-05-14T12:50:16.167Z
9896669 9896669 20260511180137_oyI5E AU000R 2026-05-12T12:19:38.363Z 2026-05-14T12:50:11.150Z
9896541 9896541 20260511174301_adLTH AU000R 2026-05-12T12:19:24.853Z 2026-05-14T12:49:54.158Z
9896261 9896261 20260511171130_Sj6DK AU000R 2026-05-12T12:18:39.470Z 2026-05-14T12:49:39.328Z
9895953 9895953 20260511162037_jePSi AU000R 2026-05-12T12:17:39.301Z 2026-05-14T12:49:09.336Z
9895691 9895691 20260511153740_WcSiF AU000R 2026-05-12T12:16:54.852Z 2026-05-14T12:48:43.274Z
9895098 9895098 20260511141644_RO2px AU000R 2026-05-12T12:15:07.770Z 2026-05-14T12:48:09.051Z
9895036 9895036 20260511140606_fYMnR AU000R 2026-05-12T12:14:57.536Z 2026-05-14T12:48:06.791Z
9894974 9894974 20260511134918_R3vqO AU000R 2026-05-12T12:14:42.762Z 2026-05-14T12:48:03.828Z
9894947 9894947 20260511134346_BITMi AU000R 2026-05-12T12:14:38.437Z 2026-05-14T12:48:02.246Z
9894720 9894720 20260511130255_T5Br1 AU000R 2026-05-12T12:13:57.327Z 2026-05-14T12:47:44.135Z
9894477 9894477 20260511121835_THRFc AU000R 2026-05-12T12:13:09.001Z 2026-05-14T12:47:31.838Z
9894280 9894280 20260511113447_9bsG5 AU000R 2026-05-12T12:12:23.645Z 2026-05-14T12:47:13.948Z
9894243 9894243 20260511112731_pY3Ym AU000R 2026-05-12T12:12:15.198Z 2026-05-14T12:47:11.720Z
9893891 9893891 20260511104304_6fMlh AU000R 2026-05-12T12:10:59.096Z 2026-05-12T12:10:59.096Z
9893481 9893481 20260511094837_TaMTy AU000R 2026-05-12T12:09:29.362Z 2026-05-14T12:46:28.437Z
9888879 9888879 20260509195245_gGEp5 AU000R 2026-05-11T12:37:32.767Z 2026-05-14T13:13:28.651Z
9888581 9888581 20260509191248_Hihs8 AU000R 2026-05-11T12:36:45.647Z 2026-05-14T13:12:56.481Z
9887391 9887391 20260509152400_2WfNL AU000R 2026-05-11T12:29:20.811Z 2026-05-14T13:09:39.780Z
9887019 9887019 20260509121241_Mhtk4 AU000R 2026-05-11T12:26:40.027Z 2026-05-14T13:07:57.543Z
9886893 9886893 20260509091756_btttY AU000R 2026-05-11T12:24:55.313Z 2026-05-14T13:06:39.192Z
9886884 9886884 20260509083011_KjZYY AU000R 2026-05-11T12:24:41.029Z 2026-05-14T13:06:29.348Z

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