participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
667 rows where station_code = "AU0041" 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 |
---|---|---|---|---|---|
5068421 | 5068421 | 20240910112935_qohwe | AU0041 | 2024-09-14T12:19:15.033Z | 2024-09-16T12:20:13.880Z |
5067909 | 5067909 | 20240910102944_eSd4c | AU0041 | 2024-09-14T12:19:04.578Z | 2024-09-16T12:20:12.127Z |
5062905 | 5062905 | 20240909185705_4DGZl | AU0041 | 2024-09-14T12:13:01.970Z | 2024-09-16T12:19:40.202Z |
5062846 | 5062846 | 20240909184017_2r2D0 | AU0041 | 2024-09-14T12:12:58.006Z | 2024-09-16T12:19:39.813Z |
5062834 | 5062834 | 20240909183541_iIHvW | AU0041 | 2024-09-14T12:12:56.078Z | 2024-09-16T12:19:39.765Z |
5062695 | 5062695 | 20240909180146_UCkVS | AU0041 | 2024-09-14T12:12:43.544Z | 2024-09-16T12:19:38.811Z |
5062671 | 5062671 | 20240909175832_2fY8m | AU0041 | 2024-09-14T12:12:41.828Z | 2024-09-16T12:19:38.587Z |
5062175 | 5062175 | 20240909165410_A65oS | AU0041 | 2024-09-14T12:11:54.045Z | 2024-09-16T12:19:36.194Z |
5061714 | 5061714 | 20240909154646_408LH | AU0041 | 2024-09-14T12:11:14.720Z | 2024-09-16T12:19:33.229Z |
5061696 | 5061696 | 20240909154339_uVUke | AU0041 | 2024-09-14T12:11:12.598Z | 2024-09-16T12:19:33.190Z |
5061370 | 5061370 | 20240909145726_j1KSu | AU0041 | 2024-09-14T12:10:44.717Z | 2024-09-16T12:19:31.143Z |
5061276 | 5061276 | 20240909143942_XK3lD | AU0041 | 2024-09-14T12:10:39.547Z | 2024-09-16T12:19:30.257Z |
5061080 | 5061080 | 20240909140818_dJtao | AU0041 | 2024-09-14T12:10:14.402Z | 2024-09-16T12:19:28.995Z |
5061076 | 5061076 | 20240909140553_L5ECP | AU0041 | 2024-09-14T12:10:13.846Z | 2024-09-16T12:19:28.986Z |
5059516 | 5059516 | 20240910175704_T7k3S | AU0041 | 2024-09-14T12:06:15.546Z | 2024-09-16T12:18:05.607Z |
5059423 | 5059423 | 20240910174026_TGNpe | AU0041 | 2024-09-14T12:05:57.682Z | 2024-09-16T12:18:04.642Z |
5058778 | 5058778 | 20240910164552_SIb9p | AU0041 | 2024-09-14T12:04:31.013Z | 2024-09-16T12:17:57.785Z |
5058692 | 5058692 | 20240910163719_W1p2C | AU0041 | 2024-09-14T12:04:20.171Z | 2024-09-16T12:17:57.148Z |
5058227 | 5058227 | 20240910155538_6NrGr | AU0041 | 2024-09-14T12:03:11.970Z | 2024-09-16T12:17:51.813Z |
5057865 | 5057865 | 20240910152015_J1CE7 | AU0041 | 2024-09-14T12:02:16.520Z | 2024-09-16T12:17:48.057Z |
5057860 | 5057860 | 20240910151921_XQLqS | AU0041 | 2024-09-14T12:02:15.579Z | 2024-09-16T12:17:48.036Z |
5057848 | 5057848 | 20240910151845_f3YBr | AU0041 | 2024-09-14T12:02:14.009Z | 2024-09-16T12:17:47.991Z |
5051203 | 5051203 | 20240907165849_gP72f | AU0041 | 2024-09-13T12:14:06.018Z | 2024-09-16T12:20:59.798Z |
5050939 | 5050939 | 20240907162700_luSjp | AU0041 | 2024-09-13T12:13:54.229Z | 2024-09-16T12:20:59.355Z |
5050203 | 5050203 | 20240907144753_SkgGk | AU0041 | 2024-09-13T12:13:16.583Z | 2024-09-16T12:20:56.698Z |
5050067 | 5050067 | 20240909123835_iUozc | AU0041 | 2024-09-13T12:12:38.537Z | 2024-09-16T12:20:45.313Z |
5049638 | 5049638 | 20240909112459_2RzUt | AU0041 | 2024-09-13T12:12:21.407Z | 2024-09-16T12:20:43.611Z |
5043296 | 5043296 | 20240907142350_ElXZa | AU0041 | 2024-09-12T12:17:26.102Z | 2024-09-16T12:20:56.220Z |
5043209 | 5043209 | 20240907140725_2lFi2 | AU0041 | 2024-09-12T12:17:25.207Z | 2024-09-16T12:20:55.879Z |
5041968 | 5041968 | 20240906093344_r2Lcb | AU0041 | 2024-09-12T12:16:53.412Z | 2024-09-14T12:23:15.640Z |
5038305 | 5038305 | 20240905190748_J4rEg | AU0041 | 2024-09-12T12:14:32.289Z | 2024-09-14T12:22:55.550Z |
5037953 | 5037953 | 20240905170719_z2ZMG | AU0041 | 2024-09-12T12:14:17.948Z | 2024-09-14T12:22:54.837Z |
5037700 | 5037700 | 20240905164112_CfGxg | AU0041 | 2024-09-12T12:14:14.367Z | 2024-09-14T12:22:54.517Z |
5037039 | 5037039 | 20240905145657_JvpYn | AU0041 | 2024-09-12T12:13:59.490Z | 2024-09-14T12:22:53.644Z |
5036876 | 5036876 | 20240905143823_UQ42D | AU0041 | 2024-09-12T12:13:56.730Z | 2024-09-14T12:22:53.524Z |
5036639 | 5036639 | 20240905141215_tRhPC | AU0041 | 2024-09-12T12:13:51.040Z | 2024-09-14T12:22:53.075Z |
5036523 | 5036523 | 20240905134221_anacJ | AU0041 | 2024-09-12T12:13:45.501Z | 2024-09-14T12:22:52.529Z |
5035991 | 5035991 | 20240905122412_XaRqa | AU0041 | 2024-09-12T12:13:16.180Z | 2024-09-14T12:22:51.744Z |
5035979 | 5035979 | 20240905122005_223pk | AU0041 | 2024-09-12T12:13:15.469Z | 2024-09-14T12:22:51.692Z |
5035903 | 5035903 | 20240905120623_pTq1t | AU0041 | 2024-09-12T12:13:10.579Z | 2024-09-14T12:22:51.522Z |
5035753 | 5035753 | 20240907101619_nCyzY | AU0041 | 2024-09-12T12:12:26.592Z | 2024-09-15T12:21:41.092Z |
5030827 | 5030827 | 20240906185701_2Q1Me | AU0041 | 2024-09-12T12:03:10.735Z | 2024-09-15T12:21:19.968Z |
5030805 | 5030805 | 20240906184629_3w1dc | AU0041 | 2024-09-12T12:03:07.696Z | 2024-09-15T12:21:19.816Z |
5030793 | 5030793 | 20240906183845_3SePJ | AU0041 | 2024-09-12T12:03:05.642Z | 2024-09-15T12:21:19.733Z |
5030715 | 5030715 | 20240906175430_cvDUI | AU0041 | 2024-09-12T12:02:43.773Z | 2024-09-15T12:21:19.496Z |
5030685 | 5030685 | 20240906173608_PAfec | AU0041 | 2024-09-12T12:02:39.925Z | 2024-09-15T12:21:19.467Z |
5030451 | 5030451 | 20240906155006_bdaJL | AU0041 | 2024-09-12T12:01:59.851Z | 2024-09-15T12:21:18.588Z |
5030390 | 5030390 | 20240906151915_LB39X | AU0041 | 2024-09-12T12:01:51.088Z | 2024-09-15T12:21:18.522Z |
5030374 | 5030374 | 20240906151227_xfqeF | AU0041 | 2024-09-12T12:01:48.876Z | 2024-09-15T12:21:18.506Z |
5030250 | 5030250 | 20240906140137_Irlay | AU0041 | 2024-09-12T12:01:33.778Z | 2024-09-15T12:21:18.349Z |
5030173 | 5030173 | 20240906132514_fz0H9 | AU0041 | 2024-09-12T12:01:19.670Z | 2024-09-15T12:21:18.170Z |
5030154 | 5030154 | 20240906131639_Lc3S9 | AU0041 | 2024-09-12T12:01:16.749Z | 2024-09-15T12:21:18.155Z |
5029993 | 5029993 | 20240906120253_aVUDb | AU0041 | 2024-09-12T12:00:57.645Z | 2024-09-15T12:21:17.863Z |
5024064 | 5024064 | 20240905190748_dHPXs | AU0041 | 2024-09-11T12:02:30.004Z | 2024-09-11T12:16:31.917Z |
5023794 | 5023794 | 20240905170719_qLWam | AU0041 | 2024-09-10T12:16:50.291Z | 2024-09-11T12:16:31.789Z |
5023558 | 5023558 | 20240905164112_QoAy9 | AU0041 | 2024-09-10T12:16:47.750Z | 2024-09-11T12:16:31.705Z |
5018602 | 5018602 | 20240904190735_3TITx | AU0041 | 2024-09-10T12:10:58.268Z | 2024-09-13T12:19:48.279Z |
5018359 | 5018359 | 20240904174637_F5MZV | AU0041 | 2024-09-10T12:10:30.281Z | 2024-09-13T12:19:47.651Z |
5018174 | 5018174 | 20240904171902_azAge | AU0041 | 2024-09-10T12:10:06.342Z | 2024-09-13T12:19:47.348Z |
5017813 | 5017813 | 20240904164351_9tsGN | AU0041 | 2024-09-10T12:09:35.538Z | 2024-09-13T12:19:47.091Z |
5017417 | 5017417 | 20240904160708_qgVSu | AU0041 | 2024-09-10T12:09:09.443Z | 2024-09-13T12:19:46.868Z |
5017289 | 5017289 | 20240904155312_hwIlH | AU0041 | 2024-09-10T12:09:01.841Z | 2024-09-13T12:19:46.758Z |
5016353 | 5016353 | 20240904140352_Q3Gax | AU0041 | 2024-09-10T12:07:43.622Z | 2024-09-13T12:19:45.535Z |
5015801 | 5015801 | 20240904123731_CMdZL | AU0041 | 2024-09-10T12:06:47.401Z | 2024-09-13T12:19:44.662Z |
5015709 | 5015709 | 20240904121851_36odJ | AU0041 | 2024-09-10T12:06:40.374Z | 2024-09-13T12:19:44.611Z |
5015326 | 5015326 | 20240905145657_M2iAJ | AU0041 | 2024-09-10T12:04:59.226Z | 2024-09-11T12:16:31.454Z |
5015169 | 5015169 | 20240905143823_dB9kw | AU0041 | 2024-09-10T12:04:37.693Z | 2024-09-11T12:16:31.411Z |
5014961 | 5014961 | 20240905141215_ISw3V | AU0041 | 2024-09-10T12:04:20.270Z | 2024-09-11T12:16:31.340Z |
5014838 | 5014838 | 20240905134221_1vQae | AU0041 | 2024-09-10T12:03:57.844Z | 2024-09-11T12:16:31.297Z |
5014319 | 5014319 | 20240905122412_m466B | AU0041 | 2024-09-10T12:02:46.154Z | 2024-09-11T12:16:31.121Z |
5014307 | 5014307 | 20240905122005_BUm4K | AU0041 | 2024-09-10T12:02:44.833Z | 2024-09-11T12:16:31.113Z |
5006604 | 5006604 | 20240903180204_2LlrM | AU0041 | 2024-09-09T12:04:48.516Z | 2024-09-12T12:19:09.020Z |
5006364 | 5006364 | 20240903172939_hTpWH | AU0041 | 2024-09-09T12:04:32.787Z | 2024-09-12T12:19:08.211Z |
5006252 | 5006252 | 20240903170921_QszOY | AU0041 | 2024-09-09T12:04:26.691Z | 2024-09-12T12:19:08.031Z |
5006003 | 5006003 | 20240903164047_0PGhg | AU0041 | 2024-09-09T12:04:16.120Z | 2024-09-12T12:19:07.217Z |
5005592 | 5005592 | 20240903154050_A5Z7u | AU0041 | 2024-09-09T12:03:50.198Z | 2024-09-12T12:19:06.216Z |
5005556 | 5005556 | 20240903153324_Euv7e | AU0041 | 2024-09-09T12:03:48.561Z | 2024-09-12T12:19:06.162Z |
5005415 | 5005415 | 20240903150806_jf2cP | AU0041 | 2024-09-09T12:03:41.860Z | 2024-09-12T12:19:05.912Z |
5004956 | 5004956 | 20240903133916_PTZUf | AU0041 | 2024-09-09T12:03:13.761Z | 2024-09-12T12:19:04.611Z |
5003957 | 5003957 | 20240903101906_uLwPv | AU0041 | 2024-09-09T12:02:14.555Z | 2024-09-12T12:19:00.216Z |
5003585 | 5003585 | 20240903091811_0KdcA | AU0041 | 2024-09-09T12:01:52.793Z | 2024-09-12T12:18:57.991Z |
4996104 | 4996104 | 20240902184139_L3Vr3 | AU0041 | 2024-09-08T12:04:22.417Z | 2024-09-11T12:20:51.168Z |
4995766 | 4995766 | 20240902174914_6CvAZ | AU0041 | 2024-09-08T12:04:03.708Z | 2024-09-11T12:20:48.042Z |
4995587 | 4995587 | 20240902171942_q1ozE | AU0041 | 2024-09-08T12:03:47.931Z | 2024-09-11T12:20:46.667Z |
4995420 | 4995420 | 20240902165236_y8nbZ | AU0041 | 2024-09-08T12:03:38.493Z | 2024-09-11T12:20:45.261Z |
4995377 | 4995377 | 20240902164932_AsqQP | AU0041 | 2024-09-08T12:03:36.420Z | 2024-09-11T12:20:44.937Z |
4995194 | 4995194 | 20240902162627_yTATc | AU0041 | 2024-09-08T12:03:23.054Z | 2024-09-11T12:20:42.855Z |
4994951 | 4994951 | 20240902154033_p3YLA | AU0041 | 2024-09-08T12:03:07.670Z | 2024-09-11T12:20:40.622Z |
4994798 | 4994798 | 20240902151559_zLeRr | AU0041 | 2024-09-08T12:02:59.191Z | 2024-09-11T12:20:39.197Z |
4994559 | 4994559 | 20240902142718_Fx1sk | AU0041 | 2024-09-08T12:02:42.157Z | 2024-09-11T12:20:35.044Z |
4994353 | 4994353 | 20240902133726_2llDc | AU0041 | 2024-09-08T12:02:30.278Z | 2024-09-11T12:20:33.102Z |
4994268 | 4994268 | 20240902131238_mCMQ1 | AU0041 | 2024-09-08T12:02:23.743Z | 2024-09-11T12:20:32.176Z |
4993531 | 4993531 | 20240902104857_q4q43 | AU0041 | 2024-09-08T12:01:39.685Z | 2024-09-11T12:20:24.800Z |
4993244 | 4993244 | 20240902100423_P2w3f | AU0041 | 2024-09-08T12:01:20.140Z | 2024-09-11T12:20:21.434Z |
4987921 | 4987921 | 20240901191839_J3R1V | AU0041 | 2024-09-07T12:06:28.826Z | 2024-09-10T12:19:11.828Z |
4987855 | 4987855 | 20240901190744_aZ7YP | AU0041 | 2024-09-07T12:06:24.544Z | 2024-09-10T12:19:11.616Z |
4987806 | 4987806 | 20240901190002_IrgpG | AU0041 | 2024-09-07T12:06:20.168Z | 2024-09-10T12:19:11.435Z |
4987767 | 4987767 | 20240901185157_CvBlo | AU0041 | 2024-09-07T12:06:14.804Z | 2024-09-10T12:19:11.317Z |
4987713 | 4987713 | 20240901183811_ECH2w | AU0041 | 2024-09-07T12:06:09.068Z | 2024-09-10T12:19:11.194Z |
4987584 | 4987584 | 20240901180302_7Ia2a | AU0041 | 2024-09-07T12:05:57.830Z | 2024-09-10T12:19:11.003Z |
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);