participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,111 rows where station_code = "AU0036" 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 |
---|---|---|---|---|---|
5097008 | 5097008 | 20240912133508_HzBfY | AU0036 | 2024-09-16T12:16:42.012Z | 2024-09-16T12:17:31.995Z |
5096896 | 5096896 | 20240912120720_jRLo3 | AU0036 | 2024-09-16T12:16:36.894Z | 2024-09-16T12:17:31.952Z |
5096644 | 5096644 | 20240912112654_at913 | AU0036 | 2024-09-16T12:16:30.750Z | 2024-09-16T12:17:31.836Z |
5084931 | 5084931 | 20240912203252_PNAqe | AU0036 | 2024-09-16T12:03:13.864Z | 2024-09-16T12:17:04.525Z |
5084886 | 5084886 | 20240912203049_4Kp2N | AU0036 | 2024-09-16T12:03:08.903Z | 2024-09-16T12:17:04.513Z |
5084685 | 5084685 | 20240912200510_A3Xvl | AU0036 | 2024-09-16T12:02:47.432Z | 2024-09-16T12:17:04.421Z |
5084636 | 5084636 | 20240912195930_xZ0Iw | AU0036 | 2024-09-16T12:02:41.319Z | 2024-09-16T12:17:04.397Z |
5084472 | 5084472 | 20240912194106_8UC4E | AU0036 | 2024-09-16T12:02:07.373Z | 2024-09-16T12:17:04.318Z |
5084424 | 5084424 | 20240912193724_URGj5 | AU0036 | 2024-09-16T12:02:03.961Z | 2024-09-16T12:17:04.304Z |
5084133 | 5084133 | 20240912182353_VtHzr | AU0036 | 2024-09-16T12:01:14.154Z | 2024-09-16T12:17:04.113Z |
5084097 | 5084097 | 20240912180710_sjYTS | AU0036 | 2024-09-16T12:01:08.745Z | 2024-09-16T12:17:04.093Z |
5083793 | 5083793 | 20240912154109_bCmUC | AU0036 | 2024-09-16T12:00:23.177Z | 2024-09-16T12:17:03.911Z |
5083588 | 5083588 | 20240911135400_o04db | AU0036 | 2024-09-15T12:18:44.245Z | 2024-09-16T12:19:19.680Z |
5083430 | 5083430 | 20240911131704_tBfok | AU0036 | 2024-09-15T12:18:41.907Z | 2024-09-16T12:19:18.536Z |
5083375 | 5083375 | 20240911130557_pKN8F | AU0036 | 2024-09-15T12:18:40.507Z | 2024-09-16T12:19:18.152Z |
5073403 | 5073403 | 20240911212005_6V2Mj | AU0036 | 2024-09-15T12:07:07.925Z | 2024-09-16T12:17:29.241Z |
5073299 | 5073299 | 20240911211347_3zjl2 | AU0036 | 2024-09-15T12:07:01.813Z | 2024-09-16T12:17:29.227Z |
5072409 | 5072409 | 20240911200406_CWrtR | AU0036 | 2024-09-15T12:05:19.082Z | 2024-09-16T12:17:29.077Z |
5072336 | 5072336 | 20240911195620_mcVoc | AU0036 | 2024-09-15T12:05:11.563Z | 2024-09-16T12:17:29.063Z |
5072213 | 5072213 | 20240911194901_zvwlw | AU0036 | 2024-09-15T12:04:55.245Z | 2024-09-16T12:17:29.048Z |
5072194 | 5072194 | 20240911194706_AIkJZ | AU0036 | 2024-09-15T12:04:52.089Z | 2024-09-16T12:17:29.044Z |
5072003 | 5072003 | 20240911191940_dAv3R | AU0036 | 2024-09-15T12:04:17.064Z | 2024-09-16T12:17:29.000Z |
5071982 | 5071982 | 20240911191638_3Ad8l | AU0036 | 2024-09-15T12:04:11.616Z | 2024-09-16T12:17:28.995Z |
5071933 | 5071933 | 20240911190611_9tT8H | AU0036 | 2024-09-15T12:04:03.854Z | 2024-09-16T12:17:28.983Z |
5071908 | 5071908 | 20240911185603_KmTlc | AU0036 | 2024-09-15T12:03:59.720Z | 2024-09-16T12:17:28.975Z |
5071861 | 5071861 | 20240911183921_CeDK2 | AU0036 | 2024-09-15T12:03:52.109Z | 2024-09-16T12:17:28.961Z |
5071802 | 5071802 | 20240911182338_nZwxl | AU0036 | 2024-09-15T12:03:38.759Z | 2024-09-16T12:17:28.945Z |
5070952 | 5070952 | 20240911153415_iFdb5 | AU0036 | 2024-09-15T12:01:13.620Z | 2024-09-16T12:17:28.699Z |
5070837 | 5070837 | 20240911151520_9JvHv | AU0036 | 2024-09-15T12:00:59.123Z | 2024-09-16T12:17:28.674Z |
5070441 | 5070441 | 20240909120126_2HDbG | AU0036 | 2024-09-14T12:21:21.229Z | 2024-09-16T12:20:44.853Z |
5063443 | 5063443 | 20240909211455_0IcQn | AU0036 | 2024-09-14T12:14:00.059Z | 2024-09-16T12:19:43.874Z |
5063274 | 5063274 | 20240909203527_AJOG5 | AU0036 | 2024-09-14T12:13:48.467Z | 2024-09-16T12:19:42.947Z |
5063210 | 5063210 | 20240909201743_3Dn2T | AU0036 | 2024-09-14T12:13:42.105Z | 2024-09-16T12:19:42.688Z |
5062499 | 5062499 | 20240909173407_65RMG | AU0036 | 2024-09-14T12:12:28.290Z | 2024-09-16T12:19:37.568Z |
5062486 | 5062486 | 20240909173120_hSDBU | AU0036 | 2024-09-14T12:12:27.474Z | 2024-09-16T12:19:37.539Z |
5062006 | 5062006 | 20240909163252_6kC0H | AU0036 | 2024-09-14T12:11:44.188Z | 2024-09-16T12:19:35.061Z |
5061402 | 5061402 | 20240909150225_MF2uU | AU0036 | 2024-09-14T12:10:46.889Z | 2024-09-16T12:19:31.357Z |
5060504 | 5060504 | 20240910203402_kJxCm | AU0036 | 2024-09-14T12:08:54.256Z | 2024-09-16T12:18:16.161Z |
5060036 | 5060036 | 20240910193804_q2sRp | AU0036 | 2024-09-14T12:08:01.212Z | 2024-09-16T12:18:11.703Z |
5060007 | 5060007 | 20240910193031_kSU6h | AU0036 | 2024-09-14T12:07:56.787Z | 2024-09-16T12:18:11.381Z |
5059974 | 5059974 | 20240910192632_Tfim2 | AU0036 | 2024-09-14T12:07:52.212Z | 2024-09-16T12:18:10.547Z |
5059888 | 5059888 | 20240910191434_YS6Bp | AU0036 | 2024-09-14T12:07:33.392Z | 2024-09-16T12:18:09.858Z |
5059760 | 5059760 | 20240910184524_hXdPj | AU0036 | 2024-09-14T12:07:08.109Z | 2024-09-16T12:18:08.255Z |
5059743 | 5059743 | 20240910184149_Fz02G | AU0036 | 2024-09-14T12:06:57.986Z | 2024-09-16T12:18:08.018Z |
5059496 | 5059496 | 20240910175238_ntJIt | AU0036 | 2024-09-14T12:06:13.996Z | 2024-09-16T12:18:05.403Z |
5059445 | 5059445 | 20240910174408_EmVJa | AU0036 | 2024-09-14T12:06:06.115Z | 2024-09-16T12:18:05.019Z |
5059341 | 5059341 | 20240910173257_MwzLI | AU0036 | 2024-09-14T12:05:47.030Z | 2024-09-16T12:18:04.050Z |
5058976 | 5058976 | 20240910170544_2rHIr | AU0036 | 2024-09-14T12:05:03.228Z | 2024-09-16T12:18:00.142Z |
5058858 | 5058858 | 20240910165302_IfFln | AU0036 | 2024-09-14T12:04:39.972Z | 2024-09-16T12:17:59.070Z |
5058817 | 5058817 | 20240910164949_933aX | AU0036 | 2024-09-14T12:04:35.831Z | 2024-09-16T12:17:58.612Z |
5058123 | 5058123 | 20240910154655_k4g5e | AU0036 | 2024-09-14T12:03:00.096Z | 2024-09-16T12:17:50.294Z |
4418836 | 4418836 | 20240531210027_2zN7r | AU0036 | 2024-06-06T12:13:08.605Z | 2024-06-09T12:06:00.405Z |
4418833 | 4418833 | 20240531204152_gZYL0 | AU0036 | 2024-06-06T12:13:08.137Z | 2024-06-09T12:06:00.337Z |
4418832 | 4418832 | 20240531202512_Mg2Ny | AU0036 | 2024-06-06T12:13:07.768Z | 2024-06-09T12:06:00.306Z |
4418829 | 4418829 | 20240531202447_wHROx | AU0036 | 2024-06-06T12:13:07.763Z | 2024-06-09T12:06:00.298Z |
4418828 | 4418828 | 20240531200224_lSugp | AU0036 | 2024-06-06T12:13:07.511Z | 2024-06-09T12:06:00.275Z |
4418824 | 4418824 | 20240531200045_iWhsW | AU0036 | 2024-06-06T12:13:07.465Z | 2024-06-09T12:06:00.264Z |
4418822 | 4418822 | 20240531195147_1Ynhw | AU0036 | 2024-06-06T12:13:07.293Z | 2024-06-09T12:06:00.224Z |
4418821 | 4418821 | 20240531194839_NQbQh | AU0036 | 2024-06-06T12:13:07.228Z | 2024-06-09T12:06:00.212Z |
4418818 | 4418818 | 20240531194440_IxWSB | AU0036 | 2024-06-06T12:13:07.203Z | 2024-06-09T12:06:00.207Z |
4418813 | 4418813 | 20240531183637_K7KAq | AU0036 | 2024-06-06T12:13:06.342Z | 2024-06-09T12:06:00.092Z |
4418812 | 4418812 | 20240531183039_2AUxf | AU0036 | 2024-06-06T12:13:06.253Z | 2024-06-09T12:06:00.089Z |
4418810 | 4418810 | 20240531181731_sLmaa | AU0036 | 2024-06-06T12:13:06.022Z | 2024-06-09T12:06:00.033Z |
4418808 | 4418808 | 20240531180956_jehm0 | AU0036 | 2024-06-06T12:13:05.718Z | 2024-06-09T12:05:59.996Z |
4418806 | 4418806 | 20240531175811_T6eR6 | AU0036 | 2024-06-06T12:13:05.428Z | 2024-06-09T12:05:59.945Z |
4418804 | 4418804 | 20240531174945_Hbh9j | AU0036 | 2024-06-06T12:13:05.120Z | 2024-06-09T12:05:59.884Z |
4418801 | 4418801 | 20240531173157_H8B7X | AU0036 | 2024-06-06T12:13:04.561Z | 2024-06-09T12:05:59.822Z |
4418792 | 4418792 | 20240531153623_GyLGM | AU0036 | 2024-06-06T12:12:59.724Z | 2024-06-09T12:05:59.333Z |
4418790 | 4418790 | 20240531152730_UEFuo | AU0036 | 2024-06-06T12:12:59.549Z | 2024-06-09T12:05:59.304Z |
4418788 | 4418788 | 20240531150608_2ZDop | AU0036 | 2024-06-06T12:12:58.766Z | 2024-06-09T12:05:59.190Z |
4418786 | 4418786 | 20240531144327_rM1WB | AU0036 | 2024-06-06T12:12:57.989Z | 2024-06-09T12:05:59.086Z |
4418784 | 4418784 | 20240531135613_HINM6 | AU0036 | 2024-06-06T12:12:56.582Z | 2024-06-09T12:05:58.955Z |
4418782 | 4418782 | 20240531134749_Ab38T | AU0036 | 2024-06-06T12:12:55.864Z | 2024-06-09T12:05:58.906Z |
4418779 | 4418779 | 20240531122337_Lz69O | AU0036 | 2024-06-06T12:12:53.426Z | 2024-06-09T12:05:58.518Z |
4418778 | 4418778 | 20240531113154_u4GnG | AU0036 | 2024-06-06T12:12:51.402Z | 2024-06-09T12:05:58.382Z |
4418764 | 4418764 | 20240601102509_fYUmf | AU0036 | 2024-06-06T12:11:50.688Z | 2024-06-10T12:06:43.994Z |
4418744 | 4418744 | 20240602203848_lG0NT | AU0036 | 2024-06-06T12:11:14.151Z | 2024-06-11T12:13:32.564Z |
4418742 | 4418742 | 20240602202529_SmbzJ | AU0036 | 2024-06-06T12:11:13.859Z | 2024-06-11T12:13:32.497Z |
4418740 | 4418740 | 20240602201359_LHIRa | AU0036 | 2024-06-06T12:11:13.509Z | 2024-06-11T12:13:32.438Z |
4418738 | 4418738 | 20240602200833_Oir2i | AU0036 | 2024-06-06T12:11:13.281Z | 2024-06-11T12:13:32.426Z |
4418737 | 4418737 | 20240602191130_BnTNA | AU0036 | 2024-06-06T12:11:12.721Z | 2024-06-11T12:13:32.341Z |
4418734 | 4418734 | 20240602185724_JezcK | AU0036 | 2024-06-06T12:11:12.286Z | 2024-06-11T12:13:32.197Z |
4418730 | 4418730 | 20240602184612_KAZaP | AU0036 | 2024-06-06T12:11:11.871Z | 2024-06-11T12:13:32.103Z |
4418729 | 4418729 | 20240602184150_3qzkl | AU0036 | 2024-06-06T12:11:11.568Z | 2024-06-11T12:13:32.042Z |
4418726 | 4418726 | 20240602183620_7PusF | AU0036 | 2024-06-06T12:11:11.265Z | 2024-06-11T12:13:31.969Z |
4418723 | 4418723 | 20240602180844_lnqzL | AU0036 | 2024-06-06T12:11:10.326Z | 2024-06-11T12:13:31.776Z |
4418718 | 4418718 | 20240602175822_y5Sgx | AU0036 | 2024-06-06T12:11:09.632Z | 2024-06-11T12:13:31.527Z |
4418716 | 4418716 | 20240602173030_3nQ1U | AU0036 | 2024-06-06T12:11:08.533Z | 2024-06-11T12:13:31.198Z |
4418714 | 4418714 | 20240602161351_c2qJ4 | AU0036 | 2024-06-06T12:11:05.002Z | 2024-06-11T12:13:30.386Z |
4418712 | 4418712 | 20240602160858_zIFeb | AU0036 | 2024-06-06T12:11:04.702Z | 2024-06-11T12:13:30.116Z |
4418710 | 4418710 | 20240602160835_SbZan | AU0036 | 2024-06-06T12:11:04.625Z | 2024-06-11T12:13:30.107Z |
4418706 | 4418706 | 20240602155717_BNAFq | AU0036 | 2024-06-06T12:11:04.141Z | 2024-06-11T12:13:30.002Z |
4418701 | 4418701 | 20240602141740_Ua7IZ | AU0036 | 2024-06-06T12:10:57.310Z | 2024-06-11T12:13:29.221Z |
4418687 | 4418687 | 20240602125617_PkRao | AU0036 | 2024-06-06T12:10:50.722Z | 2024-06-11T12:13:28.379Z |
4418684 | 4418684 | 20240602121851_kzJNi | AU0036 | 2024-06-06T12:10:48.086Z | 2024-06-11T12:13:28.109Z |
4418680 | 4418680 | 20240602112413_Z2eLm | AU0036 | 2024-06-06T12:10:44.713Z | 2024-06-11T12:13:27.571Z |
4416840 | 4416840 | 20240603185814_GyR1f | AU0036 | 2024-06-06T12:08:22.688Z | 2024-06-12T12:10:36.967Z |
4416804 | 4416804 | 20240603172128_o2Av9 | AU0036 | 2024-06-06T12:08:12.443Z | 2024-06-12T12:10:34.858Z |
4416777 | 4416777 | 20240603161600_p3rrt | AU0036 | 2024-06-06T12:08:01.137Z | 2024-06-12T12:10:33.920Z |
4416775 | 4416775 | 20240603161136_NiANM | AU0036 | 2024-06-06T12:07:59.002Z | 2024-06-12T12:10:33.842Z |
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);