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

>10,000 rows count all where station_code = "AU001B" 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
9271777 9271777 20260127200407_pqAKe AU001B 2026-01-29T14:23:28.664Z 2026-01-29T14:30:25.135Z
9271759 9271759 20260127195134_SmC3w AU001B 2026-01-29T14:23:18.787Z 2026-01-29T14:30:25.101Z
9271734 9271734 20260127194554_N0rzy AU001B 2026-01-29T14:23:11.140Z 2026-01-29T14:30:25.083Z
9271717 9271717 20260127193106_ic3Nf AU001B 2026-01-29T14:22:47.602Z 2026-01-29T14:30:25.047Z
9271659 9271659 20260127190143_1SKk9 AU001B 2026-01-29T14:22:11.666Z 2026-01-29T14:30:25.003Z
9271574 9271574 20260127180547_10n2u AU001B 2026-01-29T14:21:34.655Z 2026-01-29T14:30:24.925Z
9271566 9271566 20260127180113_fxemn AU001B 2026-01-29T14:21:27.091Z 2026-01-29T14:30:24.922Z
9271553 9271553 20260127175629_M0knC AU001B 2026-01-29T14:21:19.909Z 2026-01-29T14:30:24.907Z
9271466 9271466 20260127163358_8EZtK AU001B 2026-01-29T14:20:42.742Z 2026-01-29T14:30:24.812Z
9271415 9271415 20260127151926_QX9tI AU001B 2026-01-29T14:19:49.436Z 2026-01-29T14:30:24.587Z
9271412 9271412 20260127151808_JXQlp AU001B 2026-01-29T14:19:47.512Z 2026-01-29T14:30:24.554Z
9267117 9267117 20260126192515_UQ5Bg AU001B 2026-01-28T14:19:21.344Z 2026-01-29T14:34:19.536Z
9267113 9267113 20260126192059_Dv0ge AU001B 2026-01-28T14:19:19.555Z 2026-01-29T14:34:18.917Z
9267101 9267101 20260126185628_02sy8 AU001B 2026-01-28T14:19:13.003Z 2026-01-29T14:34:17.050Z
9267085 9267085 20260126184820_Zxh8N AU001B 2026-01-28T14:19:05.953Z 2026-01-29T14:34:15.251Z
9267063 9267063 20260126183658_JscNk AU001B 2026-01-28T14:18:48.376Z 2026-01-29T14:34:11.442Z
9267043 9267043 20260126182415_bC7lX AU001B 2026-01-28T14:18:37.581Z 2026-01-29T14:34:01.419Z
9267033 9267033 20260126181421_H1NXb AU001B 2026-01-28T14:18:31.771Z 2026-01-29T14:33:59.888Z
9266983 9266983 20260126173446_kx3va AU001B 2026-01-28T14:18:07.393Z 2026-01-29T14:33:52.184Z
9266979 9266979 20260126173117_n6TJi AU001B 2026-01-28T14:18:05.875Z 2026-01-29T14:33:51.856Z
9266974 9266974 20260126172801_4L2a6 AU001B 2026-01-28T14:18:04.396Z 2026-01-29T14:33:51.477Z
9266970 9266970 20260126172539_2G2F3 AU001B 2026-01-28T14:18:03.300Z 2026-01-29T14:33:50.912Z
9266940 9266940 20260126165840_FKJz2 AU001B 2026-01-28T14:17:45.574Z 2026-01-29T14:33:46.405Z
9266932 9266932 20260126164856_kB8jw AU001B 2026-01-28T14:17:43.700Z 2026-01-29T14:33:45.837Z
9266881 9266881 20260126153941_NAgvk AU001B 2026-01-28T14:17:12.764Z 2026-01-29T14:33:31.205Z
9266847 9266847 20260126141201_RY1oA AU001B 2026-01-28T14:16:36.255Z 2026-01-29T14:33:12.210Z
9262568 9262568 20260125201431_TSwak AU001B 2026-01-27T14:13:37.542Z 2026-01-29T14:38:14.738Z
9258761 9258761 20260124164833_2At5T AU001B 2026-01-26T14:14:16.457Z 2026-01-29T14:42:06.711Z
9258690 9258690 20260124160537_q0IXk AU001B 2026-01-26T14:13:54.755Z 2026-01-29T14:41:52.304Z
9258589 9258589 20260124145324_ThLJ8 AU001B 2026-01-26T14:13:08.617Z 2026-01-29T14:41:32.536Z
9254498 9254498 20260123194853_qStki AU001B 2026-01-25T14:09:30.001Z 2026-01-29T14:46:26.775Z
9254375 9254375 20260123184231_kcS8v AU001B 2026-01-25T14:08:50.309Z 2026-01-29T14:46:12.514Z
9254368 9254368 20260123184107_O3g8U AU001B 2026-01-25T14:08:48.583Z 2026-01-29T14:46:12.164Z
9254341 9254341 20260123183048_h8HIz AU001B 2026-01-25T14:08:36.337Z 2026-01-29T14:46:08.431Z
9254299 9254299 20260123175525_bp5kY AU001B 2026-01-25T14:08:21.076Z 2026-01-29T14:46:04.568Z
9254184 9254184 20260123164228_QAV3e AU001B 2026-01-25T14:07:42.745Z 2026-01-29T14:45:56.576Z
9254112 9254112 20260123154412_OfSEB AU001B 2026-01-25T14:07:12.602Z 2026-01-29T14:45:42.287Z
9254090 9254090 20260123151109_NhiWI AU001B 2026-01-25T14:07:01.201Z 2026-01-29T14:45:36.213Z
9254044 9254044 20260123140259_5f53P AU001B 2026-01-25T14:06:37.161Z 2026-01-29T14:45:27.874Z
9247546 9247546 20260121185812_8kB1C AU001B 2026-01-23T14:10:26.416Z 2026-01-29T14:56:13.857Z
9247351 9247351 20260121180919_SyfLq AU001B 2026-01-23T14:09:53.642Z 2026-01-29T14:56:05.316Z
9247342 9247342 20260121180736_TYn2D AU001B 2026-01-23T14:09:51.677Z 2026-01-29T14:56:04.921Z
9247314 9247314 20260121180218_eHjS0 AU001B 2026-01-23T14:09:42.124Z 2026-01-29T14:56:03.616Z
9247303 9247303 20260121175713_APzgj AU001B 2026-01-23T14:09:38.575Z 2026-01-29T14:56:03.021Z
9247258 9247258 20260121174554_gzOP8 AU001B 2026-01-23T14:09:32.454Z 2026-01-29T14:55:52.420Z
9244788 9244788 20260119182715_d4zVW AU001B 2026-01-22T14:30:51.238Z 2026-01-28T14:56:49.666Z
9244778 9244778 20260119181335_HgCiU AU001B 2026-01-22T14:30:45.472Z 2026-01-28T14:56:46.131Z
9244768 9244768 20260119180202_eqUC1 AU001B 2026-01-22T14:30:40.771Z 2026-01-28T14:56:42.639Z
9240573 9240573 20260120165216_UWKph AU001B 2026-01-22T14:09:03.950Z 2026-01-29T15:01:31.220Z
9234009 9234009 20260119191243_5Tx6X AU001B 2026-01-21T14:11:47.518Z 2026-01-28T14:56:58.226Z
9233943 9233943 20260119185250_fTXb5 AU001B 2026-01-21T14:11:29.498Z 2026-01-28T14:56:54.677Z
9233849 9233849 20260119181932_iBYR7 AU001B 2026-01-21T14:10:52.704Z 2026-01-28T14:56:47.017Z
9233558 9233558 20260119140726_pigp0 AU001B 2026-01-21T14:08:13.300Z 2026-01-28T14:55:48.104Z
9227831 9227831 20260118181156_kuBOc AU001B 2026-01-20T14:14:20.876Z 2026-01-27T15:00:57.363Z
9227752 9227752 20260118172709_O0lYc AU001B 2026-01-20T14:13:48.408Z 2026-01-27T15:00:50.919Z
9227715 9227715 20260118164920_Hv2tH AU001B 2026-01-20T14:13:23.025Z 2026-01-27T15:00:39.102Z
9227669 9227669 20260118161023_ZKe5A AU001B 2026-01-20T14:12:59.610Z 2026-01-27T15:00:33.075Z
9227639 9227639 20260118151103_2H2tX AU001B 2026-01-20T14:12:12.745Z 2026-01-27T14:59:58.765Z
9225925 9225925 20260115165442_LjcZ5 AU001B 2026-01-19T14:39:01.327Z 2026-01-24T15:09:40.100Z
9225887 9225887 20260115153442_drmmB AU001B 2026-01-19T14:38:32.478Z 2026-01-24T15:09:14.409Z
9225872 9225872 20260115144805_k4auu AU001B 2026-01-19T14:38:16.157Z 2026-01-24T15:09:07.875Z
9225869 9225869 20260115144610_Is4bK AU001B 2026-01-19T14:38:13.893Z 2026-01-24T15:09:07.654Z
9225867 9225867 20260115144255_HPyMJ AU001B 2026-01-19T14:38:13.208Z 2026-01-24T15:09:07.182Z
9222568 9222568 20260117195651_u62tT AU001B 2026-01-19T14:15:17.976Z 2026-01-26T15:01:13.753Z
9222548 9222548 20260117195510_429gY AU001B 2026-01-19T14:15:14.510Z 2026-01-26T15:01:13.194Z
9222459 9222459 20260117193955_vdyyX AU001B 2026-01-19T14:14:53.153Z 2026-01-26T15:00:54.873Z
9222415 9222415 20260117192912_cUd7L AU001B 2026-01-19T14:14:40.400Z 2026-01-26T15:00:52.821Z
9222244 9222244 20260117184632_mTQk1 AU001B 2026-01-19T14:13:54.397Z 2026-01-26T15:00:44.957Z
9222164 9222164 20260117183335_8RfBd AU001B 2026-01-19T14:13:33.341Z 2026-01-26T15:00:42.246Z
9222009 9222009 20260117174544_2bCDN AU001B 2026-01-19T14:12:52.945Z 2026-01-26T15:00:34.382Z
9221877 9221877 20260117170506_Kr1st AU001B 2026-01-19T14:12:19.443Z 2026-01-26T15:00:28.562Z
9221767 9221767 20260117155653_Xr0XQ AU001B 2026-01-19T14:11:41.320Z 2026-01-26T15:00:05.025Z
9221731 9221731 20260117151230_ngR3k AU001B 2026-01-19T14:11:10.001Z 2026-01-26T14:59:59.779Z
9221716 9221716 20260117142510_J9Xu3 AU001B 2026-01-19T14:10:45.365Z 2026-01-26T14:59:54.698Z
9212011 9212011 20260115184258_XAp22 AU001B 2026-01-17T14:09:27.209Z 2026-01-24T15:10:18.695Z
9211996 9211996 20260115183920_iAVYu AU001B 2026-01-17T14:09:24.055Z 2026-01-24T15:10:17.860Z
9211964 9211964 20260115183423_VRWlm AU001B 2026-01-17T14:09:18.013Z 2026-01-24T15:10:14.957Z
9211928 9211928 20260115182548_a75cj AU001B 2026-01-17T14:09:06.085Z 2026-01-24T15:10:11.820Z
9211857 9211857 20260115180835_KD2pW AU001B 2026-01-17T14:08:48.114Z 2026-01-24T15:10:06.612Z
9211746 9211746 20260115173513_c4pDS AU001B 2026-01-17T14:08:13.519Z 2026-01-24T15:09:52.516Z
9211631 9211631 20260115170348_S23HC AU001B 2026-01-17T14:07:34.981Z 2026-01-24T15:09:42.278Z
9211565 9211565 20260115163248_dYm79 AU001B 2026-01-17T14:07:18.814Z 2026-01-24T15:09:35.315Z
9211528 9211528 20260115162455_5KxDA AU001B 2026-01-17T14:07:05.461Z 2026-01-24T15:09:31.029Z
9211497 9211497 20260115161201_CZBJo AU001B 2026-01-17T14:06:58.088Z 2026-01-24T15:09:28.421Z
9211467 9211467 20260115155330_2h3vz AU001B 2026-01-17T14:06:45.898Z 2026-01-24T15:09:16.463Z
9211463 9211463 20260115155126_TNPvG AU001B 2026-01-17T14:06:45.252Z 2026-01-24T15:09:16.299Z
9211418 9211418 20260115153121_MnAC9 AU001B 2026-01-17T14:06:33.624Z 2026-01-24T15:09:13.270Z
9211269 9211269 20260115142409_fjkQW AU001B 2026-01-17T14:05:53.049Z 2026-01-24T15:08:58.962Z
9206969 9206969 20260114200450_ARncn AU001B 2026-01-16T14:06:25.817Z 2026-01-22T15:02:44.944Z
9206950 9206950 20260114195809_t7HPq AU001B 2026-01-16T14:06:19.348Z 2026-01-22T15:02:44.239Z
9206909 9206909 20260114194416_EMZnx AU001B 2026-01-16T14:06:07.937Z 2026-01-22T15:02:43.038Z
9206900 9206900 20260114194130_cZ4sy AU001B 2026-01-16T14:06:05.372Z 2026-01-22T15:02:42.835Z
9206871 9206871 20260114193009_P1q9v AU001B 2026-01-16T14:05:58.122Z 2026-01-22T15:02:41.614Z
9206817 9206817 20260114190626_lRFjT AU001B 2026-01-16T14:05:42.083Z 2026-01-22T15:02:37.448Z
9206804 9206804 20260114190250_StY4Z AU001B 2026-01-16T14:05:38.868Z 2026-01-22T15:02:37.117Z
9206761 9206761 20260114184440_X0oAR AU001B 2026-01-16T14:05:26.713Z 2026-01-22T15:02:35.774Z
9206671 9206671 20260114181709_a5XkT AU001B 2026-01-16T14:05:01.045Z 2026-01-22T15:02:33.251Z
9206622 9206622 20260114175810_1gRyD AU001B 2026-01-16T14:04:47.921Z 2026-01-22T15:02:31.846Z
9206619 9206619 20260114175723_wB4jf AU001B 2026-01-16T14:04:46.311Z 2026-01-22T15:02:31.782Z
9206589 9206589 20260114174844_xgOVt AU001B 2026-01-16T14:04:37.577Z 2026-01-22T15:02:30.921Z

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