participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
9,309 rows where station_code = "AU001S" 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 |
---|---|---|---|---|---|
5097071 | 5097071 | 20240912141822_QMeS2 | AU001S | 2024-09-16T12:16:44.264Z | 2024-09-16T12:17:32.021Z |
5097060 | 5097060 | 20240912141013_9fIQt | AU001S | 2024-09-16T12:16:43.829Z | 2024-09-16T12:17:32.016Z |
5097052 | 5097052 | 20240912140533_ajyeC | AU001S | 2024-09-16T12:16:43.589Z | 2024-09-16T12:17:32.014Z |
5097038 | 5097038 | 20240912135933_aSbzR | AU001S | 2024-09-16T12:16:43.017Z | 2024-09-16T12:17:32.008Z |
5096962 | 5096962 | 20240912130152_Ww6wQ | AU001S | 2024-09-16T12:16:40.728Z | 2024-09-16T12:17:31.980Z |
5096632 | 5096632 | 20240912112542_A8ckb | AU001S | 2024-09-16T12:16:30.152Z | 2024-09-16T12:17:31.828Z |
5085361 | 5085361 | 20240912211411_kFIyT | AU001S | 2024-09-16T12:04:08.894Z | 2024-09-16T12:17:04.705Z |
5085308 | 5085308 | 20240912210727_Y0VLC | AU001S | 2024-09-16T12:03:55.452Z | 2024-09-16T12:17:04.681Z |
5085247 | 5085247 | 20240912210333_r14mY | AU001S | 2024-09-16T12:03:47.618Z | 2024-09-16T12:17:04.665Z |
5085185 | 5085185 | 20240912205545_c9soe | AU001S | 2024-09-16T12:03:40.149Z | 2024-09-16T12:17:04.633Z |
5085116 | 5085116 | 20240912204706_uaGmz | AU001S | 2024-09-16T12:03:33.804Z | 2024-09-16T12:17:04.594Z |
5084997 | 5084997 | 20240912203907_UEGCD | AU001S | 2024-09-16T12:03:23.803Z | 2024-09-16T12:17:04.547Z |
5084894 | 5084894 | 20240912203207_rR7u8 | AU001S | 2024-09-16T12:03:09.866Z | 2024-09-16T12:17:04.516Z |
5084825 | 5084825 | 20240912201654_S3ohr | AU001S | 2024-09-16T12:02:58.222Z | 2024-09-16T12:17:04.470Z |
5084698 | 5084698 | 20240912200733_kUBCF | AU001S | 2024-09-16T12:02:49.222Z | 2024-09-16T12:17:04.428Z |
5084552 | 5084552 | 20240912195009_HFQqx | AU001S | 2024-09-16T12:02:23.275Z | 2024-09-16T12:17:04.357Z |
5084382 | 5084382 | 20240912193155_hl8y6 | AU001S | 2024-09-16T12:01:59.656Z | 2024-09-16T12:17:04.277Z |
5084373 | 5084373 | 20240912193054_IRw8n | AU001S | 2024-09-16T12:01:59.119Z | 2024-09-16T12:17:04.274Z |
5084301 | 5084301 | 20240912191257_c3nql | AU001S | 2024-09-16T12:01:49.994Z | 2024-09-16T12:17:04.237Z |
5084287 | 5084287 | 20240912191017_vdDwD | AU001S | 2024-09-16T12:01:47.769Z | 2024-09-16T12:17:04.225Z |
5084208 | 5084208 | 20240912185826_U5au3 | AU001S | 2024-09-16T12:01:34.846Z | 2024-09-16T12:17:04.181Z |
5084190 | 5084190 | 20240912185316_27zLR | AU001S | 2024-09-16T12:01:30.009Z | 2024-09-16T12:17:04.167Z |
5084165 | 5084165 | 20240912184113_dhr17 | AU001S | 2024-09-16T12:01:21.913Z | 2024-09-16T12:17:04.148Z |
5084148 | 5084148 | 20240912183046_cB83S | AU001S | 2024-09-16T12:01:15.911Z | 2024-09-16T12:17:04.137Z |
5084131 | 5084131 | 20240912182254_oLYTG | AU001S | 2024-09-16T12:01:13.813Z | 2024-09-16T12:17:04.112Z |
5084126 | 5084126 | 20240912182026_qxoOd | AU001S | 2024-09-16T12:01:13.008Z | 2024-09-16T12:17:04.109Z |
5084064 | 5084064 | 20240912175742_SMXvy | AU001S | 2024-09-16T12:01:03.263Z | 2024-09-16T12:17:04.072Z |
5084031 | 5084031 | 20240912174201_MxCOS | AU001S | 2024-09-16T12:00:57.935Z | 2024-09-16T12:17:04.051Z |
5084012 | 5084012 | 20240912173702_dp4Rf | AU001S | 2024-09-16T12:00:55.183Z | 2024-09-16T12:17:04.034Z |
5083944 | 5083944 | 20240912170234_jgVWW | AU001S | 2024-09-16T12:00:42.309Z | 2024-09-16T12:17:03.994Z |
5083940 | 5083940 | 20240912170044_uxZ38 | AU001S | 2024-09-16T12:00:42.007Z | 2024-09-16T12:17:03.993Z |
5083903 | 5083903 | 20240912163924_V4IdR | AU001S | 2024-09-16T12:00:37.237Z | 2024-09-16T12:17:03.969Z |
5083883 | 5083883 | 20240912163212_wq7wq | AU001S | 2024-09-16T12:00:35.187Z | 2024-09-16T12:17:03.961Z |
5083858 | 5083858 | 20240912162001_i8vIP | AU001S | 2024-09-16T12:00:32.310Z | 2024-09-16T12:17:03.950Z |
5083847 | 5083847 | 20240912161316_E3YPl | AU001S | 2024-09-16T12:00:30.886Z | 2024-09-16T12:17:03.944Z |
5083746 | 5083746 | 20240911141908_6Us4N | AU001S | 2024-09-15T12:18:45.869Z | 2024-09-16T12:19:20.414Z |
5083736 | 5083736 | 20240911141456_QrJde | AU001S | 2024-09-15T12:18:45.863Z | 2024-09-16T12:19:20.411Z |
5083679 | 5083679 | 20240911141034_bxU4l | AU001S | 2024-09-15T12:18:45.468Z | 2024-09-16T12:19:20.124Z |
5083665 | 5083665 | 20240911140847_nzvPc | AU001S | 2024-09-15T12:18:45.276Z | 2024-09-16T12:19:20.095Z |
5083540 | 5083540 | 20240911134528_w1ZWs | AU001S | 2024-09-15T12:18:43.480Z | 2024-09-16T12:19:19.412Z |
5083307 | 5083307 | 20240911125158_cPR92 | AU001S | 2024-09-15T12:18:38.693Z | 2024-09-16T12:19:17.905Z |
5083110 | 5083110 | 20240911120545_IXKFN | AU001S | 2024-09-15T12:18:35.848Z | 2024-09-16T12:19:16.682Z |
5082899 | 5082899 | 20240911112347_Hm6Vo | AU001S | 2024-09-15T12:18:29.386Z | 2024-09-16T12:19:15.649Z |
5073417 | 5073417 | 20240911212015_LYdu3 | AU001S | 2024-09-15T12:07:09.149Z | 2024-09-16T12:17:29.243Z |
5073241 | 5073241 | 20240911210953_2U8nt | AU001S | 2024-09-15T12:06:57.266Z | 2024-09-16T12:17:29.218Z |
5073039 | 5073039 | 20240911205626_0zqhB | AU001S | 2024-09-15T12:06:32.016Z | 2024-09-16T12:17:29.191Z |
5073017 | 5073017 | 20240911205213_syV9q | AU001S | 2024-09-15T12:06:26.856Z | 2024-09-16T12:17:29.185Z |
5072980 | 5072980 | 20240911205059_bikva | AU001S | 2024-09-15T12:06:23.266Z | 2024-09-16T12:17:29.179Z |
5072938 | 5072938 | 20240911204821_FipKX | AU001S | 2024-09-15T12:06:19.885Z | 2024-09-16T12:17:29.172Z |
5072695 | 5072695 | 20240911203809_JF73a | AU001S | 2024-09-15T12:06:02.295Z | 2024-09-16T12:17:29.138Z |
5072623 | 5072623 | 20240911203009_bpZtL | AU001S | 2024-09-15T12:05:50.338Z | 2024-09-16T12:17:29.122Z |
5072588 | 5072588 | 20240911202526_5j23i | AU001S | 2024-09-15T12:05:40.757Z | 2024-09-16T12:17:29.113Z |
5072477 | 5072477 | 20240911201214_mPOOt | AU001S | 2024-09-15T12:05:27.832Z | 2024-09-16T12:17:29.093Z |
5072418 | 5072418 | 20240911200719_XI34e | AU001S | 2024-09-15T12:05:20.592Z | 2024-09-16T12:17:29.080Z |
5072376 | 5072376 | 20240911200117_gUtUI | AU001S | 2024-09-15T12:05:16.226Z | 2024-09-16T12:17:29.071Z |
5072352 | 5072352 | 20240911195756_gNSXj | AU001S | 2024-09-15T12:05:13.651Z | 2024-09-16T12:17:29.066Z |
5072346 | 5072346 | 20240911195626_GMT8x | AU001S | 2024-09-15T12:05:13.250Z | 2024-09-16T12:17:29.066Z |
5072284 | 5072284 | 20240911195355_0pLsz | AU001S | 2024-09-15T12:05:05.880Z | 2024-09-16T12:17:29.058Z |
5072186 | 5072186 | 20240911194609_BRkWO | AU001S | 2024-09-15T12:04:50.748Z | 2024-09-16T12:17:29.042Z |
5072058 | 5072058 | 20240911192716_h032W | AU001S | 2024-09-15T12:04:33.709Z | 2024-09-16T12:17:29.014Z |
5072035 | 5072035 | 20240911192506_FWBIm | AU001S | 2024-09-15T12:04:29.497Z | 2024-09-16T12:17:29.009Z |
5071998 | 5071998 | 20240911191810_AHhW2 | AU001S | 2024-09-15T12:04:16.109Z | 2024-09-16T12:17:29.000Z |
5071960 | 5071960 | 20240911191101_4WAuR | AU001S | 2024-09-15T12:04:08.241Z | 2024-09-16T12:17:28.990Z |
5071952 | 5071952 | 20240911191013_nl61n | AU001S | 2024-09-15T12:04:06.570Z | 2024-09-16T12:17:28.987Z |
5071940 | 5071940 | 20240911190748_VS4nD | AU001S | 2024-09-15T12:04:04.762Z | 2024-09-16T12:17:28.984Z |
5071927 | 5071927 | 20240911190419_cTkPd | AU001S | 2024-09-15T12:04:02.471Z | 2024-09-16T12:17:28.981Z |
5071922 | 5071922 | 20240911190406_5zNvX | AU001S | 2024-09-15T12:04:02.140Z | 2024-09-16T12:17:28.980Z |
5071910 | 5071910 | 20240911185656_xzs50 | AU001S | 2024-09-15T12:03:59.988Z | 2024-09-16T12:17:28.976Z |
5071902 | 5071902 | 20240911185536_3MEYT | AU001S | 2024-09-15T12:03:59.031Z | 2024-09-16T12:17:28.974Z |
5071879 | 5071879 | 20240911184651_q3IKM | AU001S | 2024-09-15T12:03:54.807Z | 2024-09-16T12:17:28.966Z |
5071874 | 5071874 | 20240911184531_YcRZB | AU001S | 2024-09-15T12:03:54.117Z | 2024-09-16T12:17:28.965Z |
5071868 | 5071868 | 20240911184228_0oEyt | AU001S | 2024-09-15T12:03:52.871Z | 2024-09-16T12:17:28.963Z |
5071850 | 5071850 | 20240911183443_qkZ1L | AU001S | 2024-09-15T12:03:50.095Z | 2024-09-16T12:17:28.957Z |
5071808 | 5071808 | 20240911182528_3K8kY | AU001S | 2024-09-15T12:03:41.922Z | 2024-09-16T12:17:28.947Z |
5071677 | 5071677 | 20240911174340_chVe9 | AU001S | 2024-09-15T12:03:13.401Z | 2024-09-16T12:17:28.893Z |
5071622 | 5071622 | 20240911173024_vzevG | AU001S | 2024-09-15T12:03:05.743Z | 2024-09-16T12:17:28.878Z |
5071590 | 5071590 | 20240911172303_WlNp0 | AU001S | 2024-09-15T12:03:01.751Z | 2024-09-16T12:17:28.870Z |
5071585 | 5071585 | 20240911172148_834dl | AU001S | 2024-09-15T12:03:00.983Z | 2024-09-16T12:17:28.869Z |
5071454 | 5071454 | 20240911165721_i7Mzw | AU001S | 2024-09-15T12:02:35.504Z | 2024-09-16T12:17:28.834Z |
5071411 | 5071411 | 20240911164804_qcCH1 | AU001S | 2024-09-15T12:02:29.163Z | 2024-09-16T12:17:28.804Z |
5071376 | 5071376 | 20240911164318_cZr4N | AU001S | 2024-09-15T12:02:23.986Z | 2024-09-16T12:17:28.795Z |
5071211 | 5071211 | 20240911161541_2Jhwb | AU001S | 2024-09-15T12:01:54.438Z | 2024-09-16T12:17:28.759Z |
5070935 | 5070935 | 20240911153030_VbZhE | AU001S | 2024-09-15T12:01:11.318Z | 2024-09-16T12:17:28.694Z |
5070835 | 5070835 | 20240911151500_U5dvy | AU001S | 2024-09-15T12:00:58.606Z | 2024-09-16T12:17:28.673Z |
5070660 | 5070660 | 20240911144609_lftT5 | AU001S | 2024-09-15T12:00:28.770Z | 2024-09-16T12:17:28.637Z |
5070536 | 5070536 | 20240911142817_GwMSl | AU001S | 2024-09-15T12:00:15.976Z | 2024-09-16T12:17:28.613Z |
5070514 | 5070514 | 20240911142625_HOhq7 | AU001S | 2024-09-15T12:00:11.775Z | 2024-09-16T12:17:28.609Z |
5069074 | 5069074 | 20240910134008_joohS | AU001S | 2024-09-14T12:19:25.193Z | 2024-09-16T12:20:16.381Z |
5069040 | 5069040 | 20240910132852_9lxMX | AU001S | 2024-09-14T12:19:24.456Z | 2024-09-16T12:20:16.221Z |
5068404 | 5068404 | 20240910112712_Dpnmo | AU001S | 2024-09-14T12:19:14.095Z | 2024-09-16T12:20:13.811Z |
5063197 | 5063197 | 20240909201630_3C2sT | AU001S | 2024-09-14T12:13:39.914Z | 2024-09-16T12:19:42.527Z |
5063191 | 5063191 | 20240909201403_w68FT | AU001S | 2024-09-14T12:13:39.212Z | 2024-09-16T12:19:42.524Z |
5063179 | 5063179 | 20240909201131_o2Jlx | AU001S | 2024-09-14T12:13:38.112Z | 2024-09-16T12:19:42.480Z |
5063107 | 5063107 | 20240909195354_2OyNS | AU001S | 2024-09-14T12:13:29.596Z | 2024-09-16T12:19:41.827Z |
5062996 | 5062996 | 20240909193157_XMCsD | AU001S | 2024-09-14T12:13:15.566Z | 2024-09-16T12:19:40.744Z |
5062966 | 5062966 | 20240909192301_DiN2X | AU001S | 2024-09-14T12:13:10.016Z | 2024-09-16T12:19:40.638Z |
5062847 | 5062847 | 20240909184050_fCRjV | AU001S | 2024-09-14T12:12:58.183Z | 2024-09-16T12:19:39.815Z |
5062839 | 5062839 | 20240909183803_ZpqTN | AU001S | 2024-09-14T12:12:56.779Z | 2024-09-16T12:19:39.792Z |
5062781 | 5062781 | 20240909182345_CORJ8 | AU001S | 2024-09-14T12:12:50.700Z | 2024-09-16T12:19:39.561Z |
5062769 | 5062769 | 20240909181857_KRv3j | AU001S | 2024-09-14T12:12:48.909Z | 2024-09-16T12:19:39.396Z |
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);