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,471 rows where station_code = "AU0041" 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
8683608 8683608 20251130174844_0FwMg AU0041 2025-12-04T14:30:50.902Z 2025-12-04T14:30:50.902Z
8683603 8683603 20251130174315_zTkru AU0041 2025-12-04T14:30:48.329Z 2025-12-04T14:30:48.329Z
8683570 8683570 20251130164811_yVR3N AU0041 2025-12-04T14:30:16.424Z 2025-12-04T14:30:16.424Z
8683558 8683558 20251130160333_BKVtS AU0041 2025-12-04T14:30:08.422Z 2025-12-04T14:30:08.422Z
8683491 8683491 20251130123659_Y0oWx AU0041 2025-12-04T14:28:40.417Z 2025-12-04T14:28:40.417Z
8678321 8678321 20251203174913_Upxj8 AU0041 2025-12-04T14:04:19.875Z 2025-12-04T14:04:19.875Z
8678318 8678318 20251203174748_MWLXr AU0041 2025-12-04T14:04:19.325Z 2025-12-04T14:04:19.325Z
8678315 8678315 20251203174727_2qnUb AU0041 2025-12-04T14:04:18.781Z 2025-12-04T14:04:18.781Z
8678286 8678286 20251203165058_OeVyg AU0041 2025-12-04T14:04:12.802Z 2025-12-04T14:04:12.802Z
8678284 8678284 20251203164954_OWOOK AU0041 2025-12-04T14:04:12.212Z 2025-12-04T14:04:12.212Z
8678126 8678126 20251203150002_RgmTU AU0041 2025-12-04T14:03:35.825Z 2025-12-04T14:03:35.825Z
8677940 8677940 20251203132906_jwIi4 AU0041 2025-12-04T14:03:03.990Z 2025-12-04T14:03:03.990Z
8677885 8677885 20251203125837_cgxZt AU0041 2025-12-04T14:02:52.793Z 2025-12-04T14:02:52.793Z
8677825 8677825 20251203124142_3GphK AU0041 2025-12-04T14:02:45.765Z 2025-12-04T14:02:45.765Z
8677716 8677716 20251203115535_e2TZC AU0041 2025-12-04T14:02:21.901Z 2025-12-04T14:02:21.901Z
8670344 8670344 20251202172240_NRLt2 AU0041 2025-12-03T14:08:07.190Z 2025-12-04T14:19:08.196Z
8670275 8670275 20251202155559_c0b3n AU0041 2025-12-03T14:07:48.010Z 2025-12-04T14:19:08.143Z
8670246 8670246 20251202154207_0AmP1 AU0041 2025-12-03T14:07:42.350Z 2025-12-04T14:19:08.130Z
8670220 8670220 20251202153120_LLWav AU0041 2025-12-03T14:07:28.801Z 2025-12-04T14:19:08.124Z
8670211 8670211 20251202152503_ty0Wm AU0041 2025-12-03T14:07:26.654Z 2025-12-04T14:19:08.070Z
8670209 8670209 20251202152313_Ym1pz AU0041 2025-12-03T14:07:26.116Z 2025-12-04T14:19:08.068Z
8670173 8670173 20251202142126_EOcVa AU0041 2025-12-03T14:07:17.485Z 2025-12-04T14:19:08.041Z
8670169 8670169 20251202141507_SOewD AU0041 2025-12-03T14:07:16.579Z 2025-12-04T14:19:08.037Z
8670162 8670162 20251202140454_fyRmp AU0041 2025-12-03T14:07:14.829Z 2025-12-04T14:19:08.034Z
8670150 8670150 20251202134032_AbJZS AU0041 2025-12-03T14:07:03.535Z 2025-12-04T14:19:08.028Z
8670141 8670141 20251202133042_4A1GI AU0041 2025-12-03T14:07:02.114Z 2025-12-04T14:19:08.023Z
8670115 8670115 20251202131306_u2rky AU0041 2025-12-03T14:06:57.616Z 2025-12-04T14:19:08.013Z
8669731 8669731 20251202120530_PdUgQ AU0041 2025-12-03T14:05:18.458Z 2025-12-04T14:19:07.897Z
8669689 8669689 20251202115904_8a1GB AU0041 2025-12-03T14:05:10.251Z 2025-12-04T14:19:07.887Z
8669558 8669558 20251202113136_EITe3 AU0041 2025-12-03T14:04:31.951Z 2025-12-04T14:19:07.857Z
8669197 8669197 20251202103002_LBzgK AU0041 2025-12-03T14:02:49.864Z 2025-12-04T14:19:07.648Z
8669056 8669056 20251202100535_UzFHx AU0041 2025-12-03T14:02:10.703Z 2025-12-04T14:19:07.617Z
8649504 8649504 20251129173634_02yQV AU0041 2025-12-01T14:12:51.928Z 2025-12-04T14:38:00.683Z
8649423 8649423 20251129172327_4lfGR AU0041 2025-12-01T14:12:29.827Z 2025-12-04T14:37:57.147Z
8649398 8649398 20251129172128_ITF7e AU0041 2025-12-01T14:12:25.177Z 2025-12-04T14:37:55.846Z
8648983 8648983 20251129153747_0o2ZG AU0041 2025-12-01T14:10:17.527Z 2025-12-04T14:37:21.202Z
8648799 8648799 20251129125654_O9bb9 AU0041 2025-12-01T14:07:01.975Z 2025-12-04T14:36:43.287Z
8640680 8640680 20251129152714_YBWwZ AU0041 2025-11-30T14:09:15.154Z 2025-12-04T14:37:18.524Z
8640199 8640199 20251129130442_xHc23 AU0041 2025-11-30T14:07:31.174Z 2025-11-30T14:07:31.174Z
8640137 8640137 20251129125652_6T4WU AU0041 2025-11-30T14:07:22.034Z 2025-11-30T14:07:22.034Z
8621723 8621723 20251126161433_uP3rY AU0041 2025-11-28T14:16:28.224Z 2025-12-04T15:01:42.689Z
8621682 8621682 20251126160207_cEAUM AU0041 2025-11-28T14:16:22.635Z 2025-12-04T15:01:41.821Z
8621666 8621666 20251126155916_62bKv AU0041 2025-11-28T14:16:20.728Z 2025-12-04T15:01:41.529Z
8619058 8619058 20251127175624_IxT19 AU0041 2025-11-28T14:07:05.098Z 2025-12-04T14:54:23.249Z
8619013 8619013 20251127163804_3CSqk AU0041 2025-11-28T14:06:48.459Z 2025-12-04T14:53:44.514Z
8604313 8604313 20251123163614_2x1cn AU0041 2025-11-26T14:31:34.326Z 2025-12-02T15:09:59.159Z
8519138 8519138 20251118163847_tnlzr AU0041 2025-11-20T14:05:59.525Z 2025-11-27T15:11:25.593Z
8518783 8518783 20251118153715_CFxxD AU0041 2025-11-20T14:04:45.930Z 2025-11-27T15:11:12.468Z
8518694 8518694 20251118152258_K2R9e AU0041 2025-11-20T14:04:25.896Z 2025-11-27T15:11:09.125Z
8518600 8518600 20251118145618_F6POM AU0041 2025-11-20T14:04:10.686Z 2025-11-27T15:11:07.009Z
8518498 8518498 20251118142417_GnRWF AU0041 2025-11-20T14:03:39.960Z 2025-11-27T15:11:04.638Z
8518464 8518464 20251118141954_dEtAC AU0041 2025-11-20T14:03:36.735Z 2025-11-27T15:11:03.932Z
8518458 8518458 20251118141729_LAkua AU0041 2025-11-20T14:03:35.445Z 2025-11-27T15:11:03.868Z
8518439 8518439 20251118141217_eff0v AU0041 2025-11-20T14:03:32.494Z 2025-11-27T15:11:03.670Z
8503237 8503237 20251117165837_58SSn AU0041 2025-11-19T14:04:55.827Z 2025-11-26T15:06:24.600Z
8503087 8503087 20251117163414_DiYZO AU0041 2025-11-19T14:04:30.238Z 2025-11-26T15:06:19.174Z
8502986 8502986 20251117161658_s7TFL AU0041 2025-11-19T14:04:15.923Z 2025-11-26T15:06:18.185Z
8502943 8502943 20251117161104_chc2A AU0041 2025-11-19T14:04:10.072Z 2025-11-26T15:06:17.798Z
8502909 8502909 20251117160407_yPUcI AU0041 2025-11-19T14:04:04.940Z 2025-11-26T15:06:17.566Z
8502717 8502717 20251117153343_wjSoO AU0041 2025-11-19T14:03:29.617Z 2025-11-26T15:06:13.652Z
8502463 8502463 20251117143715_m1lC6 AU0041 2025-11-19T14:02:41.368Z 2025-11-26T15:06:10.723Z
8502354 8502354 20251117141530_oGxDR AU0041 2025-11-19T14:02:16.116Z 2025-11-26T15:06:09.543Z
8502156 8502156 20251117124929_H7ec1 AU0041 2025-11-19T14:01:38.396Z 2025-11-26T15:06:05.470Z
8501980 8501980 20251117121917_xNTL9 AU0041 2025-11-19T14:01:08.791Z 2025-11-26T15:06:02.288Z
8501895 8501895 20251117115829_Y2IBG AU0041 2025-11-19T14:00:52.135Z 2025-11-26T15:06:01.306Z
8498749 8498749 20251116174819_lYkVw AU0041 2025-11-18T14:31:22.906Z 2025-11-25T15:07:45.418Z
8498741 8498741 20251116171526_dlDsd AU0041 2025-11-18T14:31:17.153Z 2025-11-25T15:07:34.784Z
8498725 8498725 20251116160403_83e8q AU0041 2025-11-18T14:31:10.505Z 2025-11-25T15:07:24.283Z
8498717 8498717 20251116153110_XGaLq AU0041 2025-11-18T14:31:07.227Z 2025-11-25T15:07:08.386Z
8498709 8498709 20251116152657_xDFyS AU0041 2025-11-18T14:31:03.003Z 2025-11-25T15:07:05.165Z
8498684 8498684 20251116125156_eYlaL AU0041 2025-11-18T14:30:54.326Z 2025-11-25T15:06:13.885Z
8498679 8498679 20251116123431_gmqlf AU0041 2025-11-18T14:30:53.772Z 2025-11-25T15:06:10.070Z
8472535 8472535 20251114114523_1OEFn AU0041 2025-11-16T14:33:58.042Z 2025-11-22T15:24:23.254Z
8472468 8472468 20251114113531_tw5uZ AU0041 2025-11-16T14:33:53.394Z 2025-11-22T15:24:19.422Z
8466158 8466158 20251114180201_yQ8bM AU0041 2025-11-16T14:11:13.443Z 2025-11-23T15:17:01.046Z
8466112 8466112 20251114175153_QINcj AU0041 2025-11-16T14:11:07.666Z 2025-11-23T15:17:00.696Z
8465637 8465637 20251114165524_FXpy1 AU0041 2025-11-16T14:09:47.818Z 2025-11-23T15:16:57.446Z
8465276 8465276 20251114161310_7SilY AU0041 2025-11-16T14:08:47.669Z 2025-11-23T15:16:51.679Z
8464971 8464971 20251114153545_LaSoz AU0041 2025-11-16T14:07:51.214Z 2025-11-23T15:16:33.769Z
8464205 8464205 20251114142658_dh2tJ AU0041 2025-11-16T14:05:31.144Z 2025-11-23T15:16:12.853Z
8463758 8463758 20251114133958_vtDMB AU0041 2025-11-16T14:04:14.716Z 2025-11-23T15:16:03.940Z
8463615 8463615 20251114132646_on1K6 AU0041 2025-11-16T14:03:48.858Z 2025-11-23T15:16:00.371Z
8463313 8463313 20251114125600_LzE8K AU0041 2025-11-16T14:02:49.333Z 2025-11-23T15:15:49.736Z
8446502 8446502 20251112173817_wVAhl AU0041 2025-11-14T14:11:06.719Z 2025-11-21T15:11:11.192Z
8446409 8446409 20251112172715_ayPpZ AU0041 2025-11-14T14:10:42.930Z 2025-11-21T15:11:10.039Z
8446222 8446222 20251112170336_YlD3z AU0041 2025-11-14T14:09:57.813Z 2025-11-21T15:11:08.286Z
8446019 8446019 20251112163758_K8bZc AU0041 2025-11-14T14:09:17.351Z 2025-11-21T15:11:06.586Z
8445335 8445335 20251112152012_wun1S AU0041 2025-11-14T14:07:17.264Z 2025-11-21T15:10:46.124Z
8445328 8445328 20251112151946_P2K5D AU0041 2025-11-14T14:07:15.678Z 2025-11-21T15:10:44.755Z
8445086 8445086 20251112144329_ehi2k AU0041 2025-11-14T14:06:24.136Z 2025-11-21T15:10:36.982Z
8444892 8444892 20251112140749_COWPi AU0041 2025-11-14T14:05:35.238Z 2025-11-21T15:10:33.535Z
8444765 8444765 20251112134416_z4P1V AU0041 2025-11-14T14:05:21.264Z 2025-11-21T15:10:29.225Z
8444734 8444734 20251112133844_oKawU AU0041 2025-11-14T14:05:15.406Z 2025-11-21T15:10:28.708Z
8443431 8443431 20251111120730_bEvCY AU0041 2025-11-13T14:50:49.099Z 2025-11-19T15:19:21.519Z
8443117 8443117 20251111112056_1RQTB AU0041 2025-11-13T14:50:31.350Z 2025-11-19T15:19:02.214Z
8443071 8443071 20251111110721_GLDMB AU0041 2025-11-13T14:50:07.373Z 2025-11-19T15:18:57.696Z
8442105 8442105 20251112111943_WXo9v AU0041 2025-11-13T14:39:57.453Z 2025-11-20T15:26:18.244Z
8434146 8434146 20251111175208_Q3tHV AU0041 2025-11-13T14:12:11.872Z 2025-11-20T15:21:26.531Z
8434047 8434047 20251111174614_bO7MR AU0041 2025-11-13T14:11:48.582Z 2025-11-20T15:21:21.517Z
8433370 8433370 20251111165318_VaxtT AU0041 2025-11-13T14:10:00.997Z 2025-11-20T15:20:43.965Z

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