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,210 rows where station_code = "AU004J" 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
8501437 8501437 20251116105926_CcjZr AU004J 2025-11-18T14:47:24.657Z 2025-11-24T15:06:32.464Z
8488166 8488166 20251116140309_9RmcS AU004J 2025-11-18T14:05:39.007Z 2025-11-25T15:06:41.389Z
8485948 8485948 20251115111136_LxZqE AU004J 2025-11-17T14:34:07.776Z 2025-11-23T15:20:15.877Z
8478469 8478469 20251115171918_cQ4ne AU004J 2025-11-17T14:13:38.676Z 2025-11-24T15:04:13.807Z
8475788 8475788 20251115141320_byFdj AU004J 2025-11-17T14:07:21.943Z 2025-11-24T15:03:04.760Z
8473967 8473967 20251115123956_cnOd2 AU004J 2025-11-17T14:03:26.199Z 2025-11-24T15:02:53.079Z
8473669 8473669 20251115122442_Jot8B AU004J 2025-11-17T14:02:45.200Z 2025-11-24T15:02:44.866Z
8473410 8473410 20251115121235_5QOK0 AU004J 2025-11-17T14:02:05.000Z 2025-11-24T15:02:36.541Z
8456000 8456000 20251113175626_Q4oHO AU004J 2025-11-15T14:10:13.198Z 2025-11-22T15:20:35.501Z
8446724 8446724 20251112181059_vRWBT AU004J 2025-11-14T14:11:51.838Z 2025-11-21T15:11:13.215Z
8446255 8446255 20251112170705_VsrS8 AU004J 2025-11-14T14:10:02.801Z 2025-11-21T15:11:08.613Z
8445332 8445332 20251112152008_N3u7W AU004J 2025-11-14T14:07:16.847Z 2025-11-21T15:10:45.725Z
8445291 8445291 20251112151520_O3r2P AU004J 2025-11-14T14:07:05.338Z 2025-11-21T15:10:44.142Z
8445287 8445287 20251112151405_PyenF AU004J 2025-11-14T14:07:00.341Z 2025-11-21T15:10:43.666Z
8445000 8445000 20251112143022_ivr2k AU004J 2025-11-14T14:06:04.287Z 2025-11-21T15:10:35.030Z
8444867 8444867 20251112140302_CHpil AU004J 2025-11-14T14:05:32.850Z 2025-11-21T15:10:32.814Z
8444792 8444792 20251112134725_IDxfj AU004J 2025-11-14T14:05:25.654Z 2025-11-21T15:10:29.431Z
8444662 8444662 20251112132809_78TzC AU004J 2025-11-14T14:04:55.437Z 2025-11-21T15:10:27.305Z
8444555 8444555 20251112130324_F2y6K AU004J 2025-11-14T14:04:39.088Z 2025-11-21T15:10:24.944Z
8444474 8444474 20251112123946_6xrnU AU004J 2025-11-14T14:04:09.827Z 2025-11-21T15:10:19.633Z
8444423 8444423 20251112122718_Tb7LN AU004J 2025-11-14T14:03:50.061Z 2025-11-21T15:10:17.481Z
8443425 8443425 20251111120525_BOts4 AU004J 2025-11-13T14:50:48.575Z 2025-11-19T15:19:18.551Z
8442079 8442079 20251112111007_YyWql AU004J 2025-11-13T14:39:52.600Z 2025-11-13T14:39:52.600Z
8433863 8433863 20251111172702_D2x3a AU004J 2025-11-13T14:11:17.747Z 2025-11-20T15:21:10.928Z
8433155 8433155 20251111163944_DFHUm AU004J 2025-11-13T14:09:34.357Z 2025-11-20T15:20:35.124Z
8433086 8433086 20251111163513_AhB8u AU004J 2025-11-13T14:09:21.118Z 2025-11-20T15:20:34.262Z
8431691 8431691 20251111143458_ludOj AU004J 2025-11-13T14:05:27.837Z 2025-11-20T15:20:01.945Z
8431432 8431432 20251111140700_O2PsJ AU004J 2025-11-13T14:04:39.283Z 2025-11-20T15:19:56.734Z
8431313 8431313 20251111135415_5iUx1 AU004J 2025-11-13T14:04:12.313Z 2025-11-20T15:19:54.549Z
8430763 8430763 20251111130430_ZKnyA AU004J 2025-11-13T14:02:24.092Z 2025-11-20T15:19:42.467Z
8430643 8430643 20251111125337_rRX22 AU004J 2025-11-13T14:01:59.059Z 2025-11-20T15:19:36.088Z
8430565 8430565 20251111124402_LSIjZ AU004J 2025-11-13T14:01:44.297Z 2025-11-20T15:19:34.963Z
8430556 8430556 20251111124258_X0t2q AU004J 2025-11-13T14:01:41.955Z 2025-11-20T15:19:34.908Z
8400590 8400590 20251108120431_BZrHK AU004J 2025-11-09T14:21:18.999Z 2025-11-16T15:06:01.416Z
8400556 8400556 20251108115758_Xkb2K AU004J 2025-11-09T14:21:01.495Z 2025-11-16T15:06:00.897Z
8399996 8399996 20251108102430_WnGRH AU004J 2025-11-09T14:19:37.208Z 2025-11-16T15:05:56.233Z
8394706 8394706 20251108123201_wm8lb AU004J 2025-11-09T14:00:08.894Z 2025-11-17T14:57:43.777Z
8388147 8388147 20251105104115_ZlrjT AU004J 2025-11-07T14:24:07.434Z 2025-11-13T15:16:04.411Z
8388145 8388145 20251105103515_D4b08 AU004J 2025-11-07T14:24:05.217Z 2025-11-13T15:16:04.085Z
8388143 8388143 20251105102921_LGrUj AU004J 2025-11-07T14:24:01.059Z 2025-11-13T15:16:03.069Z
8384664 8384664 20251105130113_YMuF0 AU004J 2025-11-07T14:01:56.751Z 2025-11-14T15:07:23.785Z
8355770 8355770 20251101123212_NDEEH AU004J 2025-11-03T14:37:59.587Z 2025-11-09T15:06:49.495Z
8355765 8355765 20251101123200_WcmJI AU004J 2025-11-03T14:37:58.953Z 2025-11-09T15:06:49.437Z
8355668 8355668 20251101122412_ifjpf AU004J 2025-11-03T14:37:49.887Z 2025-11-09T15:06:48.310Z
8354515 8354515 20251101102824_lB2Hj AU004J 2025-11-03T14:35:45.274Z 2025-11-09T15:06:17.017Z
8349035 8349035 20251101172200_igS8n AU004J 2025-11-03T14:05:25.432Z 2025-11-10T15:04:03.672Z
8348782 8348782 20251101162218_BVJTW AU004J 2025-11-03T14:04:15.222Z 2025-11-10T15:03:43.231Z
8348727 8348727 20251101160555_LZpNt AU004J 2025-11-03T14:03:55.772Z 2025-11-10T15:03:37.367Z
8348640 8348640 20251101155122_LkbZv AU004J 2025-11-03T14:03:36.385Z 2025-11-10T15:03:33.225Z
8348197 8348197 20251101143646_JmSRN AU004J 2025-11-03T14:01:52.894Z 2025-11-10T15:02:55.743Z
8348089 8348089 20251101141326_h9aOw AU004J 2025-11-03T14:01:20.997Z 2025-11-10T15:02:43.730Z
8340334 8340334 20251031114403_WCBzr AU004J 2025-11-02T14:35:21.256Z 2025-11-08T15:18:05.795Z
8329802 8329802 20251031174100_dPcbX AU004J 2025-11-02T14:03:59.445Z 2025-11-09T14:58:20.430Z
8329778 8329778 20251031165000_rkYaO AU004J 2025-11-02T14:03:54.609Z 2025-11-09T14:58:14.265Z
8329577 8329577 20251031154320_Ix2Wy AU004J 2025-11-02T14:03:20.594Z 2025-11-09T14:58:11.632Z
8329195 8329195 20251031145014_NZmWT AU004J 2025-11-02T14:02:07.139Z 2025-11-09T14:58:06.005Z
8328642 8328642 20251031131405_yWsoC AU004J 2025-11-02T14:00:38.382Z 2025-11-09T14:57:59.745Z
8303714 8303714 20251029175543_ANwMg AU004J 2025-10-31T12:07:06.867Z 2025-11-07T15:09:45.818Z
8303592 8303592 20251029174008_w8Jig AU004J 2025-10-31T12:06:47.551Z 2025-11-07T15:09:39.457Z
8303318 8303318 20251029165447_JzUPZ AU004J 2025-10-31T12:06:04.205Z 2025-11-07T15:09:28.107Z
8303125 8303125 20251029162704_BLXt9 AU004J 2025-10-31T12:05:42.425Z 2025-11-07T15:09:24.948Z
8302725 8302725 20251029154208_gAJf1 AU004J 2025-10-31T12:04:33.652Z 2025-11-07T15:09:20.160Z
8295433 8295433 20251028114850_f7Ts9 AU004J 2025-10-30T12:42:58.493Z 2025-11-05T15:25:16.197Z
8295166 8295166 20251028112337_7zYPc AU004J 2025-10-30T12:42:33.781Z 2025-11-05T15:25:00.482Z
8294509 8294509 20251028104012_DS7bu AU004J 2025-10-30T12:41:05.572Z 2025-11-05T15:24:33.586Z
8294322 8294322 20251028102827_Zx3MX AU004J 2025-10-30T12:40:58.508Z 2025-11-05T15:24:23.140Z
8288312 8288312 20251028171543_DxSdR AU004J 2025-10-30T12:09:52.672Z 2025-11-06T15:11:11.068Z
8288299 8288299 20251028171426_VPkna AU004J 2025-10-30T12:09:50.630Z 2025-11-06T15:11:10.897Z
8286574 8286574 20251028145054_8bBVO AU004J 2025-10-30T12:04:12.819Z 2025-11-06T15:10:25.637Z
8286550 8286550 20251028144858_CgyjG AU004J 2025-10-30T12:04:10.278Z 2025-11-06T15:10:25.382Z
8286378 8286378 20251028143432_5D2MS AU004J 2025-10-30T12:03:34.999Z 2025-11-06T15:10:24.432Z
8286109 8286109 20251028141246_423Br AU004J 2025-10-30T12:02:37.799Z 2025-11-06T15:10:21.708Z
8285984 8285984 20251028140253_Tou4n AU004J 2025-10-30T12:02:16.631Z 2025-11-06T15:10:19.631Z
8285836 8285836 20251028135143_Pb4yQ AU004J 2025-10-30T12:01:45.700Z 2025-11-06T15:10:17.211Z
8285706 8285706 20251028134031_ZJk35 AU004J 2025-10-30T12:01:24.390Z 2025-11-06T15:10:14.214Z
8277603 8277603 20251027104325_Xr27p AU004J 2025-10-29T12:32:11.810Z 2025-11-04T15:47:47.898Z
8277290 8277290 20251027101311_Amsk3 AU004J 2025-10-29T12:31:30.356Z 2025-11-04T15:47:40.168Z
8277263 8277263 20251027101012_xcTOc AU004J 2025-10-29T12:31:28.163Z 2025-11-04T15:47:39.391Z
8270272 8270272 20251027172837_hjuse AU004J 2025-10-29T12:05:26.813Z 2025-11-05T15:19:07.701Z
8269764 8269764 20251027165000_j2fJg AU004J 2025-10-29T12:04:22.862Z 2025-11-05T15:18:57.911Z
8269068 8269068 20251027153944_trJ3b AU004J 2025-10-29T12:02:44.447Z 2025-11-05T15:18:39.645Z
8268882 8268882 20251027151649_lM3Rl AU004J 2025-10-29T12:02:14.422Z 2025-11-05T15:18:34.002Z
8268414 8268414 20251027135926_Xu2pv AU004J 2025-10-29T12:01:02.453Z 2025-11-05T15:18:30.059Z
8268203 8268203 20251027132049_MNxXJ AU004J 2025-10-29T12:00:35.002Z 2025-11-05T15:18:28.778Z
8248647 8248647 20251026150627_EVGqo AU004J 2025-10-28T12:02:34.567Z 2025-11-04T15:39:16.647Z
8248467 8248467 20251026141514_C65fz AU004J 2025-10-28T12:01:51.005Z 2025-11-04T15:38:55.035Z
8248199 8248199 20251026131539_3p1M2 AU004J 2025-10-28T12:00:53.773Z 2025-11-04T15:38:43.580Z
8248180 8248180 20251026131230_xPKfa AU004J 2025-10-28T12:00:49.258Z 2025-11-04T15:38:42.772Z
8228988 8228988 20251023112407_CWnNP AU004J 2025-10-26T12:54:39.770Z 2025-10-31T13:09:14.838Z
8228986 8228986 20251023112252_700u8 AU004J 2025-10-26T12:54:39.225Z 2025-10-31T13:09:14.818Z
8228964 8228964 20251023104755_dvmlU AU004J 2025-10-26T12:54:20.659Z 2025-10-31T13:09:10.295Z
8228949 8228949 20251023104141_V7cSs AU004J 2025-10-26T12:54:15.030Z 2025-10-31T13:09:06.719Z
8228947 8228947 20251023103940_P1QmF AU004J 2025-10-26T12:54:14.307Z 2025-10-31T13:09:06.589Z
8228922 8228922 20251023094916_Cp23l AU004J 2025-10-26T12:53:56.481Z 2025-10-31T13:09:03.013Z
8209278 8209278 20251023164635_DBeKc AU004J 2025-10-26T12:17:05.236Z 2025-11-01T13:09:34.595Z
8208848 8208848 20251023153754_k03bf AU004J 2025-10-26T12:15:16.985Z 2025-11-01T13:09:22.013Z
8208752 8208752 20251023151641_tJrmO AU004J 2025-10-26T12:14:48.709Z 2025-11-01T13:09:17.796Z
8208724 8208724 20251023151116_1C0ve AU004J 2025-10-26T12:14:38.880Z 2025-11-01T13:09:17.368Z
8208419 8208419 20251023132709_8YrrY AU004J 2025-10-26T12:12:46.256Z 2025-11-01T13:09:02.784Z
8208397 8208397 20251023131937_P6KP6 AU004J 2025-10-26T12:12:39.739Z 2025-11-01T13:09:01.692Z

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