participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,983 rows where station_code = "AU000C" sorted by created_at descending
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 |
---|---|---|---|---|---|
5097077 | 5097077 | 20240912142100_Z1eBb | AU000C | 2024-09-16T12:16:44.347Z | 2024-09-16T12:17:32.023Z |
5097066 | 5097066 | 20240912141557_aCxbQ | AU000C | 2024-09-16T12:16:43.918Z | 2024-09-16T12:17:32.019Z |
5097061 | 5097061 | 20240912141023_h33zs | AU000C | 2024-09-16T12:16:43.882Z | 2024-09-16T12:17:32.017Z |
5097048 | 5097048 | 20240912140355_bP6dP | AU000C | 2024-09-16T12:16:43.542Z | 2024-09-16T12:17:32.012Z |
5097036 | 5097036 | 20240912135933_aSbzR | AU000C | 2024-09-16T12:16:43.017Z | 2024-09-16T12:17:32.008Z |
5097021 | 5097021 | 20240912134612_bv2Ci | AU000C | 2024-09-16T12:16:42.492Z | 2024-09-16T12:17:32.000Z |
5096986 | 5096986 | 20240912132224_IDnSc | AU000C | 2024-09-16T12:16:41.611Z | 2024-09-16T12:17:31.989Z |
5096984 | 5096984 | 20240912132218_3WO2Q | AU000C | 2024-09-16T12:16:41.562Z | 2024-09-16T12:17:31.988Z |
5096968 | 5096968 | 20240912131412_tLKnz | AU000C | 2024-09-16T12:16:40.956Z | 2024-09-16T12:17:31.983Z |
5096945 | 5096945 | 20240912123905_2SJa5 | AU000C | 2024-09-16T12:16:39.803Z | 2024-09-16T12:17:31.972Z |
5096915 | 5096915 | 20240912121447_RI80x | AU000C | 2024-09-16T12:16:37.601Z | 2024-09-16T12:17:31.961Z |
5085359 | 5085359 | 20240912211411_kFIyT | AU000C | 2024-09-16T12:04:08.894Z | 2024-09-16T12:17:04.705Z |
5085249 | 5085249 | 20240912210414_Apyyu | AU000C | 2024-09-16T12:03:47.931Z | 2024-09-16T12:17:04.666Z |
5085119 | 5085119 | 20240912204809_3ydGV | AU000C | 2024-09-16T12:03:34.085Z | 2024-09-16T12:17:04.596Z |
5084703 | 5084703 | 20240912200748_2RXid | AU000C | 2024-09-16T12:02:49.523Z | 2024-09-16T12:17:04.430Z |
5084682 | 5084682 | 20240912200455_k3nBH | AU000C | 2024-09-16T12:02:46.861Z | 2024-09-16T12:17:04.419Z |
5084677 | 5084677 | 20240912200406_lrdCH | AU000C | 2024-09-16T12:02:46.054Z | 2024-09-16T12:17:04.416Z |
5084511 | 5084511 | 20240912194504_A0dOU | AU000C | 2024-09-16T12:02:11.840Z | 2024-09-16T12:17:04.331Z |
5084450 | 5084450 | 20240912193940_QJFZs | AU000C | 2024-09-16T12:02:05.607Z | 2024-09-16T12:17:04.311Z |
5084367 | 5084367 | 20240912193012_g3F8k | AU000C | 2024-09-16T12:01:58.348Z | 2024-09-16T12:17:04.271Z |
5084290 | 5084290 | 20240912191018_67ElL | AU000C | 2024-09-16T12:01:48.277Z | 2024-09-16T12:17:04.226Z |
5084267 | 5084267 | 20240912190410_c2MOp | AU000C | 2024-09-16T12:01:43.920Z | 2024-09-16T12:17:04.211Z |
5084235 | 5084235 | 20240912190157_62KMS | AU000C | 2024-09-16T12:01:37.932Z | 2024-09-16T12:17:04.194Z |
5084185 | 5084185 | 20240912185034_s2EyI | AU000C | 2024-09-16T12:01:29.066Z | 2024-09-16T12:17:04.166Z |
5084180 | 5084180 | 20240912184748_ZjMg9 | AU000C | 2024-09-16T12:01:27.653Z | 2024-09-16T12:17:04.163Z |
5084153 | 5084153 | 20240912183340_lCC8V | AU000C | 2024-09-16T12:01:17.021Z | 2024-09-16T12:17:04.140Z |
5084143 | 5084143 | 20240912182955_dU8WO | AU000C | 2024-09-16T12:01:15.550Z | 2024-09-16T12:17:04.135Z |
5084120 | 5084120 | 20240912181833_YXmqG | AU000C | 2024-09-16T12:01:12.199Z | 2024-09-16T12:17:04.106Z |
5084099 | 5084099 | 20240912180837_qK8iO | AU000C | 2024-09-16T12:01:09.038Z | 2024-09-16T12:17:04.096Z |
5084053 | 5084053 | 20240912175420_fxNdm | AU000C | 2024-09-16T12:01:00.961Z | 2024-09-16T12:17:04.064Z |
5084049 | 5084049 | 20240912175329_Kq3rM | AU000C | 2024-09-16T12:01:00.393Z | 2024-09-16T12:17:04.061Z |
5084021 | 5084021 | 20240912173912_ZVb3I | AU000C | 2024-09-16T12:00:56.527Z | 2024-09-16T12:17:04.040Z |
5084015 | 5084015 | 20240912173833_6p3rQ | AU000C | 2024-09-16T12:00:55.947Z | 2024-09-16T12:17:04.037Z |
5084004 | 5084004 | 20240912173409_Li5bg | AU000C | 2024-09-16T12:00:54.461Z | 2024-09-16T12:17:04.032Z |
5083980 | 5083980 | 20240912171352_c4vX2 | AU000C | 2024-09-16T12:00:46.179Z | 2024-09-16T12:17:04.013Z |
5083971 | 5083971 | 20240912171204_3y4tA | AU000C | 2024-09-16T12:00:45.146Z | 2024-09-16T12:17:04.008Z |
5083956 | 5083956 | 20240912171109_SMYW2 | AU000C | 2024-09-16T12:00:43.826Z | 2024-09-16T12:17:04.002Z |
5083950 | 5083950 | 20240912170831_xRByK | AU000C | 2024-09-16T12:00:43.210Z | 2024-09-16T12:17:03.999Z |
5083870 | 5083870 | 20240912162722_bOSXs | AU000C | 2024-09-16T12:00:34.058Z | 2024-09-16T12:17:03.957Z |
5083854 | 5083854 | 20240912161921_yL7uZ | AU000C | 2024-09-16T12:00:31.886Z | 2024-09-16T12:17:03.949Z |
5083844 | 5083844 | 20240912161316_E3YPl | AU000C | 2024-09-16T12:00:30.886Z | 2024-09-16T12:17:03.944Z |
5083821 | 5083821 | 20240912155944_xlhlW | AU000C | 2024-09-16T12:00:27.029Z | 2024-09-16T12:17:03.927Z |
5083771 | 5083771 | 20240912152410_pPE0D | AU000C | 2024-09-16T12:00:18.875Z | 2024-09-16T12:17:03.893Z |
5083761 | 5083761 | 20240912151420_rAlW9 | AU000C | 2024-09-16T12:00:16.878Z | 2024-09-16T12:17:03.881Z |
5083716 | 5083716 | 20240911141343_7VExe | AU000C | 2024-09-15T12:18:45.716Z | 2024-09-16T12:19:20.196Z |
5083662 | 5083662 | 20240911140823_lKAgz | AU000C | 2024-09-15T12:18:45.237Z | 2024-09-16T12:19:20.094Z |
5083528 | 5083528 | 20240911134127_kskys | AU000C | 2024-09-15T12:18:43.372Z | 2024-09-16T12:19:19.395Z |
5083505 | 5083505 | 20240911133557_IGHFd | AU000C | 2024-09-15T12:18:42.988Z | 2024-09-16T12:19:18.769Z |
5083500 | 5083500 | 20240911133327_bkovf | AU000C | 2024-09-15T12:18:42.754Z | 2024-09-16T12:19:18.723Z |
5083466 | 5083466 | 20240911132725_6Wjj0 | AU000C | 2024-09-15T12:18:42.319Z | 2024-09-16T12:19:18.593Z |
5083286 | 5083286 | 20240911124616_hojaY | AU000C | 2024-09-15T12:18:38.332Z | 2024-09-16T12:19:17.704Z |
5083236 | 5083236 | 20240911123425_wRdQG | AU000C | 2024-09-15T12:18:37.362Z | 2024-09-16T12:19:17.450Z |
5083051 | 5083051 | 20240911115215_0ylQq | AU000C | 2024-09-15T12:18:34.416Z | 2024-09-16T12:19:16.472Z |
5073065 | 5073065 | 20240911205732_EZKnM | AU000C | 2024-09-15T12:06:35.631Z | 2024-09-16T12:17:29.193Z |
5072689 | 5072689 | 20240911203709_g6z5a | AU000C | 2024-09-15T12:06:01.512Z | 2024-09-16T12:17:29.137Z |
5072510 | 5072510 | 20240911201651_qeq1i | AU000C | 2024-09-15T12:05:32.073Z | 2024-09-16T12:17:29.100Z |
5072446 | 5072446 | 20240911201014_KCKIr | AU000C | 2024-09-15T12:05:23.949Z | 2024-09-16T12:17:29.087Z |
5072169 | 5072169 | 20240911194308_2MSRa | AU000C | 2024-09-15T12:04:47.667Z | 2024-09-16T12:17:29.037Z |
5072132 | 5072132 | 20240911194036_KOQdj | AU000C | 2024-09-15T12:04:44.518Z | 2024-09-16T12:17:29.032Z |
5071928 | 5071928 | 20240911190525_kMko7 | AU000C | 2024-09-15T12:04:02.965Z | 2024-09-16T12:17:28.981Z |
5071904 | 5071904 | 20240911185538_y96Mm | AU000C | 2024-09-15T12:03:59.416Z | 2024-09-16T12:17:28.975Z |
5071871 | 5071871 | 20240911184319_UrEWV | AU000C | 2024-09-15T12:03:53.782Z | 2024-09-16T12:17:28.964Z |
5071816 | 5071816 | 20240911182804_xhcYX | AU000C | 2024-09-15T12:03:45.757Z | 2024-09-16T12:17:28.949Z |
5071793 | 5071793 | 20240911182028_O6N4f | AU000C | 2024-09-15T12:03:34.721Z | 2024-09-16T12:17:28.943Z |
5071754 | 5071754 | 20240911181042_3mrFf | AU000C | 2024-09-15T12:03:25.397Z | 2024-09-16T12:17:28.921Z |
5071717 | 5071717 | 20240911175825_rcZj7 | AU000C | 2024-09-15T12:03:19.494Z | 2024-09-16T12:17:28.912Z |
5071706 | 5071706 | 20240911175550_7G3Ph | AU000C | 2024-09-15T12:03:17.787Z | 2024-09-16T12:17:28.909Z |
5071661 | 5071661 | 20240911174044_rT7en | AU000C | 2024-09-15T12:03:11.985Z | 2024-09-16T12:17:28.890Z |
5071659 | 5071659 | 20240911173828_Z2D4i | AU000C | 2024-09-15T12:03:11.609Z | 2024-09-16T12:17:28.890Z |
5071582 | 5071582 | 20240911172148_834dl | AU000C | 2024-09-15T12:03:00.983Z | 2024-09-16T12:17:28.869Z |
5071536 | 5071536 | 20240911171231_hgPDt | AU000C | 2024-09-15T12:02:51.383Z | 2024-09-16T12:17:28.857Z |
5071533 | 5071533 | 20240911171221_sgk97 | AU000C | 2024-09-15T12:02:50.522Z | 2024-09-16T12:17:28.856Z |
5071513 | 5071513 | 20240911171016_7piOx | AU000C | 2024-09-15T12:02:45.870Z | 2024-09-16T12:17:28.851Z |
5071486 | 5071486 | 20240911170219_oYtUM | AU000C | 2024-09-15T12:02:39.761Z | 2024-09-16T12:17:28.843Z |
5071392 | 5071392 | 20240911164529_E2Iwb | AU000C | 2024-09-15T12:02:26.678Z | 2024-09-16T12:17:28.800Z |
5071364 | 5071364 | 20240911163938_m4Ks9 | AU000C | 2024-09-15T12:02:22.762Z | 2024-09-16T12:17:28.793Z |
5071199 | 5071199 | 20240911161519_UXxDL | AU000C | 2024-09-15T12:01:53.106Z | 2024-09-16T12:17:28.756Z |
5071071 | 5071071 | 20240911155548_5tDCA | AU000C | 2024-09-15T12:01:35.693Z | 2024-09-16T12:17:28.726Z |
5070949 | 5070949 | 20240911153405_3Kgmy | AU000C | 2024-09-15T12:01:13.264Z | 2024-09-16T12:17:28.698Z |
5070932 | 5070932 | 20240911152941_rKgLO | AU000C | 2024-09-15T12:01:10.966Z | 2024-09-16T12:17:28.693Z |
5070876 | 5070876 | 20240911152217_5Bl28 | AU000C | 2024-09-15T12:01:02.804Z | 2024-09-16T12:17:28.679Z |
5070833 | 5070833 | 20240911151500_U5dvy | AU000C | 2024-09-15T12:00:58.606Z | 2024-09-16T12:17:28.673Z |
5070719 | 5070719 | 20240911150031_3taTY | AU000C | 2024-09-15T12:00:41.916Z | 2024-09-16T12:17:28.653Z |
5070599 | 5070599 | 20240911143807_3rTda | AU000C | 2024-09-15T12:00:23.308Z | 2024-09-16T12:17:28.626Z |
5070561 | 5070561 | 20240911143206_o0yxp | AU000C | 2024-09-15T12:00:19.312Z | 2024-09-16T12:17:28.618Z |
5070458 | 5070458 | 20240909125625_LY2nj | AU000C | 2024-09-14T12:21:21.950Z | 2024-09-16T12:20:45.815Z |
5068811 | 5068811 | 20240910123115_FYJp7 | AU000C | 2024-09-14T12:19:21.689Z | 2024-09-16T12:20:15.364Z |
5068794 | 5068794 | 20240910122623_wC8at | AU000C | 2024-09-14T12:19:21.542Z | 2024-09-16T12:20:15.221Z |
5068659 | 5068659 | 20240910120106_jeBP8 | AU000C | 2024-09-14T12:19:20.070Z | 2024-09-16T12:20:14.583Z |
5068642 | 5068642 | 20240910115719_E28iF | AU000C | 2024-09-14T12:19:19.821Z | 2024-09-16T12:20:14.529Z |
5062757 | 5062757 | 20240909181646_hC2bX | AU000C | 2024-09-14T12:12:47.520Z | 2024-09-16T12:19:39.265Z |
5062629 | 5062629 | 20240909175102_mY1e4 | AU000C | 2024-09-14T12:12:38.710Z | 2024-09-16T12:19:38.238Z |
5062533 | 5062533 | 20240909173749_jxF6p | AU000C | 2024-09-14T12:12:31.448Z | 2024-09-16T12:19:37.676Z |
5062493 | 5062493 | 20240909173318_69OmM | AU000C | 2024-09-14T12:12:27.887Z | 2024-09-16T12:19:37.552Z |
5062298 | 5062298 | 20240909170829_XqGe2 | AU000C | 2024-09-14T12:12:07.514Z | 2024-09-16T12:19:36.903Z |
5062295 | 5062295 | 20240909170741_2Iun0 | AU000C | 2024-09-14T12:12:07.371Z | 2024-09-16T12:19:36.902Z |
5062291 | 5062291 | 20240909170732_NuXfE | AU000C | 2024-09-14T12:12:06.674Z | 2024-09-16T12:19:36.884Z |
5062209 | 5062209 | 20240909165728_2lyZU | AU000C | 2024-09-14T12:11:55.690Z | 2024-09-16T12:19:36.400Z |
5062126 | 5062126 | 20240909164549_KjJB1 | AU000C | 2024-09-14T12:11:50.508Z | 2024-09-16T12:19:35.839Z |
5062059 | 5062059 | 20240909164054_4Bh2l | AU000C | 2024-09-14T12:11:47.330Z | 2024-09-16T12:19:35.397Z |
Advanced export
JSON shape: default, array, newline-delimited
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);