participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,209 rows where station_code = "AU000A" 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 |
---|---|---|---|---|---|
5560119 | 5560119 | 20241120120408_u1opg | AU000A | 2024-11-21T14:08:05.252Z | 2024-11-21T14:08:05.252Z |
5552385 | 5552385 | 20241117122233_EPLh0 | AU000A | 2024-11-19T14:07:33.840Z | 2024-11-21T14:21:24.631Z |
5547729 | 5547729 | 20241117192432_CTQ20 | AU000A | 2024-11-18T14:06:24.112Z | 2024-11-21T14:21:51.379Z |
5544889 | 5544889 | 20241116192502_aFACI | AU000A | 2024-11-17T14:02:24.574Z | 2024-11-21T14:22:46.483Z |
5544842 | 5544842 | 20241116171438_jQrVR | AU000A | 2024-11-17T14:02:16.898Z | 2024-11-21T14:22:42.548Z |
5544592 | 5544592 | 20241116124727_8egyd | AU000A | 2024-11-17T14:01:37.996Z | 2024-11-21T14:22:37.337Z |
5544504 | 5544504 | 20241116115742_vokBM | AU000A | 2024-11-17T14:01:19.944Z | 2024-11-21T14:22:35.184Z |
5541149 | 5541149 | 20241114200917_KtqM5 | AU000A | 2024-11-15T14:05:13.657Z | 2024-11-21T14:24:22.976Z |
5537036 | 5537036 | 20241112200942_aaoDQ | AU000A | 2024-11-14T14:10:53.276Z | 2024-11-21T14:26:08.436Z |
5536927 | 5536927 | 20241112194157_oYkvl | AU000A | 2024-11-14T14:10:43.112Z | 2024-11-21T14:26:07.209Z |
5536903 | 5536903 | 20241112193818_OTF8f | AU000A | 2024-11-14T14:10:40.152Z | 2024-11-21T14:26:06.868Z |
5536897 | 5536897 | 20241112193752_kJOO4 | AU000A | 2024-11-14T14:10:39.905Z | 2024-11-21T14:26:06.855Z |
5536771 | 5536771 | 20241112190259_61Uld | AU000A | 2024-11-14T14:10:32.459Z | 2024-11-21T14:26:05.451Z |
5536768 | 5536768 | 20241112190246_oSXQ3 | AU000A | 2024-11-14T14:10:32.414Z | 2024-11-21T14:26:05.446Z |
5536700 | 5536700 | 20241112185509_ydu38 | AU000A | 2024-11-14T14:10:28.717Z | 2024-11-21T14:26:05.017Z |
5536678 | 5536678 | 20241112185132_ffgBV | AU000A | 2024-11-14T14:10:27.161Z | 2024-11-21T14:26:04.647Z |
5536451 | 5536451 | 20241112180658_T2qU3 | AU000A | 2024-11-14T14:09:59.511Z | 2024-11-21T14:26:01.053Z |
5536320 | 5536320 | 20241112172716_vT3VE | AU000A | 2024-11-14T14:09:36.990Z | 2024-11-21T14:26:00.033Z |
5536296 | 5536296 | 20241112171753_TKgH7 | AU000A | 2024-11-14T14:09:34.493Z | 2024-11-21T14:25:59.819Z |
5536218 | 5536218 | 20241112163455_4FL2j | AU000A | 2024-11-14T14:09:20.616Z | 2024-11-21T14:25:58.345Z |
5536183 | 5536183 | 20241112160719_BLmqY | AU000A | 2024-11-14T14:09:17.610Z | 2024-11-21T14:25:57.304Z |
5535977 | 5535977 | 20241112150920_ZdIJw | AU000A | 2024-11-14T14:09:03.695Z | 2024-11-21T14:25:55.690Z |
5535707 | 5535707 | 20241112135314_xbfbf | AU000A | 2024-11-14T14:08:28.484Z | 2024-11-21T14:25:51.532Z |
5535397 | 5535397 | 20241112122337_VeEfR | AU000A | 2024-11-14T14:07:53.523Z | 2024-11-21T14:25:47.311Z |
5534705 | 5534705 | 20241113163554_3kCCf | AU000A | 2024-11-14T14:05:02.862Z | 2024-11-21T14:25:06.780Z |
5528079 | 5528079 | 20241111192817_fzS4s | AU000A | 2024-11-13T14:09:47.937Z | 2024-11-20T14:25:24.813Z |
5527860 | 5527860 | 20241111184905_fUfWy | AU000A | 2024-11-13T14:09:28.082Z | 2024-11-20T14:25:22.324Z |
5527646 | 5527646 | 20241111180235_qHfiX | AU000A | 2024-11-13T14:08:50.795Z | 2024-11-20T14:25:15.949Z |
5527554 | 5527554 | 20241111173539_Yo463 | AU000A | 2024-11-13T14:08:39.283Z | 2024-11-20T14:25:13.769Z |
5527498 | 5527498 | 20241111171213_1SbCf | AU000A | 2024-11-13T14:08:23.436Z | 2024-11-20T14:25:12.716Z |
5527477 | 5527477 | 20241111170420_uyPZD | AU000A | 2024-11-13T14:08:20.918Z | 2024-11-20T14:25:11.908Z |
5527418 | 5527418 | 20241111163035_0HG6V | AU000A | 2024-11-13T14:08:11.680Z | 2024-11-20T14:25:10.633Z |
5527388 | 5527388 | 20241111160506_ciAbf | AU000A | 2024-11-13T14:08:08.451Z | 2024-11-20T14:25:10.170Z |
5527386 | 5527386 | 20241111160250_VgNd3 | AU000A | 2024-11-13T14:08:07.992Z | 2024-11-20T14:25:10.164Z |
5527296 | 5527296 | 20241111142002_G6xOH | AU000A | 2024-11-13T14:07:34.405Z | 2024-11-20T14:25:01.959Z |
5527277 | 5527277 | 20241111133553_6zCuo | AU000A | 2024-11-13T14:07:20.175Z | 2024-11-20T14:25:00.000Z |
5522446 | 5522446 | 20241110200356_5w7Lo | AU000A | 2024-11-12T14:13:17.084Z | 2024-11-19T14:22:02.109Z |
5522392 | 5522392 | 20241110195422_TiU0U | AU000A | 2024-11-12T14:13:10.383Z | 2024-11-19T14:22:01.264Z |
5522143 | 5522143 | 20241110191404_ml1o6 | AU000A | 2024-11-12T14:12:53.871Z | 2024-11-19T14:21:58.753Z |
5522049 | 5522049 | 20241110185530_Fmcbi | AU000A | 2024-11-12T14:12:35.904Z | 2024-11-19T14:21:57.457Z |
5521851 | 5521851 | 20241110182318_gpoPX | AU000A | 2024-11-12T14:12:04.080Z | 2024-11-19T14:21:55.543Z |
5521610 | 5521610 | 20241110174135_yJvK2 | AU000A | 2024-11-12T14:11:43.017Z | 2024-11-19T14:21:53.726Z |
5521607 | 5521607 | 20241110174120_WvKLO | AU000A | 2024-11-12T14:11:42.799Z | 2024-11-19T14:21:53.723Z |
5521188 | 5521188 | 20241110162204_SZDEy | AU000A | 2024-11-12T14:10:36.127Z | 2024-11-19T14:21:50.143Z |
5520983 | 5520983 | 20241110153953_a7K3k | AU000A | 2024-11-12T14:09:58.190Z | 2024-11-19T14:21:46.883Z |
5520976 | 5520976 | 20241110153849_t3nNU | AU000A | 2024-11-12T14:09:56.382Z | 2024-11-19T14:21:46.758Z |
5520914 | 5520914 | 20241110152223_3kMXU | AU000A | 2024-11-12T14:09:46.267Z | 2024-11-19T14:21:45.620Z |
5520612 | 5520612 | 20241110125224_0JQpY | AU000A | 2024-11-12T14:08:49.998Z | 2024-11-19T14:21:40.567Z |
5498008 | 5498008 | 20241103195006_Fj47m | AU000A | 2024-11-08T14:19:38.763Z | 2024-11-12T14:27:57.942Z |
5495473 | 5495473 | 20241106195847_E7XN3 | AU000A | 2024-11-08T14:10:16.711Z | 2024-11-15T14:24:49.800Z |
5495179 | 5495179 | 20241106185358_t6342 | AU000A | 2024-11-08T14:09:32.481Z | 2024-11-15T14:24:47.113Z |
5495171 | 5495171 | 20241106185221_EekoT | AU000A | 2024-11-08T14:09:31.388Z | 2024-11-15T14:24:47.079Z |
5495155 | 5495155 | 20241106185006_YN3aL | AU000A | 2024-11-08T14:09:26.254Z | 2024-11-15T14:24:46.878Z |
5495145 | 5495145 | 20241106185003_p2XBz | AU000A | 2024-11-08T14:09:25.620Z | 2024-11-15T14:24:46.875Z |
5495132 | 5495132 | 20241106184908_zevU9 | AU000A | 2024-11-08T14:09:24.178Z | 2024-11-15T14:24:46.810Z |
5495071 | 5495071 | 20241106183109_xtqrv | AU000A | 2024-11-08T14:09:13.251Z | 2024-11-15T14:24:46.069Z |
5494975 | 5494975 | 20241106180433_A4A7w | AU000A | 2024-11-08T14:08:54.746Z | 2024-11-15T14:24:45.064Z |
5494968 | 5494968 | 20241106180228_2veLT | AU000A | 2024-11-08T14:08:54.203Z | 2024-11-15T14:24:44.970Z |
5494783 | 5494783 | 20241106172105_iPt28 | AU000A | 2024-11-08T14:08:35.562Z | 2024-11-15T14:24:42.714Z |
5494765 | 5494765 | 20241106171444_hOpl6 | AU000A | 2024-11-08T14:08:34.129Z | 2024-11-15T14:24:42.548Z |
5494712 | 5494712 | 20241106165939_sxz3W | AU000A | 2024-11-08T14:08:25.011Z | 2024-11-15T14:24:41.561Z |
5494709 | 5494709 | 20241106165921_dZLDk | AU000A | 2024-11-08T14:08:24.919Z | 2024-11-15T14:24:41.550Z |
5494695 | 5494695 | 20241106165653_gzam7 | AU000A | 2024-11-08T14:08:22.423Z | 2024-11-15T14:24:41.442Z |
5494686 | 5494686 | 20241106165140_Nkne4 | AU000A | 2024-11-08T14:08:21.331Z | 2024-11-15T14:24:41.328Z |
5494627 | 5494627 | 20241106162515_YqMgK | AU000A | 2024-11-08T14:08:07.914Z | 2024-11-15T14:24:40.749Z |
5494566 | 5494566 | 20241106155550_GRkWp | AU000A | 2024-11-08T14:07:49.509Z | 2024-11-15T14:24:40.089Z |
5494503 | 5494503 | 20241106152448_93byi | AU000A | 2024-11-08T14:07:38.213Z | 2024-11-15T14:24:38.628Z |
5494432 | 5494432 | 20241106145354_2ElUi | AU000A | 2024-11-08T14:07:29.478Z | 2024-11-15T14:24:37.366Z |
5494417 | 5494417 | 20241106144612_TKRTP | AU000A | 2024-11-08T14:07:27.841Z | 2024-11-15T14:24:37.171Z |
5494408 | 5494408 | 20241106143824_DjzQc | AU000A | 2024-11-08T14:07:26.180Z | 2024-11-15T14:24:36.943Z |
5494332 | 5494332 | 20241106133900_yLFzN | AU000A | 2024-11-08T14:06:54.946Z | 2024-11-15T14:24:35.160Z |
5494315 | 5494315 | 20241106132632_eyjzR | AU000A | 2024-11-08T14:06:48.526Z | 2024-11-15T14:24:34.439Z |
5494306 | 5494306 | 20241106131603_a3PlM | AU000A | 2024-11-08T14:06:44.141Z | 2024-11-15T14:24:34.148Z |
5494230 | 5494230 | 20241106121713_wBEeF | AU000A | 2024-11-08T14:06:28.443Z | 2024-11-15T14:24:31.701Z |
5491998 | 5491998 | 20241104200716_QCvNF | AU000A | 2024-11-07T14:19:00.269Z | 2024-11-13T14:27:33.396Z |
5488546 | 5488546 | 20241105153903_ZpAJQ | AU000A | 2024-11-07T14:10:13.929Z | 2024-11-14T14:23:06.653Z |
5481886 | 5481886 | 20241104201019_t1wYH | AU000A | 2024-11-06T14:11:47.396Z | 2024-11-13T14:27:33.407Z |
5475335 | 5475335 | 20241103195019_leVNw | AU000A | 2024-11-05T14:13:11.250Z | 2024-11-12T14:27:57.945Z |
5475314 | 5475314 | 20241103194710_88Un0 | AU000A | 2024-11-05T14:13:09.044Z | 2024-11-12T14:27:57.920Z |
5475304 | 5475304 | 20241103194356_0Dwun | AU000A | 2024-11-05T14:13:08.092Z | 2024-11-12T14:27:57.913Z |
5475286 | 5475286 | 20241103194052_tpMpu | AU000A | 2024-11-05T14:13:03.473Z | 2024-11-12T14:27:57.891Z |
5474848 | 5474848 | 20241103182538_crw76 | AU000A | 2024-11-05T14:12:10.126Z | 2024-11-12T14:27:55.052Z |
5474807 | 5474807 | 20241103181947_5ifx8 | AU000A | 2024-11-05T14:12:06.366Z | 2024-11-12T14:27:54.815Z |
5474662 | 5474662 | 20241103175632_ryi21 | AU000A | 2024-11-05T14:11:31.246Z | 2024-11-12T14:27:53.791Z |
5474646 | 5474646 | 20241103175332_gNhRV | AU000A | 2024-11-05T14:11:29.293Z | 2024-11-12T14:27:53.713Z |
5474576 | 5474576 | 20241103174035_JiHrj | AU000A | 2024-11-05T14:11:18.511Z | 2024-11-12T14:27:53.208Z |
5474510 | 5474510 | 20241103173330_Bsw7E | AU000A | 2024-11-05T14:11:11.375Z | 2024-11-12T14:27:52.424Z |
5474386 | 5474386 | 20241103170849_TAHD9 | AU000A | 2024-11-05T14:11:01.343Z | 2024-11-12T14:27:51.184Z |
5474380 | 5474380 | 20241103170723_91VCt | AU000A | 2024-11-05T14:11:00.724Z | 2024-11-12T14:27:51.181Z |
5474207 | 5474207 | 20241103162610_K7y05 | AU000A | 2024-11-05T14:10:24.943Z | 2024-11-12T14:27:50.711Z |
5474184 | 5474184 | 20241103162043_Y3Rj7 | AU000A | 2024-11-05T14:10:21.125Z | 2024-11-12T14:27:50.678Z |
5474172 | 5474172 | 20241103161600_sTiep | AU000A | 2024-11-05T14:10:18.586Z | 2024-11-12T14:27:50.659Z |
5474118 | 5474118 | 20241103155748_Cuqj7 | AU000A | 2024-11-05T14:10:09.501Z | 2024-11-12T14:27:50.572Z |
5474103 | 5474103 | 20241103155233_svsIs | AU000A | 2024-11-05T14:10:08.631Z | 2024-11-12T14:27:50.566Z |
5474039 | 5474039 | 20241103154205_Ipn0O | AU000A | 2024-11-05T14:10:02.445Z | 2024-11-12T14:27:50.485Z |
5474033 | 5474033 | 20241103154140_ZL3Gw | AU000A | 2024-11-05T14:10:01.884Z | 2024-11-12T14:27:50.469Z |
5473962 | 5473962 | 20241103153039_uTPhD | AU000A | 2024-11-05T14:09:56.845Z | 2024-11-12T14:27:50.399Z |
5473862 | 5473862 | 20241103151257_jWjlC | AU000A | 2024-11-05T14:09:49.713Z | 2024-11-12T14:27:50.138Z |
5473664 | 5473664 | 20241103144712_a3vU6 | AU000A | 2024-11-05T14:09:21.480Z | 2024-11-12T14:27:49.869Z |
5473382 | 5473382 | 20241103140900_FoBji | AU000A | 2024-11-05T14:08:52.123Z | 2024-11-12T14:27:48.770Z |
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);