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 = "AU0003" 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
8071943 8071943 20251007155110_cS4c3 AU0003 2025-10-09T12:02:45.853Z 2025-10-16T12:47:55.131Z
8071559 8071559 20251008113124_F3R7H AU0003 2025-10-09T12:00:52.561Z 2025-10-09T12:00:52.561Z
8023439 8023439 20250930112132_5gu5A AU0003 2025-10-02T12:09:06.751Z 2025-10-09T12:35:28.715Z
8014047 8014047 20250929143207_VhiQZ AU0003 2025-10-01T12:15:43.559Z 2025-10-08T12:41:56.725Z
8013705 8013705 20250929134206_JmOTh AU0003 2025-10-01T12:14:48.159Z 2025-10-08T12:41:54.623Z
7979638 7979638 20250926140459_BAydr AU0003 2025-09-28T12:14:40.608Z 2025-10-05T13:09:23.591Z
7979125 7979125 20250926130007_FHVhi AU0003 2025-09-28T12:13:34.197Z 2025-10-05T13:09:15.628Z
7978929 7978929 20250926122706_Xb2B2 AU0003 2025-09-28T12:13:01.205Z 2025-10-05T13:09:11.915Z
7978625 7978625 20250926113829_dqerx AU0003 2025-09-28T12:12:17.420Z 2025-10-05T13:09:02.981Z
7968504 7968504 20250925140754_17Xr3 AU0003 2025-09-27T12:06:36.273Z 2025-10-04T13:06:10.664Z
7968319 7968319 20250925135049_vxMbS AU0003 2025-09-27T12:06:21.842Z 2025-10-04T13:06:08.543Z
7967128 7967128 20250925114143_MUHjH AU0003 2025-09-27T12:05:02.955Z 2025-10-04T13:05:57.568Z
7966971 7966971 20250925112544_VxYGV AU0003 2025-09-27T12:04:55.019Z 2025-10-04T13:05:54.648Z
7955382 7955382 20250924142302_kB0Tk AU0003 2025-09-26T12:13:59.029Z 2025-10-03T13:03:33.893Z
7954985 7954985 20250924120520_eOWgC AU0003 2025-09-26T12:12:40.544Z 2025-10-03T13:03:23.595Z
7951390 7951390 20250922152740_2FgHF AU0003 2025-09-25T12:41:40.243Z 2025-10-01T13:22:35.393Z
7951362 7951362 20250922131602_cuFOQ AU0003 2025-09-25T12:41:29.385Z 2025-10-01T13:22:27.856Z
7951359 7951359 20250922131335_2go1D AU0003 2025-09-25T12:41:29.046Z 2025-10-01T13:22:27.488Z
7951350 7951350 20250922123922_Bhwtw AU0003 2025-09-25T12:41:25.311Z 2025-10-01T13:22:23.416Z
7941351 7941351 20250923133736_uRLg2 AU0003 2025-09-25T12:16:06.136Z 2025-10-02T13:24:57.065Z
7940944 7940944 20250923120458_WM0XI AU0003 2025-09-25T12:14:40.851Z 2025-10-02T13:24:31.726Z
7940940 7940940 20250923120454_cCtn3 AU0003 2025-09-25T12:14:40.044Z 2025-10-02T13:24:30.871Z
7936892 7936892 20250920123414_CgLkI AU0003 2025-09-24T12:58:12.248Z 2025-09-29T13:04:28.772Z
7936887 7936887 20250920122858_zzN7v AU0003 2025-09-24T12:58:11.625Z 2025-09-29T13:04:28.383Z
7936875 7936875 20250920120408_Jknsd AU0003 2025-09-24T12:58:05.762Z 2025-09-29T13:04:25.203Z
7936864 7936864 20250920114941_WMdVt AU0003 2025-09-24T12:58:02.004Z 2025-09-29T13:04:23.575Z
7926625 7926625 20250921145655_9QKrm AU0003 2025-09-24T12:43:15.228Z 2025-09-30T13:01:55.518Z
7926256 7926256 20250921132334_gaAz0 AU0003 2025-09-24T12:42:16.716Z 2025-09-30T13:01:52.114Z
7925700 7925700 20250921113849_fE9ZZ AU0003 2025-09-24T12:41:48.559Z 2025-09-30T13:01:48.887Z
7907176 7907176 20250919135213_Sl672 AU0003 2025-09-22T12:44:23.300Z 2025-09-28T12:53:59.081Z
7907174 7907174 20250919134438_pNGH4 AU0003 2025-09-22T12:44:22.408Z 2025-09-28T12:53:58.881Z
7890160 7890160 20250919152102_CRoM7 AU0003 2025-09-21T12:29:47.680Z 2025-09-21T12:40:50.004Z
7889944 7889944 20250919150142_gyw2u AU0003 2025-09-21T12:29:20.308Z 2025-09-28T12:54:03.529Z
7888624 7888624 20250919132020_fiHIz AU0003 2025-09-21T12:27:31.779Z 2025-09-28T12:53:58.008Z
7883525 7883525 20250916153959_pTJnz AU0003 2025-09-20T12:50:12.089Z 2025-09-24T13:17:12.300Z
7883521 7883521 20250916151107_p6Myh AU0003 2025-09-20T12:50:08.993Z 2025-09-24T13:17:10.628Z
7878490 7878490 20250918160149_Cb2wj AU0003 2025-09-20T12:28:12.081Z 2025-09-27T12:47:17.897Z
7878069 7878069 20250918145936_ckqDg AU0003 2025-09-20T12:27:26.090Z 2025-09-27T12:47:15.006Z
7877579 7877579 20250918131306_b8wYl AU0003 2025-09-20T12:26:28.782Z 2025-09-27T12:47:10.663Z
7877205 7877205 20250918114416_1AF7F AU0003 2025-09-20T12:25:20.756Z 2025-09-27T12:47:03.003Z
7868927 7868927 20250917165334_2PumX AU0003 2025-09-19T12:24:05.095Z 2025-09-25T13:12:22.406Z
7868919 7868919 20250917165227_n2nYk AU0003 2025-09-19T12:24:02.629Z 2025-09-25T13:12:22.387Z
7868777 7868777 20250917161006_3YHtu AU0003 2025-09-19T12:23:40.140Z 2025-09-25T13:12:19.278Z
7868729 7868729 20250917155638_ft2wE AU0003 2025-09-19T12:23:34.666Z 2025-09-25T13:12:17.941Z
7868622 7868622 20250917152249_p5xuJ AU0003 2025-09-19T12:23:07.949Z 2025-09-25T13:12:17.072Z
7868586 7868586 20250917151322_x394F AU0003 2025-09-19T12:23:03.318Z 2025-09-25T13:12:16.633Z
7868422 7868422 20250917141311_nDZrg AU0003 2025-09-19T12:22:28.174Z 2025-09-25T13:12:11.296Z
7868384 7868384 20250917135944_UzXwC AU0003 2025-09-19T12:22:23.020Z 2025-09-25T13:12:10.832Z
7868151 7868151 20250917120626_lV8Wz AU0003 2025-09-19T12:21:29.740Z 2025-09-25T13:12:00.572Z
7861960 7861960 20250916150957_MqzTy AU0003 2025-09-18T12:31:30.645Z 2025-09-24T13:17:10.605Z
7861957 7861957 20250916150738_WAdTa AU0003 2025-09-18T12:31:30.451Z 2025-09-24T13:17:10.599Z
7861928 7861928 20250916145228_KJ5B0 AU0003 2025-09-18T12:31:25.851Z 2025-09-24T13:17:09.998Z
7861510 7861510 20250916120043_DXeRq AU0003 2025-09-18T12:30:02.230Z 2025-09-24T13:16:59.498Z
7856240 7856240 20250914170508_3MlhA AU0003 2025-09-17T12:44:25.222Z 2025-09-22T13:08:52.767Z
7856216 7856216 20250914134749_JkWe0 AU0003 2025-09-17T12:43:00.196Z 2025-09-22T13:08:30.478Z
7856210 7856210 20250914131237_7Smtm AU0003 2025-09-17T12:42:53.745Z 2025-09-22T13:08:26.331Z
7853201 7853201 20250915170656_Z7xGO AU0003 2025-09-17T12:32:25.713Z 2025-09-22T13:05:10.484Z
7852689 7852689 20250915161816_O82aH AU0003 2025-09-17T12:31:29.620Z 2025-09-22T13:04:57.994Z
7852483 7852483 20250915155616_2ZS9I AU0003 2025-09-17T12:31:16.786Z 2025-09-22T13:04:52.622Z
7851100 7851100 20250915132729_DKARl AU0003 2025-09-17T12:28:42.648Z 2025-09-22T13:04:26.453Z
7850967 7850967 20250915130904_nVsQ5 AU0003 2025-09-17T12:28:31.534Z 2025-09-22T13:04:24.313Z
7850461 7850461 20250915113411_f7Sq1 AU0003 2025-09-17T12:26:55.095Z 2025-09-22T13:04:06.526Z
7843299 7843299 20250913172856_gGgZn AU0003 2025-09-16T12:39:24.692Z 2025-09-21T13:09:45.172Z
7841425 7841425 20250914171522_GR3LX AU0003 2025-09-16T12:32:36.351Z 2025-09-22T13:08:54.427Z
7840500 7840500 20250914152937_Y1ILN AU0003 2025-09-16T12:31:27.007Z 2025-09-16T12:35:09.497Z
7839951 7839951 20250914143507_hUImL AU0003 2025-09-16T12:30:36.613Z 2025-09-22T13:08:36.118Z
7839637 7839637 20250914140443_uA2w3 AU0003 2025-09-16T12:30:12.960Z 2025-09-22T13:08:33.279Z
7839360 7839360 20250914133802_8Tui9 AU0003 2025-09-16T12:29:46.741Z 2025-09-22T13:08:29.096Z
7839225 7839225 20250914132059_7fL1t AU0003 2025-09-16T12:29:39.886Z 2025-09-22T13:08:27.656Z
7839222 7839222 20250914132059_NXV2G AU0003 2025-09-16T12:29:39.730Z 2025-09-22T13:08:27.654Z
7839126 7839126 20250914131236_gEvqY AU0003 2025-09-16T12:29:34.831Z 2025-09-22T13:08:26.319Z
7838495 7838495 20250914114819_XG3zQ AU0003 2025-09-16T12:28:22.139Z 2025-09-22T13:08:19.766Z
7824375 7824375 20250911114828_4ywTY AU0003 2025-09-14T12:34:31.486Z 2025-09-19T12:57:47.891Z
7823535 7823535 20250912130947_knoSL AU0003 2025-09-14T12:25:54.180Z 2025-09-20T13:02:47.276Z
7823530 7823530 20250912130857_9A3SK AU0003 2025-09-14T12:25:53.365Z 2025-09-20T13:02:47.189Z
7823483 7823483 20250912123909_FANre AU0003 2025-09-14T12:25:36.826Z 2025-09-20T13:02:46.091Z
7823462 7823462 20250912121227_iaeYg AU0003 2025-09-14T12:25:09.890Z 2025-09-20T13:02:45.360Z
7817767 7817767 20250911145601_egKHG AU0003 2025-09-13T12:30:58.612Z 2025-09-19T12:58:05.048Z
7817619 7817619 20250911125244_vj01Z AU0003 2025-09-13T12:30:38.222Z 2025-09-19T12:57:55.473Z
7817592 7817592 20250911121302_an4wH AU0003 2025-09-13T12:30:32.734Z 2025-09-19T12:57:52.501Z
7808696 7808696 20250910164913_q2lDt AU0003 2025-09-12T12:24:55.786Z 2025-09-18T13:00:22.079Z
7808580 7808580 20250910144839_aXTjL AU0003 2025-09-12T12:23:57.922Z 2025-09-18T13:00:13.715Z
7803625 7803625 20250909153148_qkcps AU0003 2025-09-11T12:22:49.546Z 2025-09-17T12:57:16.555Z
7781908 7781908 20250904134516_K6ERr AU0003 2025-09-07T12:37:41.033Z 2025-09-12T12:52:51.023Z
7781872 7781872 20250905160625_uvKFT AU0003 2025-09-07T12:27:47.539Z 2025-09-13T12:58:56.215Z
7776951 7776951 20250904143343_EWOyP AU0003 2025-09-06T13:35:37.761Z 2025-09-12T12:52:58.508Z
7776918 7776918 20250904142306_KrKuK AU0003 2025-09-06T13:35:35.982Z 2025-09-12T12:52:57.564Z
7776914 7776914 20250904142251_EKvfA AU0003 2025-09-06T13:35:35.577Z 2025-09-12T12:52:57.267Z
7776906 7776906 20250904141915_u9yWk AU0003 2025-09-06T13:35:34.756Z 2025-09-12T12:52:57.197Z
7776899 7776899 20250904141737_cohEB AU0003 2025-09-06T13:35:34.136Z 2025-09-12T12:52:57.109Z
7775349 7775349 20250903163618_1YS25 AU0003 2025-09-06T13:23:24.909Z 2025-09-12T12:47:23.889Z
7766823 7766823 20250904181149_rogaM AU0003 2025-09-06T12:16:11.176Z 2025-09-13T12:54:28.162Z
7766801 7766801 20250904180613_kxcff AU0003 2025-09-06T12:15:40.469Z 2025-09-13T12:54:27.707Z
7766773 7766773 20250904180001_bruTa AU0003 2025-09-06T12:15:28.613Z 2025-09-13T12:54:26.749Z
7766703 7766703 20250904174229_dWrV7 AU0003 2025-09-06T12:13:50.036Z 2025-09-13T12:54:24.923Z
7758125 7758125 20250903181423_Z2Sgi AU0003 2025-09-05T12:04:26.812Z 2025-09-12T12:47:37.856Z
7753885 7753885 20250901183850_qe0fU AU0003 2025-09-04T12:24:19.806Z 2025-09-10T12:45:14.795Z
7753883 7753883 20250901183755_3p9OV AU0003 2025-09-04T12:24:19.593Z 2025-09-10T12:45:14.747Z
7753876 7753876 20250901182145_Tfudu AU0003 2025-09-04T12:24:17.507Z 2025-09-10T12:45:14.146Z
7753873 7753873 20250901181450_bxQlQ AU0003 2025-09-04T12:24:16.620Z 2025-09-10T12:45:13.927Z

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