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

5,267 rows where station_code = "AU0046" 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
9254451 9254451 20260123192349_mEm3a AU0046 2026-01-25T14:09:11.842Z 2026-01-29T14:46:24.371Z
9254371 9254371 20260123184108_kOFKd AU0046 2026-01-25T14:08:49.005Z 2026-01-29T14:46:12.303Z
9254324 9254324 20260123181824_JfDM5 AU0046 2026-01-25T14:08:30.985Z 2026-01-29T14:46:06.973Z
9254289 9254289 20260123175325_2bpjn AU0046 2026-01-25T14:08:18.847Z 2026-01-29T14:46:03.994Z
9254193 9254193 20260123164236_eOPjF AU0046 2026-01-25T14:07:44.498Z 2026-01-29T14:45:56.950Z
9254189 9254189 20260123164229_9A3qx AU0046 2026-01-25T14:07:43.235Z 2026-01-29T14:45:56.733Z
9254160 9254160 20260123162432_58lYG AU0046 2026-01-25T14:07:32.536Z 2026-01-29T14:45:54.671Z
9254092 9254092 20260123151109_NhiWI AU0046 2026-01-25T14:07:01.201Z 2026-01-29T14:45:36.213Z
9254009 9254009 20260123124818_Gykld AU0046 2026-01-25T14:06:17.338Z 2026-01-29T14:45:15.534Z
9254007 9254007 20260123124148_0G31V AU0046 2026-01-25T14:06:15.817Z 2026-01-29T14:45:14.939Z
9254001 9254001 20260123122503_UWx2f AU0046 2026-01-25T14:06:11.175Z 2026-01-29T14:45:13.369Z
9247879 9247879 20260121202120_WL8oh AU0046 2026-01-23T14:11:20.591Z 2026-01-29T14:56:41.841Z
9247851 9247851 20260121200755_3DTHH AU0046 2026-01-23T14:11:15.676Z 2026-01-29T14:56:40.557Z
9247754 9247754 20260121194410_Mb3KE AU0046 2026-01-23T14:11:03.343Z 2026-01-29T14:56:35.879Z
9247727 9247727 20260121193533_CK8ae AU0046 2026-01-23T14:10:59.446Z 2026-01-29T14:56:34.160Z
9247724 9247724 20260121193514_keyE0 AU0046 2026-01-23T14:10:59.063Z 2026-01-29T14:56:33.435Z
9247639 9247639 20260121192154_gZZwQ AU0046 2026-01-23T14:10:38.970Z 2026-01-29T14:56:21.218Z
9247614 9247614 20260121191537_EmDq6 AU0046 2026-01-23T14:10:35.774Z 2026-01-29T14:56:19.610Z
9247609 9247609 20260121191421_4iTKi AU0046 2026-01-23T14:10:35.087Z 2026-01-29T14:56:17.372Z
9247602 9247602 20260121191305_JbZAi AU0046 2026-01-23T14:10:33.768Z 2026-01-29T14:56:16.826Z
9247551 9247551 20260121185812_Ea0vp AU0046 2026-01-23T14:10:26.637Z 2026-01-29T14:56:13.945Z
9247548 9247548 20260121185812_8kB1C AU0046 2026-01-23T14:10:26.416Z 2026-01-29T14:56:13.857Z
9247097 9247097 20260121165829_3n3Cu AU0046 2026-01-23T14:09:01.819Z 2026-01-29T14:55:42.521Z
9247057 9247057 20260121163302_msntM AU0046 2026-01-23T14:08:55.789Z 2026-01-29T14:55:40.393Z
9247001 9247001 20260121161140_cMjXV AU0046 2026-01-23T14:08:44.192Z 2026-01-29T14:55:37.408Z
9246891 9246891 20260121152441_11rSp AU0046 2026-01-23T14:08:17.864Z 2026-01-29T14:55:18.650Z
9246849 9246849 20260121150331_gE6kn AU0046 2026-01-23T14:08:07.423Z 2026-01-29T14:55:14.562Z
9246847 9246847 20260121150306_H2Z4e AU0046 2026-01-23T14:08:07.051Z 2026-01-29T14:55:14.436Z
9246810 9246810 20260121144626_4mm5Z AU0046 2026-01-23T14:08:01.471Z 2026-01-29T14:55:12.779Z
9246784 9246784 20260121142852_W2T66 AU0046 2026-01-23T14:07:57.258Z 2026-01-29T14:55:11.197Z
9246702 9246702 20260121135054_VjzQG AU0046 2026-01-23T14:07:37.643Z 2026-01-29T14:55:05.963Z
9246662 9246662 20260121132010_jS7Cm AU0046 2026-01-23T14:07:31.706Z 2026-01-29T14:55:03.535Z
9246658 9246658 20260121131702_AMqsF AU0046 2026-01-23T14:07:30.874Z 2026-01-29T14:55:03.283Z
9246639 9246639 20260121130940_FUQ2O AU0046 2026-01-23T14:07:27.659Z 2026-01-29T14:55:01.803Z
9246577 9246577 20260121123418_VidjN AU0046 2026-01-23T14:07:07.480Z 2026-01-29T14:54:42.815Z
9241424 9241424 20260120202605_o6C9J AU0046 2026-01-22T14:13:04.203Z 2026-01-29T15:02:36.016Z
9241360 9241360 20260120201018_Dev0u AU0046 2026-01-22T14:12:49.153Z 2026-01-29T15:02:33.595Z
9241349 9241349 20260120200441_fN93U AU0046 2026-01-22T14:12:46.411Z 2026-01-29T15:02:32.945Z
9241317 9241317 20260120195728_LvGe8 AU0046 2026-01-22T14:12:40.561Z 2026-01-29T15:02:31.540Z
9241148 9241148 20260120191255_vt0Kw AU0046 2026-01-22T14:11:48.710Z 2026-01-29T15:02:23.939Z
9241043 9241043 20260120185411_RSyzp AU0046 2026-01-22T14:11:27.828Z 2026-01-29T15:02:10.380Z
9241036 9241036 20260120185313_7n4Ix AU0046 2026-01-22T14:11:26.611Z 2026-01-29T15:02:10.189Z
9240961 9240961 20260120183656_5bkgj AU0046 2026-01-22T14:11:03.018Z 2026-01-29T15:02:04.811Z
9240913 9240913 20260120182554_RJXXg AU0046 2026-01-22T14:10:50.783Z 2026-01-29T15:02:02.289Z
9240639 9240639 20260120171111_j50UH AU0046 2026-01-22T14:09:17.844Z 2026-01-29T15:01:36.348Z
9240522 9240522 20260120163550_L7Q4T AU0046 2026-01-22T14:08:43.423Z 2026-01-29T15:01:29.324Z
9240417 9240417 20260120155503_BnOkF AU0046 2026-01-22T14:08:17.065Z 2026-01-29T15:01:22.557Z
9240413 9240413 20260120155503_dCuoX AU0046 2026-01-22T14:08:16.616Z 2026-01-29T15:01:22.460Z
9240380 9240380 20260120154244_Pow1z AU0046 2026-01-22T14:08:05.524Z 2026-01-29T15:01:20.834Z
9240196 9240196 20260120131539_VvlhB AU0046 2026-01-22T14:06:37.220Z 2026-01-29T15:00:43.262Z
9240180 9240180 20260120130421_3FX6o AU0046 2026-01-22T14:06:30.614Z 2026-01-29T15:00:34.740Z
9240123 9240123 20260120123047_L2WoS AU0046 2026-01-22T14:05:52.354Z 2026-01-29T15:00:15.355Z
9240114 9240114 20260120122240_8vbRq AU0046 2026-01-22T14:05:46.899Z 2026-01-29T15:00:03.211Z
9233945 9233945 20260119185250_fTXb5 AU0046 2026-01-21T14:11:29.498Z 2026-01-28T14:56:54.677Z
9233893 9233893 20260119183127_2eqJM AU0046 2026-01-21T14:11:13.627Z 2026-01-28T14:56:50.553Z
9233778 9233778 20260119174929_Dzk2Y AU0046 2026-01-21T14:10:27.738Z 2026-01-28T14:56:32.326Z
9233603 9233603 20260119151049_FTn2g AU0046 2026-01-21T14:08:49.224Z 2026-01-28T14:55:58.913Z
9233551 9233551 20260119134224_F9O1C AU0046 2026-01-21T14:08:04.665Z 2026-01-28T14:55:44.686Z
9228160 9228160 20260118201034_dk83p AU0046 2026-01-20T14:16:21.357Z 2026-01-27T15:01:30.365Z
9228121 9228121 20260118195851_qyiCT AU0046 2026-01-20T14:16:07.902Z 2026-01-27T15:01:27.688Z
9228119 9228119 20260118195850_9Z5dG AU0046 2026-01-20T14:16:07.365Z 2026-01-27T15:01:27.409Z
9227998 9227998 20260118190505_YcEeX AU0046 2026-01-20T14:15:22.619Z 2026-01-27T15:01:10.249Z
9227834 9227834 20260118181157_WpqgJ AU0046 2026-01-20T14:14:21.503Z 2026-01-27T15:00:57.443Z
9227754 9227754 20260118172709_O0lYc AU0046 2026-01-20T14:13:48.408Z 2026-01-27T15:00:50.919Z
9227716 9227716 20260118164920_Hv2tH AU0046 2026-01-20T14:13:23.025Z 2026-01-27T15:00:39.102Z
9227671 9227671 20260118161023_ZKe5A AU0046 2026-01-20T14:12:59.610Z 2026-01-27T15:00:33.076Z
9227623 9227623 20260118143025_MEW30 AU0046 2026-01-20T14:11:37.836Z 2026-01-27T14:59:48.266Z
9227587 9227587 20260118123059_byzra AU0046 2026-01-20T14:10:16.254Z 2026-01-27T14:59:00.498Z
9227529 9227529 20260119202659_08G4A AU0046 2026-01-20T14:08:52.482Z 2026-01-28T14:57:25.309Z
9227519 9227519 20260119201220_0D2qG AU0046 2026-01-20T14:08:49.318Z 2026-01-28T14:57:23.252Z
9227511 9227511 20260119200828_O2Rxv AU0046 2026-01-20T14:08:47.021Z 2026-01-28T14:57:22.059Z
9227490 9227490 20260119194041_tI81q AU0046 2026-01-20T14:08:35.787Z 2026-01-28T14:57:06.135Z
9227484 9227484 20260119192610_11Ww9 AU0046 2026-01-20T14:08:33.740Z 2026-01-20T14:08:33.740Z
9227479 9227479 20260119190121_83b78 AU0046 2026-01-20T14:08:32.094Z 2026-01-28T14:56:55.952Z
9227477 9227477 20260119185238_xEPc1 AU0046 2026-01-20T14:08:31.557Z 2026-01-28T14:56:54.577Z
9227475 9227475 20260119184237_63exi AU0046 2026-01-20T14:08:30.999Z 2026-01-28T14:56:52.077Z
9227471 9227471 20260119183842_LyWNv AU0046 2026-01-20T14:08:30.382Z 2026-01-28T14:56:51.453Z
9227469 9227469 20260119183126_2N3Iw AU0046 2026-01-20T14:08:29.729Z 2026-01-28T14:56:50.320Z
9227465 9227465 20260119181701_nBHoT AU0046 2026-01-20T14:08:28.450Z 2026-01-28T14:56:46.412Z
9227461 9227461 20260119180307_zI7G2 AU0046 2026-01-20T14:08:27.299Z 2026-01-20T14:08:27.299Z
9227459 9227459 20260119175939_bmxpz AU0046 2026-01-20T14:08:26.172Z 2026-01-28T14:56:42.038Z
9227450 9227450 20260119174929_8yXo8 AU0046 2026-01-20T14:08:23.150Z 2026-01-20T14:08:23.150Z
9227430 9227430 20260119172504_cjdp2 AU0046 2026-01-20T14:08:17.814Z 2026-01-28T14:56:26.561Z
9227317 9227317 20260119153848_BrgkK AU0046 2026-01-20T14:07:40.441Z 2026-01-28T14:56:14.050Z
9227179 9227179 20260119145748_uhM2X AU0046 2026-01-20T14:07:00.716Z 2026-01-20T14:07:00.716Z
9226885 9226885 20260119132620_NpFcL AU0046 2026-01-20T14:05:32.458Z 2026-01-28T14:55:33.777Z
9225976 9225976 20260115190557_3tsuV AU0046 2026-01-19T14:39:58.999Z 2026-01-24T15:10:22.596Z
9225939 9225939 20260115173515_Ff45n AU0046 2026-01-19T14:39:19.445Z 2026-01-24T15:09:52.872Z
9222581 9222581 20260117200107_yhTMd AU0046 2026-01-19T14:15:22.935Z 2026-01-26T15:01:14.099Z
9222437 9222437 20260117193348_kfUHE AU0046 2026-01-19T14:14:46.061Z 2026-01-26T15:00:53.802Z
9222389 9222389 20260117192332_sNDiP AU0046 2026-01-19T14:14:36.354Z 2026-01-26T15:00:52.007Z
9222293 9222293 20260117190023_w5LtD AU0046 2026-01-19T14:14:06.368Z 2026-01-26T15:00:46.795Z
9222248 9222248 20260117184724_qSGe7 AU0046 2026-01-19T14:13:55.950Z 2026-01-26T15:00:45.176Z
9222206 9222206 20260117184300_XgugT AU0046 2026-01-19T14:13:48.126Z 2026-01-26T15:00:43.923Z
9222182 9222182 20260117183901_2GTUb AU0046 2026-01-19T14:13:39.812Z 2026-01-26T15:00:43.059Z
9222163 9222163 20260117183335_dO0vN AU0046 2026-01-19T14:13:32.913Z 2026-01-26T15:00:42.172Z
9222027 9222027 20260117174650_iRMJQ AU0046 2026-01-19T14:12:55.709Z 2026-01-26T15:00:34.721Z
9222025 9222025 20260117174614_zEfJx AU0046 2026-01-19T14:12:55.160Z 2026-01-26T15:00:34.650Z
9221992 9221992 20260117174013_T62Z4 AU0046 2026-01-19T14:12:48.843Z 2026-01-26T15:00:33.760Z
9221968 9221968 20260117173001_i9xBY AU0046 2026-01-19T14:12:38.836Z 2026-01-26T15:00:33.042Z

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