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

8,771 rows where station_code = "AU001Z" 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
8673421 8673421 20251201190053_NkXZ7 AU001Z 2025-12-03T14:18:48.491Z 2025-12-04T14:24:16.236Z
8673240 8673240 20251201174111_fFfJJ AU001Z 2025-12-03T14:18:04.090Z 2025-12-04T14:23:52.394Z
8673115 8673115 20251201165859_Vq1ta AU001Z 2025-12-03T14:17:35.770Z 2025-12-04T14:23:37.598Z
8666736 8666736 20251130194644_E12hT AU001Z 2025-12-02T14:27:15.084Z 2025-12-04T14:31:40.990Z
8666734 8666734 20251130194551_eapww AU001Z 2025-12-02T14:27:13.762Z 2025-12-04T14:31:40.245Z
8666730 8666730 20251130193802_8H3e6 AU001Z 2025-12-02T14:27:13.235Z 2025-12-04T14:31:38.182Z
8666697 8666697 20251130184548_n9vcO AU001Z 2025-12-02T14:27:09.823Z 2025-12-04T14:31:09.591Z
8666693 8666693 20251130184145_8rc5w AU001Z 2025-12-02T14:27:09.343Z 2025-12-04T14:31:08.581Z
8666610 8666610 20251130160451_kPWZJ AU001Z 2025-12-02T14:26:58.058Z 2025-12-04T14:30:08.522Z
8666608 8666608 20251130155710_T5f9p AU001Z 2025-12-02T14:26:57.931Z 2025-12-04T14:30:07.682Z
8666599 8666599 20251130154005_oX4Az AU001Z 2025-12-02T14:26:56.834Z 2025-12-04T14:29:56.004Z
8650120 8650120 20251129192820_k2RTm AU001Z 2025-12-01T14:15:08.121Z 2025-12-04T14:38:42.298Z
8650090 8650090 20251129191941_Dxy8y AU001Z 2025-12-01T14:15:02.760Z 2025-12-04T14:38:40.918Z
8650051 8650051 20251129191330_XWWi4 AU001Z 2025-12-01T14:14:51.599Z 2025-12-04T14:38:39.166Z
8649999 8649999 20251129190419_pL9dh AU001Z 2025-12-01T14:14:40.626Z 2025-12-04T14:38:37.214Z
8649907 8649907 20251129185002_XECq2 AU001Z 2025-12-01T14:14:17.906Z 2025-12-04T14:38:33.904Z
8649867 8649867 20251129184103_pC2a9 AU001Z 2025-12-01T14:14:09.992Z 2025-12-04T14:38:32.140Z
8649551 8649551 20251129174544_auCZt AU001Z 2025-12-01T14:13:01.502Z 2025-12-04T14:38:02.968Z
8649162 8649162 20251129162844_w7zzW AU001Z 2025-12-01T14:11:15.409Z 2025-12-04T14:37:46.552Z
8649099 8649099 20251129160905_gnsjN AU001Z 2025-12-01T14:10:54.481Z 2025-12-04T14:37:29.503Z
8649095 8649095 20251129160830_qcuel AU001Z 2025-12-01T14:10:53.768Z 2025-12-04T14:37:29.202Z
8649082 8649082 20251129160527_on2sS AU001Z 2025-12-01T14:10:50.371Z 2025-12-04T14:37:28.649Z
8648791 8648791 20251129123832_XyWuK AU001Z 2025-12-01T14:06:31.433Z 2025-12-04T14:36:38.982Z
8644662 8644662 20251128194133_2Ktg5 AU001Z 2025-11-30T14:22:13.142Z 2025-12-04T14:48:33.146Z
8644107 8644107 20251128185823_QInD4 AU001Z 2025-11-30T14:21:20.863Z 2025-12-04T14:48:20.197Z
8643973 8643973 20251128184432_O6OjS AU001Z 2025-11-30T14:20:56.157Z 2025-12-04T14:48:16.803Z
8643832 8643832 20251128183001_ycZzo AU001Z 2025-11-30T14:20:43.360Z 2025-12-04T14:48:11.919Z
8643752 8643752 20251128182244_2Pk48 AU001Z 2025-11-30T14:20:38.580Z 2025-12-04T14:47:51.863Z
8643293 8643293 20251128174228_L7ZPk AU001Z 2025-11-30T14:19:51.039Z 2025-12-04T14:47:42.109Z
8642870 8642870 20251128165918_Swsfm AU001Z 2025-11-30T14:18:45.093Z 2025-12-04T14:47:34.326Z
8642717 8642717 20251128164045_SnHKF AU001Z 2025-11-30T14:18:31.176Z 2025-12-04T14:47:31.640Z
8642646 8642646 20251128163245_uqzUq AU001Z 2025-11-30T14:18:24.392Z 2025-12-04T14:47:25.688Z
8642615 8642615 20251128163136_Lu2Z4 AU001Z 2025-11-30T14:18:22.046Z 2025-12-04T14:47:21.922Z
8641794 8641794 20251128151403_3ErEh AU001Z 2025-11-30T14:17:01.355Z 2025-12-04T14:46:50.316Z
8641270 8641270 20251128141851_qZPPe AU001Z 2025-11-30T14:15:15.635Z 2025-12-04T14:46:18.508Z
8641126 8641126 20251128134636_2UT5y AU001Z 2025-11-30T14:14:23.288Z 2025-12-04T14:46:08.625Z
8631700 8631700 20251127194803_qqdFU AU001Z 2025-11-29T14:16:04.310Z 2025-12-04T14:54:43.185Z
8631528 8631528 20251127192214_pFrx1 AU001Z 2025-11-29T14:15:41.153Z 2025-12-04T14:54:35.734Z
8631449 8631449 20251127190846_f1pxf AU001Z 2025-11-29T14:15:22.537Z 2025-12-04T14:54:33.900Z
8631275 8631275 20251127184330_h0KBU AU001Z 2025-11-29T14:15:03.386Z 2025-12-04T14:54:30.359Z
8631210 8631210 20251127183546_t7CMU AU001Z 2025-11-29T14:14:56.350Z 2025-12-04T14:54:28.895Z
8630980 8630980 20251127175903_g6E2T AU001Z 2025-11-29T14:14:14.919Z 2025-12-04T14:54:23.462Z
8630248 8630248 20251127152717_8mFqu AU001Z 2025-11-29T14:12:10.278Z 2025-12-04T14:53:35.427Z
8630145 8630145 20251127144750_d27ed AU001Z 2025-11-29T14:11:48.518Z 2025-12-04T14:53:31.418Z
8567401 8567401 20251120164824_2WLty AU001Z 2025-11-23T14:22:20.739Z 2025-11-29T14:54:02.588Z
8567396 8567396 20251120145925_kqZPb AU001Z 2025-11-23T14:21:34.101Z 2025-11-29T14:53:42.685Z
8551389 8551389 20251119193833_Q4CBy AU001Z 2025-11-22T14:25:47.714Z 2025-11-28T14:54:55.029Z
8551383 8551383 20251119191623_ygQRK AU001Z 2025-11-22T14:25:41.117Z 2025-11-28T14:54:52.120Z
8551381 8551381 20251119184250_IDjIf AU001Z 2025-11-22T14:25:33.746Z 2025-11-28T14:54:44.579Z
8551379 8551379 20251119182932_JtuPn AU001Z 2025-11-22T14:25:21.591Z 2025-11-28T14:54:38.198Z
8551371 8551371 20251119174904_v5xlP AU001Z 2025-11-22T14:25:07.141Z 2025-11-28T14:54:15.057Z
8551369 8551369 20251119173859_SKzvg AU001Z 2025-11-22T14:25:04.029Z 2025-11-28T14:54:09.498Z
8551367 8551367 20251119173421_2hpAE AU001Z 2025-11-22T14:25:02.480Z 2025-11-28T14:54:08.407Z
8551356 8551356 20251119142606_z0jjF AU001Z 2025-11-22T14:23:43.711Z 2025-11-28T14:53:35.077Z
8551354 8551354 20251119140938_t2wBM AU001Z 2025-11-22T14:23:38.540Z 2025-11-28T14:53:32.345Z
8551350 8551350 20251119134331_Mo0ss AU001Z 2025-11-22T14:23:30.009Z 2025-11-28T14:53:28.608Z
8551348 8551348 20251119124758_wQ35Z AU001Z 2025-11-22T14:23:09.375Z 2025-11-28T14:53:20.273Z
8525831 8525831 20251118192342_yP8yf AU001Z 2025-11-20T14:37:56.956Z 2025-11-27T15:11:33.150Z
8525763 8525763 20251118185444_3euBQ AU001Z 2025-11-20T14:37:40.518Z 2025-11-27T15:11:31.580Z
8502715 8502715 20251117153250_53P2m AU001Z 2025-11-19T14:03:29.094Z 2025-11-26T15:06:13.635Z
8500011 8500011 20251115201658_lm79n AU001Z 2025-11-18T14:42:06.111Z 2025-11-24T15:04:49.421Z
8500009 8500009 20251115200317_Jg0js AU001Z 2025-11-18T14:42:02.592Z 2025-11-24T15:04:48.439Z
8500003 8500003 20251115191235_3nzNL AU001Z 2025-11-18T14:41:25.963Z 2025-11-24T15:04:44.294Z
8499997 8499997 20251115184254_Bi3ms AU001Z 2025-11-18T14:41:13.942Z 2025-11-24T15:04:34.084Z
8499987 8499987 20251115173425_o6sUQ AU001Z 2025-11-18T14:41:00.564Z 2025-11-24T15:04:16.735Z
8499985 8499985 20251115172115_cx3CJ AU001Z 2025-11-18T14:40:58.332Z 2025-11-24T15:04:13.982Z
8499979 8499979 20251115155910_hImhS AU001Z 2025-11-18T14:40:18.701Z 2025-11-24T15:03:47.423Z
8499971 8499971 20251115151559_Vh7Gr AU001Z 2025-11-18T14:40:06.363Z 2025-11-24T15:03:24.609Z
8499962 8499962 20251115140940_s5zC1 AU001Z 2025-11-18T14:39:13.835Z 2025-11-24T15:03:04.178Z
8498786 8498786 20251116200250_vgosn AU001Z 2025-11-18T14:31:34.426Z 2025-11-25T15:08:24.640Z
8498779 8498779 20251116193652_2sD7b AU001Z 2025-11-18T14:31:31.531Z 2025-11-25T15:08:20.428Z
8498772 8498772 20251116192416_nmDzX AU001Z 2025-11-18T14:31:30.446Z 2025-11-25T15:08:15.052Z
8498770 8498770 20251116191730_b7C10 AU001Z 2025-11-18T14:31:29.936Z 2025-11-25T15:08:13.790Z
8498768 8498768 20251116191405_X1F7a AU001Z 2025-11-18T14:31:29.626Z 2025-11-25T15:08:13.430Z
8498760 8498760 20251116185018_cayOQ AU001Z 2025-11-18T14:31:26.172Z 2025-11-25T15:08:04.124Z
8498758 8498758 20251116184440_m65QG AU001Z 2025-11-18T14:31:25.451Z 2025-11-25T15:08:03.274Z
8498756 8498756 20251116183816_nJM1g AU001Z 2025-11-18T14:31:25.222Z 2025-11-25T15:08:02.935Z
8498754 8498754 20251116183033_fud3j AU001Z 2025-11-18T14:31:24.429Z 2025-11-25T15:07:57.728Z
8498745 8498745 20251116172001_e0vsn AU001Z 2025-11-18T14:31:21.852Z 2025-11-25T15:07:39.517Z
8498743 8498743 20251116171722_3P9pY AU001Z 2025-11-18T14:31:17.626Z 2025-11-25T15:07:35.027Z
8498739 8498739 20251116171204_LYmgk AU001Z 2025-11-18T14:31:15.332Z 2025-11-25T15:07:34.018Z
8498719 8498719 20251116155334_pn7ew AU001Z 2025-11-18T14:31:07.685Z 2025-11-25T15:07:23.705Z
8498715 8498715 20251116153034_heSIb AU001Z 2025-11-18T14:31:05.845Z 2025-11-25T15:07:08.361Z
8498705 8498705 20251116150845_dZry3 AU001Z 2025-11-18T14:31:02.043Z 2025-11-25T15:06:58.991Z
8498692 8498692 20251116133159_gELer AU001Z 2025-11-18T14:30:56.985Z 2025-11-25T15:06:29.194Z
8498686 8498686 20251116125754_JW3dA AU001Z 2025-11-18T14:30:54.642Z 2025-11-25T15:06:16.302Z
8498677 8498677 20251116123338_zr62n AU001Z 2025-11-18T14:30:53.478Z 2025-11-25T15:06:09.959Z
8498673 8498673 20251116120616_3bNW2 AU001Z 2025-11-18T14:30:52.049Z 2025-11-25T15:06:02.059Z
8482596 8482596 20251114194858_rFVQs AU001Z 2025-11-17T14:26:33.480Z 2025-11-23T15:17:07.591Z
8482591 8482591 20251114193127_GZHnV AU001Z 2025-11-17T14:26:29.177Z 2025-11-23T15:17:06.378Z
8482583 8482583 20251114183841_moX8e AU001Z 2025-11-17T14:26:01.222Z 2025-11-23T15:17:03.582Z
8482571 8482571 20251114180218_NutEx AU001Z 2025-11-17T14:25:51.948Z 2025-11-23T15:17:01.080Z
8482567 8482567 20251114174126_BEgjT AU001Z 2025-11-17T14:25:49.047Z 2025-11-23T15:17:00.226Z
8482565 8482565 20251114173947_BayL1 AU001Z 2025-11-17T14:25:48.628Z 2025-11-23T15:17:00.150Z
8482563 8482563 20251114172049_NWbOJ AU001Z 2025-11-17T14:25:44.830Z 2025-11-23T15:16:59.107Z
8482561 8482561 20251114172049_ZugQy AU001Z 2025-11-17T14:25:44.642Z 2025-11-23T15:16:59.071Z
8482559 8482559 20251114171549_qBQf2 AU001Z 2025-11-17T14:25:42.771Z 2025-11-23T15:16:58.523Z
8482546 8482546 20251114161832_wvDDl AU001Z 2025-11-17T14:25:14.208Z 2025-11-23T15:16:52.993Z
8482521 8482521 20251114144951_GH7YV AU001Z 2025-11-17T14:24:37.662Z 2025-11-23T15:16:19.762Z
8482515 8482515 20251114133748_pi5FQ AU001Z 2025-11-17T14:24:21.867Z 2025-11-23T15:16:03.240Z

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