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,966 rows where station_code = "AU0028" 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
9271800 9271800 20260127201546_Rn4Yr AU0028 2026-01-29T14:23:53.917Z 2026-01-29T14:30:25.148Z
9271798 9271798 20260127201453_jrObD AU0028 2026-01-29T14:23:53.389Z 2026-01-29T14:30:25.147Z
9271773 9271773 20260127195859_f2hV2 AU0028 2026-01-29T14:23:25.454Z 2026-01-29T14:30:25.131Z
9271663 9271663 20260127190350_XmEiD AU0028 2026-01-29T14:22:12.733Z 2026-01-29T14:30:25.005Z
9271609 9271609 20260127183300_Dsn0E AU0028 2026-01-29T14:21:46.057Z 2026-01-29T14:30:24.968Z
9271552 9271552 20260127175341_9ly1h AU0028 2026-01-29T14:21:18.717Z 2026-01-29T14:30:24.905Z
9271502 9271502 20260127171553_6nBBt AU0028 2026-01-29T14:20:58.630Z 2026-01-29T14:30:24.851Z
9271500 9271500 20260127171423_bOL6w AU0028 2026-01-29T14:20:58.206Z 2026-01-29T14:30:24.851Z
9271484 9271484 20260127170122_EmZjU AU0028 2026-01-29T14:20:50.909Z 2026-01-29T14:30:24.840Z
9271418 9271418 20260127152140_v4RCk AU0028 2026-01-29T14:19:51.372Z 2026-01-29T14:30:24.592Z
9271365 9271365 20260127135552_uXOiV AU0028 2026-01-29T14:18:53.388Z 2026-01-29T14:30:24.415Z
9263297 9263297 20260124164714_zCcai AU0028 2026-01-27T14:20:45.455Z 2026-01-29T14:42:01.592Z
9254235 9254235 20260123171244_l2ll8 AU0028 2026-01-25T14:08:01.369Z 2026-01-29T14:46:00.020Z
9254115 9254115 20260123154435_kYdBn AU0028 2026-01-25T14:07:13.414Z 2026-01-29T14:45:42.575Z
9247583 9247583 20260121190627_ba5bW AU0028 2026-01-23T14:10:31.190Z 2026-01-29T14:56:15.569Z
9247125 9247125 20260121170958_kMkOA AU0028 2026-01-23T14:09:05.452Z 2026-01-29T14:55:43.792Z
9247087 9247087 20260121165252_uYj00 AU0028 2026-01-23T14:09:00.409Z 2026-01-29T14:55:42.035Z
9247075 9247075 20260121164908_c1uHu AU0028 2026-01-23T14:08:58.787Z 2026-01-29T14:55:41.515Z
9246826 9246826 20260121145237_5Ge0h AU0028 2026-01-23T14:08:04.064Z 2026-01-29T14:55:13.629Z
9246724 9246724 20260121135943_erDEg AU0028 2026-01-23T14:07:43.345Z 2026-01-29T14:55:07.478Z
9241313 9241313 20260120195728_LvGe8 AU0028 2026-01-22T14:12:40.561Z 2026-01-29T15:02:31.540Z
9241123 9241123 20260120190830_Yn7fW AU0028 2026-01-22T14:11:42.350Z 2026-01-29T15:02:23.152Z
9240946 9240946 20260120183414_0Y90V AU0028 2026-01-22T14:11:00.099Z 2026-01-29T15:02:04.038Z
9240772 9240772 20260120174503_Wwyg8 AU0028 2026-01-22T14:09:54.408Z 2026-01-29T15:01:53.996Z
9240365 9240365 20260120153234_VjSEV AU0028 2026-01-22T14:08:01.139Z 2026-01-29T15:01:19.604Z
9240296 9240296 20260120145949_My5mp AU0028 2026-01-22T14:07:37.537Z 2026-01-29T15:01:03.038Z
9240120 9240120 20260120123047_L2WoS AU0028 2026-01-22T14:05:52.342Z 2026-01-29T15:00:15.355Z
9234221 9234221 20260119200904_BIFUO AU0028 2026-01-21T14:13:03.729Z 2026-01-28T14:57:22.616Z
9234140 9234140 20260119194626_0FZRu AU0028 2026-01-21T14:12:31.354Z 2026-01-28T14:57:17.080Z
9233895 9233895 20260119183239_S8J6a AU0028 2026-01-21T14:11:14.228Z 2026-01-28T14:56:50.682Z
9233584 9233584 20260119145603_oyGfy AU0028 2026-01-21T14:08:42.505Z 2026-01-28T14:55:55.257Z
9227836 9227836 20260118181235_RhddH AU0028 2026-01-20T14:14:21.993Z 2026-01-27T15:00:57.590Z
9227761 9227761 20260118173445_jtxUA AU0028 2026-01-20T14:13:53.394Z 2026-01-27T15:00:51.803Z
9227705 9227705 20260118164130_Htdun AU0028 2026-01-20T14:13:18.782Z 2026-01-27T15:00:38.271Z
9227614 9227614 20260118141833_wmCzN AU0028 2026-01-20T14:11:28.120Z 2026-01-27T14:59:34.865Z
9225924 9225924 20260115164344_U2fTV AU0028 2026-01-19T14:38:58.593Z 2026-01-24T15:09:37.721Z
9222155 9222155 20260117183226_93wDl AU0028 2026-01-19T14:13:31.639Z 2026-01-26T15:00:41.956Z
9221930 9221930 20260117171824_fhrwx AU0028 2026-01-19T14:12:29.283Z 2026-01-26T15:00:31.099Z
9221873 9221873 20260117170421_acPfZ AU0028 2026-01-19T14:12:18.292Z 2026-01-26T15:00:28.207Z
9221867 9221867 20260117170108_yQ8sq AU0028 2026-01-19T14:12:16.209Z 2026-01-26T15:00:19.244Z
9221738 9221738 20260117152418_RGagq AU0028 2026-01-19T14:11:16.405Z 2026-01-26T15:00:01.020Z
9221707 9221707 20260117140408_OxMLc AU0028 2026-01-19T14:10:31.750Z 2026-01-26T14:59:52.355Z
9212179 9212179 20260115194623_Lgz8o AU0028 2026-01-17T14:10:26.148Z 2026-01-24T15:10:30.683Z
9212107 9212107 20260115191357_xBmLq AU0028 2026-01-17T14:09:57.812Z 2026-01-24T15:10:24.212Z
9212035 9212035 20260115185140_aFnsg AU0028 2026-01-17T14:09:35.757Z 2026-01-24T15:10:20.385Z
9211674 9211674 20260115171415_2x3hr AU0028 2026-01-17T14:07:51.058Z 2026-01-24T15:09:45.242Z
9211553 9211553 20260115163019_yOCFM AU0028 2026-01-17T14:07:13.430Z 2026-01-24T15:09:32.109Z
9206975 9206975 20260114200814_6xt1R AU0028 2026-01-16T14:06:27.677Z 2026-01-22T15:02:45.204Z
9206946 9206946 20260114195547_778Y4 AU0028 2026-01-16T14:06:18.734Z 2026-01-22T15:02:44.156Z
9206859 9206859 20260114192023_WMd4K AU0028 2026-01-16T14:05:55.116Z 2026-01-22T15:02:41.193Z
9206836 9206836 20260114191357_9YwGL AU0028 2026-01-16T14:05:47.476Z 2026-01-22T15:02:38.110Z
9206720 9206720 20260114183554_6KmK9 AU0028 2026-01-16T14:05:16.560Z 2026-01-22T15:02:34.519Z
9206584 9206584 20260114174657_0Nii2 AU0028 2026-01-16T14:04:35.381Z 2026-01-22T15:02:30.690Z
9206559 9206559 20260114174324_XYUsI AU0028 2026-01-16T14:04:27.843Z 2026-01-22T15:02:29.859Z
9206336 9206336 20260114160607_d1CA3 AU0028 2026-01-16T14:03:24.386Z 2026-01-22T15:02:09.097Z
9198835 9198835 20260113181430_6D3UY AU0028 2026-01-15T14:07:34.017Z 2026-01-22T15:07:06.087Z
9198726 9198726 20260113174440_qxICl AU0028 2026-01-15T14:06:45.452Z 2026-01-22T15:07:02.051Z
9198327 9198327 20260113153916_AOyrU AU0028 2026-01-15T14:03:18.065Z 2026-01-22T15:06:22.764Z
9194155 9194155 20260112182736_bNCSF AU0028 2026-01-14T14:07:39.151Z 2026-01-21T15:03:36.102Z
9194153 9194153 20260112182727_cxTFS AU0028 2026-01-14T14:07:38.344Z 2026-01-21T15:03:36.025Z
9193242 9193242 20260112125301_B2VaK AU0028 2026-01-13T14:30:59.610Z 2026-01-20T15:26:29.277Z
9187793 9187793 20260111185227_42A32 AU0028 2026-01-13T14:08:58.300Z 2026-01-20T15:20:55.227Z
9186981 9186981 20260111143457_8On5Q AU0028 2026-01-13T14:04:41.406Z 2026-01-20T15:19:39.961Z
9185967 9185967 20260111140246_pT149 AU0028 2026-01-12T14:26:24.979Z 2026-01-19T15:22:13.422Z
9185702 9185702 20260111124056_X2d46 AU0028 2026-01-12T14:25:42.943Z 2026-01-19T15:21:36.282Z
9180316 9180316 20260110195634_NHe43 AU0028 2026-01-12T14:06:40.187Z 2026-01-19T15:15:56.113Z
9180202 9180202 20260110193607_u1O8W AU0028 2026-01-12T14:06:12.698Z 2026-01-19T15:15:51.228Z
9180166 9180166 20260110192559_dLAjF AU0028 2026-01-12T14:06:02.405Z 2026-01-19T15:15:49.518Z
9180020 9180020 20260110184659_Z2ry2 AU0028 2026-01-12T14:05:25.812Z 2026-01-19T15:15:41.936Z
9179977 9179977 20260110182946_tXLVT AU0028 2026-01-12T14:05:12.416Z 2026-01-19T15:15:39.251Z
9179956 9179956 20260110182459_OvwqQ AU0028 2026-01-12T14:05:07.396Z 2026-01-19T15:15:38.279Z
9179799 9179799 20260110174452_2hkL3 AU0028 2026-01-12T14:04:22.367Z 2026-01-19T15:15:16.582Z
9179674 9179674 20260110171642_lDxJr AU0028 2026-01-12T14:03:49.556Z 2026-01-19T15:15:10.576Z
9179629 9179629 20260110170615_JxWxZ AU0028 2026-01-12T14:03:38.284Z 2026-01-19T15:15:08.628Z
9179450 9179450 20260110154618_2XXyB AU0028 2026-01-12T14:02:28.462Z 2026-01-19T15:14:39.486Z
9179006 9179006 20260110124707_5QGnS AU0028 2026-01-11T14:16:17.763Z 2026-01-18T15:10:44.191Z
9170688 9170688 20260108161801_xEuJZ AU0028 2026-01-10T14:02:51.849Z 2026-01-17T15:22:54.554Z
9166455 9166455 20260107183637_dRzwT AU0028 2026-01-09T14:03:19.364Z 2026-01-16T15:09:55.873Z
9166406 9166406 20260107181637_3E11M AU0028 2026-01-09T14:03:04.308Z 2026-01-16T15:09:52.439Z
9165759 9165759 20260107154946_dm6BQ AU0028 2026-01-08T14:18:09.303Z 2026-01-13T15:05:56.629Z
9165672 9165672 20260107143442_mz3CC AU0028 2026-01-08T14:17:35.640Z 2026-01-13T15:05:09.381Z
9165668 9165668 20260107143202_ywkue AU0028 2026-01-08T14:17:34.644Z 2026-01-13T15:05:08.271Z
9165634 9165634 20260107133608_BTbp3 AU0028 2026-01-08T14:17:27.098Z 2026-01-13T15:04:49.900Z
9161631 9161631 20260106150243_LJv4p AU0028 2026-01-07T14:17:28.897Z 2026-01-13T15:11:08.958Z
9161598 9161598 20260106144023_XbDCd AU0028 2026-01-07T14:17:18.191Z 2026-01-13T15:10:59.144Z
9161564 9161564 20260106142715_g4bJN AU0028 2026-01-07T14:17:07.671Z 2026-01-13T15:10:56.750Z
9157292 9157292 20260106164517_qnY9K AU0028 2026-01-07T14:00:21.552Z 2026-01-13T15:01:04.340Z
9156691 9156691 20260104124552_h25eL AU0028 2026-01-06T14:40:29.567Z 2026-01-12T15:12:24.261Z
9133663 9133663 20260103142611_79WCz AU0028 2026-01-04T14:22:02.218Z 2026-01-10T15:03:23.585Z
9133481 9133481 20260103131134_GDVgH AU0028 2026-01-04T14:21:01.813Z 2026-01-10T15:02:59.620Z
9126097 9126097 20251230191228_uqVvO AU0028 2026-01-02T15:08:55.594Z 2026-01-07T15:13:22.947Z
9126093 9126093 20251230191001_2Zwxq AU0028 2026-01-02T15:08:48.963Z 2026-01-07T15:13:22.322Z
9126085 9126085 20251230190216_lC2qw AU0028 2026-01-02T15:08:42.365Z 2026-01-07T15:13:19.397Z
9126066 9126066 20251230184635_Zp5Mm AU0028 2026-01-02T15:08:23.572Z 2026-01-07T15:13:13.134Z
9126062 9126062 20251230184448_yhU1k AU0028 2026-01-02T15:08:16.705Z 2026-01-07T15:13:12.377Z
9126054 9126054 20251230184021_kmOnj AU0028 2026-01-02T15:08:07.758Z 2026-01-07T15:13:01.244Z
9126031 9126031 20251230182304_svBaq AU0028 2026-01-02T15:07:53.077Z 2026-01-07T15:12:53.969Z
9125957 9125957 20251230172250_cF5V5 AU0028 2026-01-02T15:06:29.637Z 2026-01-07T15:12:19.933Z
9125956 9125956 20251230172051_ZC2qW AU0028 2026-01-02T15:06:19.101Z 2026-01-07T15:12:19.456Z
9125950 9125950 20251230171445_L7Vam AU0028 2026-01-02T15:06:15.938Z 2026-01-07T15:12:17.952Z

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