participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,349,884 rows 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 |
---|---|---|---|---|---|
4349884 | 4349884 | 20240510122426_SrfCU | NZ004J | 2024-05-20T12:14:15.479Z | 2024-05-20T12:14:15.479Z |
4349883 | 4349883 | 20240510122426_SrfCU | NZ0041 | 2024-05-20T12:14:15.479Z | 2024-05-20T12:14:15.479Z |
4349882 | 4349882 | 20240510122426_SrfCU | NZ003W | 2024-05-20T12:14:15.479Z | 2024-05-20T12:14:15.479Z |
4349881 | 4349881 | 20240510122426_SrfCU | NZ003N | 2024-05-20T12:14:15.479Z | 2024-05-20T12:14:15.479Z |
4349880 | 4349880 | 20240510122426_SrfCU | NZ003H | 2024-05-20T12:14:15.479Z | 2024-05-20T12:14:15.479Z |
4349879 | 4349879 | 20240510122426_SrfCU | NZ003E | 2024-05-20T12:14:15.479Z | 2024-05-20T12:14:15.479Z |
4349878 | 4349878 | 20240510122426_SrfCU | NZ0033 | 2024-05-20T12:14:15.479Z | 2024-05-20T12:14:15.479Z |
4349877 | 4349877 | 20240510122426_SrfCU | NZ002H | 2024-05-20T12:14:15.479Z | 2024-05-20T12:14:15.479Z |
4349876 | 4349876 | 20240510122426_SrfCU | NZ001P | 2024-05-20T12:14:15.479Z | 2024-05-20T12:14:15.479Z |
4349875 | 4349875 | 20240510122426_SrfCU | NZ001H | 2024-05-20T12:14:15.479Z | 2024-05-20T12:14:15.479Z |
4349874 | 4349874 | 20240510122419_TtAFC | NZ002E | 2024-05-20T12:14:15.267Z | 2024-05-20T12:14:15.267Z |
4349873 | 4349873 | 20240510122419_TtAFC | NZ0029 | 2024-05-20T12:14:15.267Z | 2024-05-20T12:14:15.267Z |
4349872 | 4349872 | 20240510122419_TtAFC | NZ000V | 2024-05-20T12:14:15.267Z | 2024-05-20T12:14:15.267Z |
4349871 | 4349871 | 20240510122419_TtAFC | NZ000D | 2024-05-20T12:14:15.267Z | 2024-05-20T12:14:15.267Z |
4349870 | 4349870 | 20240510122131_voSg9 | NZ0034 | 2024-05-20T12:14:15.066Z | 2024-05-20T12:14:15.066Z |
4349869 | 4349869 | 20240510122131_voSg9 | NZ002S | 2024-05-20T12:14:15.066Z | 2024-05-20T12:14:15.066Z |
4349868 | 4349868 | 20240510121920_9VAO8 | NZ004J | 2024-05-20T12:14:14.675Z | 2024-05-20T12:14:14.675Z |
4349867 | 4349867 | 20240510121920_9VAO8 | NZ0041 | 2024-05-20T12:14:14.675Z | 2024-05-20T12:14:14.675Z |
4349866 | 4349866 | 20240510121920_9VAO8 | NZ003W | 2024-05-20T12:14:14.675Z | 2024-05-20T12:14:14.675Z |
4349865 | 4349865 | 20240510121920_9VAO8 | NZ003E | 2024-05-20T12:14:14.675Z | 2024-05-20T12:14:14.675Z |
4349864 | 4349864 | 20240510121920_9VAO8 | NZ002H | 2024-05-20T12:14:14.675Z | 2024-05-20T12:14:14.675Z |
4349863 | 4349863 | 20240510121920_9VAO8 | NZ001P | 2024-05-20T12:14:14.675Z | 2024-05-20T12:14:14.675Z |
4349862 | 4349862 | 20240510121920_9VAO8 | NZ001L | 2024-05-20T12:14:14.675Z | 2024-05-20T12:14:14.675Z |
4349861 | 4349861 | 20240510121920_9VAO8 | NZ001H | 2024-05-20T12:14:14.675Z | 2024-05-20T12:14:14.675Z |
4349860 | 4349860 | 20240510121920_9VAO8 | NZ001G | 2024-05-20T12:14:14.675Z | 2024-05-20T12:14:14.675Z |
4349859 | 4349859 | 20240510121808_hBLlL | KR002Z | 2024-05-20T12:14:14.254Z | 2024-05-20T12:14:14.254Z |
4349858 | 4349858 | 20240510121808_hBLlL | KR002S | 2024-05-20T12:14:14.254Z | 2024-05-20T12:14:14.254Z |
4349857 | 4349857 | 20240510121736_5rzeQ | NZ004N | 2024-05-20T12:14:12.660Z | 2024-05-20T12:14:12.660Z |
4349856 | 4349856 | 20240510121736_5rzeQ | NZ004L | 2024-05-20T12:14:12.660Z | 2024-05-20T12:14:12.660Z |
4349855 | 4349855 | 20240510121736_5rzeQ | NZ004J | 2024-05-20T12:14:12.660Z | 2024-05-20T12:14:12.660Z |
4349854 | 4349854 | 20240510121736_5rzeQ | NZ003N | 2024-05-20T12:14:12.660Z | 2024-05-20T12:14:12.660Z |
4349853 | 4349853 | 20240510121736_5rzeQ | NZ003E | 2024-05-20T12:14:12.660Z | 2024-05-20T12:14:12.660Z |
4349852 | 4349852 | 20240510121736_5rzeQ | NZ001P | 2024-05-20T12:14:12.660Z | 2024-05-20T12:14:12.660Z |
4349851 | 4349851 | 20240510121736_5rzeQ | NZ001H | 2024-05-20T12:14:12.660Z | 2024-05-20T12:14:12.660Z |
4349850 | 4349850 | 20240510121736_5rzeQ | NZ000Z | 2024-05-20T12:14:12.660Z | 2024-05-20T12:14:12.660Z |
4349849 | 4349849 | 20240510121552_Lbux7 | NZ004N | 2024-05-20T12:14:12.326Z | 2024-05-20T12:14:12.326Z |
4349848 | 4349848 | 20240510121552_Lbux7 | NZ004L | 2024-05-20T12:14:12.326Z | 2024-05-20T12:14:12.326Z |
4349847 | 4349847 | 20240510121552_Lbux7 | NZ004B | 2024-05-20T12:14:12.326Z | 2024-05-20T12:14:12.326Z |
4349846 | 4349846 | 20240510121552_Lbux7 | NZ0042 | 2024-05-20T12:14:12.326Z | 2024-05-20T12:14:12.326Z |
4349845 | 4349845 | 20240510121552_Lbux7 | NZ0040 | 2024-05-20T12:14:12.326Z | 2024-05-20T12:14:12.326Z |
4349844 | 4349844 | 20240510121552_Lbux7 | NZ003R | 2024-05-20T12:14:12.326Z | 2024-05-20T12:14:12.326Z |
4349843 | 4349843 | 20240510121552_Lbux7 | NZ003E | 2024-05-20T12:14:12.326Z | 2024-05-20T12:14:12.326Z |
4349842 | 4349842 | 20240510121552_Lbux7 | NZ002W | 2024-05-20T12:14:12.326Z | 2024-05-20T12:14:12.326Z |
4349841 | 4349841 | 20240510121552_Lbux7 | NZ002D | 2024-05-20T12:14:12.326Z | 2024-05-20T12:14:12.326Z |
4349840 | 4349840 | 20240510121552_Lbux7 | NZ0014 | 2024-05-20T12:14:12.326Z | 2024-05-20T12:14:12.326Z |
4349839 | 4349839 | 20240510121552_Lbux7 | NZ000Z | 2024-05-20T12:14:12.326Z | 2024-05-20T12:14:12.326Z |
4349838 | 4349838 | 20240510121537_uBj8x | NZ0046 | 2024-05-20T12:14:11.974Z | 2024-05-20T12:14:11.974Z |
4349837 | 4349837 | 20240510121537_uBj8x | NZ002S | 2024-05-20T12:14:11.974Z | 2024-05-20T12:14:11.974Z |
4349836 | 4349836 | 20240510121531_Rknrf | NZ004B | 2024-05-20T12:14:11.795Z | 2024-05-20T12:14:11.795Z |
4349835 | 4349835 | 20240510121531_Rknrf | NZ003A | 2024-05-20T12:14:11.795Z | 2024-05-20T12:14:11.795Z |
4349834 | 4349834 | 20240510121531_Rknrf | NZ0037 | 2024-05-20T12:14:11.795Z | 2024-05-20T12:14:11.795Z |
4349833 | 4349833 | 20240510121531_Rknrf | NZ002W | 2024-05-20T12:14:11.795Z | 2024-05-20T12:14:11.795Z |
4349832 | 4349832 | 20240510121531_Rknrf | NZ002P | 2024-05-20T12:14:11.795Z | 2024-05-20T12:14:11.795Z |
4349831 | 4349831 | 20240510121531_Rknrf | NZ002K | 2024-05-20T12:14:11.795Z | 2024-05-20T12:14:11.795Z |
4349830 | 4349830 | 20240510121531_Rknrf | NZ0017 | 2024-05-20T12:14:11.795Z | 2024-05-20T12:14:11.795Z |
4349829 | 4349829 | 20240510121439_i9bBf | NZ004L | 2024-05-20T12:14:11.440Z | 2024-05-20T12:14:11.440Z |
4349828 | 4349828 | 20240510121439_i9bBf | NZ003H | 2024-05-20T12:14:11.440Z | 2024-05-20T12:14:11.440Z |
4349827 | 4349827 | 20240510121414_SeNjH | NZ0041 | 2024-05-20T12:14:11.123Z | 2024-05-20T12:14:11.123Z |
4349826 | 4349826 | 20240510121414_SeNjH | NZ003H | 2024-05-20T12:14:11.123Z | 2024-05-20T12:14:11.123Z |
4349825 | 4349825 | 20240510121414_SeNjH | NZ003G | 2024-05-20T12:14:11.123Z | 2024-05-20T12:14:11.123Z |
4349824 | 4349824 | 20240510121414_SeNjH | NZ002S | 2024-05-20T12:14:11.123Z | 2024-05-20T12:14:11.123Z |
4349823 | 4349823 | 20240510121414_SeNjH | NZ0024 | 2024-05-20T12:14:11.123Z | 2024-05-20T12:14:11.123Z |
4349822 | 4349822 | 20240510121414_SeNjH | NZ0017 | 2024-05-20T12:14:11.123Z | 2024-05-20T12:14:11.123Z |
4349821 | 4349821 | 20240510121307_ebysV | NZ0049 | 2024-05-20T12:14:10.896Z | 2024-05-20T12:14:10.896Z |
4349820 | 4349820 | 20240510121307_ebysV | NZ0008 | 2024-05-20T12:14:10.896Z | 2024-05-20T12:14:10.896Z |
4349819 | 4349819 | 20240510121230_3eX3d | NZ004V | 2024-05-20T12:14:10.648Z | 2024-05-20T12:14:10.648Z |
4349818 | 4349818 | 20240510121230_3eX3d | NZ001X | 2024-05-20T12:14:10.638Z | 2024-05-20T12:14:10.638Z |
4349817 | 4349817 | 20240510121230_3eX3d | NZ000F | 2024-05-20T12:14:10.638Z | 2024-05-20T12:14:10.638Z |
4349816 | 4349816 | 20240510120907_P3vui | NZ0011 | 2024-05-20T12:14:10.389Z | 2024-05-20T12:14:10.389Z |
4349815 | 4349815 | 20240510120907_P3vui | NZ000S | 2024-05-20T12:14:10.389Z | 2024-05-20T12:14:10.389Z |
4349814 | 4349814 | 20240510120907_P3vui | NZ000D | 2024-05-20T12:14:10.389Z | 2024-05-20T12:14:10.389Z |
4349813 | 4349813 | 20240510120849_E1LTr | NZ0046 | 2024-05-20T12:14:09.882Z | 2024-05-20T12:14:09.882Z |
4349812 | 4349812 | 20240510120849_E1LTr | NZ0041 | 2024-05-20T12:14:09.882Z | 2024-05-20T12:14:09.882Z |
4349811 | 4349811 | 20240510120849_E1LTr | NZ003Q | 2024-05-20T12:14:09.882Z | 2024-05-20T12:14:09.882Z |
4349810 | 4349810 | 20240510120849_E1LTr | NZ003H | 2024-05-20T12:14:09.882Z | 2024-05-20T12:14:09.882Z |
4349809 | 4349809 | 20240510120849_E1LTr | NZ0036 | 2024-05-20T12:14:09.882Z | 2024-05-20T12:14:09.882Z |
4349808 | 4349808 | 20240510120849_E1LTr | NZ002H | 2024-05-20T12:14:09.882Z | 2024-05-20T12:14:09.882Z |
4349807 | 4349807 | 20240510120849_E1LTr | NZ0024 | 2024-05-20T12:14:09.882Z | 2024-05-20T12:14:09.882Z |
4349806 | 4349806 | 20240510120849_E1LTr | NZ001L | 2024-05-20T12:14:09.882Z | 2024-05-20T12:14:09.882Z |
4349805 | 4349805 | 20240510120849_E1LTr | NZ0017 | 2024-05-20T12:14:09.882Z | 2024-05-20T12:14:09.882Z |
4349804 | 4349804 | 20240510120849_E1LTr | NZ0016 | 2024-05-20T12:14:09.882Z | 2024-05-20T12:14:09.882Z |
4349803 | 4349803 | 20240510120847_1R0Vx | NZ002E | 2024-05-20T12:14:09.217Z | 2024-05-20T12:14:09.217Z |
4349802 | 4349802 | 20240510120847_1R0Vx | NZ001Z | 2024-05-20T12:14:09.196Z | 2024-05-20T12:14:09.196Z |
4349801 | 4349801 | 20240510120837_4a2tJ | NZ0044 | 2024-05-20T12:14:08.807Z | 2024-05-20T12:14:08.807Z |
4349800 | 4349800 | 20240510120837_4a2tJ | NZ002F | 2024-05-20T12:14:08.807Z | 2024-05-20T12:14:08.807Z |
4349799 | 4349799 | 20240510120837_4a2tJ | NZ0027 | 2024-05-20T12:14:08.807Z | 2024-05-20T12:14:08.807Z |
4349798 | 4349798 | 20240510120837_4a2tJ | NZ0026 | 2024-05-20T12:14:08.806Z | 2024-05-20T12:14:08.806Z |
4349797 | 4349797 | 20240510120837_4a2tJ | NZ000H | 2024-05-20T12:14:08.806Z | 2024-05-20T12:14:08.806Z |
4349796 | 4349796 | 20240510120837_4a2tJ | NZ000F | 2024-05-20T12:14:08.806Z | 2024-05-20T12:14:08.806Z |
4349795 | 4349795 | 20240510120645_fp2X8 | NZ003T | 2024-05-20T12:14:08.585Z | 2024-05-20T12:14:08.585Z |
4349794 | 4349794 | 20240510120645_fp2X8 | NZ001Y | 2024-05-20T12:14:08.585Z | 2024-05-20T12:14:08.585Z |
4349793 | 4349793 | 20240510120645_fp2X8 | NZ0018 | 2024-05-20T12:14:08.585Z | 2024-05-20T12:14:08.585Z |
4349792 | 4349792 | 20240510120559_GlpX5 | NZ004B | 2024-05-20T12:14:08.177Z | 2024-05-20T12:14:08.177Z |
4349791 | 4349791 | 20240510120559_GlpX5 | NZ0037 | 2024-05-20T12:14:08.177Z | 2024-05-20T12:14:08.177Z |
4349790 | 4349790 | 20240510120559_GlpX5 | NZ002X | 2024-05-20T12:14:08.177Z | 2024-05-20T12:14:08.177Z |
4349789 | 4349789 | 20240510120559_GlpX5 | NZ002W | 2024-05-20T12:14:08.177Z | 2024-05-20T12:14:08.177Z |
4349788 | 4349788 | 20240510120559_GlpX5 | NZ002P | 2024-05-20T12:14:08.177Z | 2024-05-20T12:14:08.177Z |
4349787 | 4349787 | 20240510120422_gVcyj | NZ003H | 2024-05-20T12:14:07.957Z | 2024-05-20T12:14:07.957Z |
4349786 | 4349786 | 20240510120422_gVcyj | NZ003A | 2024-05-20T12:14:07.957Z | 2024-05-20T12:14:07.957Z |
4349785 | 4349785 | 20240510120422_gVcyj | NZ002R | 2024-05-20T12:14:07.957Z | 2024-05-20T12:14:07.957Z |
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);