related_activity

Links inspections to other related inspections. Used when one inspection triggers another (e.g., a follow-up, referral, or related-establishment inspection). Join the parent via activity_nr; rel_act_nr identifies the related inspection.
activity_nr
Foreign key to inspection.activity_nr (the parent inspection).
load_dt
Timestamp when this row was loaded.
rel_act_nr
Activity number of the related inspection.
rel_health
Whether the related inspection covered health — "X" or NULL.
rel_safety
Whether the related inspection covered safety — "X" or NULL.
rel_type
Type of relationship (follow-up, referral, related-establishment, etc.).

2,477,744 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ activity_nr rel_type rel_act_nr rel_safety rel_health load_dt
1 1 390765 390765 C 79482386     2011-10-14 16:41:57+00:00
2 2 390799 390799 R 900044124     2011-10-14 16:41:57+00:00
3 3 390807 390807 C 321808669     2011-10-14 16:41:57+00:00
4 4 390831 390831 R 900044165   X 2011-10-14 16:41:57+00:00
5 5 391110 391110 C 70043674     2011-10-14 16:41:57+00:00
6 6 391151 391151 C 70043674     2011-10-14 16:41:57+00:00
7 7 391169 391169 C 70043682 X X 2011-10-14 16:41:57+00:00
8 8 391805 391805 R 909240574     2011-10-14 16:41:57+00:00
9 9 391961 391961 C 70043849     2011-10-14 16:41:57+00:00
10 10 392241 392241 R 909240574     2011-10-14 16:41:57+00:00
11 11 392282 392282 C 70043922   X 2011-10-14 16:41:57+00:00
12 12 392761 392761 A 360043400     2011-10-14 16:41:57+00:00
13 13 392803 392803 C 70043724     2011-10-14 16:41:57+00:00
14 14 392878 392878 C 70044169     2011-10-14 16:41:57+00:00
15 15 392969 392969 C 70043963     2011-10-14 16:41:57+00:00
16 16 393116 393116 C 70043633     2011-10-14 16:41:57+00:00
17 17 393355 393355 C 70045141     2011-10-14 16:41:57+00:00
18 18 393363 393363 C 79518981     2011-10-14 16:41:57+00:00
19 19 393520 393520 C 70044722     2011-10-14 16:41:57+00:00
20 20 393579 393579 C 70044706     2011-10-14 16:41:57+00:00
21 21 393850 393850 C 70045307     2011-10-14 16:41:57+00:00
22 22 394163 394163 C 70044698     2011-10-14 16:41:57+00:00
23 23 394171 394171 C 321847345     2011-10-14 16:41:57+00:00
24 24 394189 394189 C 70044656     2011-10-14 16:41:57+00:00
25 25 394189 394189 C 70044664     2011-10-14 16:41:57+00:00
26 26 394189 394189 C 70044672 X   2011-10-14 16:41:57+00:00
27 27 394189 394189 C 70044680 X   2011-10-14 16:41:57+00:00
28 28 394205 394205 A 360044259     2011-10-14 16:41:57+00:00
29 29 394395 394395 C 321847253     2011-10-14 16:41:57+00:00
30 30 394411 394411 C 321847576     2011-10-14 16:41:57+00:00
31 31 394635 394635 C 79482584     2011-10-14 16:41:57+00:00
32 32 394791 394791 C 70044813     2011-10-14 16:41:57+00:00
33 33 394825 394825 C 70044771     2011-10-14 16:41:57+00:00
34 34 394833 394833 I 17307786     2011-10-14 16:41:57+00:00
35 35 394932 394932 C 70044656     2011-10-14 16:41:57+00:00
36 36 395293 395293 C 70044979     2011-10-14 16:41:57+00:00
37 37 395574 395574 C 70045133     2011-10-14 16:41:57+00:00
38 38 395681 395681 C 70045216     2011-10-14 16:41:57+00:00
39 39 395699 395699 C 70045067     2011-10-14 16:41:57+00:00
40 40 395806 395806 C 70045174     2011-10-14 16:41:57+00:00
41 41 395905 395905 C 70044995 X X 2011-10-14 16:41:57+00:00
42 42 395913 395913 C 70044581     2011-10-14 16:41:57+00:00
43 43 395947 395947 C 70044581     2011-10-14 16:41:57+00:00
44 44 395970 395970 C 70045141     2011-10-14 16:41:57+00:00
45 45 396036 396036 C 70044565     2011-10-14 16:41:57+00:00
46 46 396077 396077 C 70044755     2011-10-14 16:41:57+00:00
47 47 396556 396556 A 360044267     2011-10-14 16:41:57+00:00
48 48 396598 396598 A 360044275     2011-10-14 16:41:57+00:00
49 49 396630 396630 C 70045299     2011-10-14 16:41:57+00:00
50 50 396671 396671 C 70044748 X X 2011-10-14 16:41:57+00:00
51 51 396713 396713 C 70045299     2011-10-14 16:41:57+00:00
52 52 397281 397281 C 79484044     2011-10-14 16:41:57+00:00
53 53 397984 397984 C 79481495 X   2011-10-14 16:41:57+00:00
54 54 397984 397984 C 79481586 X   2011-10-14 16:41:57+00:00
55 55 398081 398081 C 79516670     2011-10-14 16:41:57+00:00
56 56 398172 398172 R 900045840     2011-10-14 16:41:57+00:00
57 57 398347 398347 A 350194692     2011-10-14 16:41:57+00:00
58 58 398529 398529 C 79516670     2011-10-14 16:41:57+00:00
59 59 398529 398529 C 79516886     2011-10-14 16:41:57+00:00
60 60 398594 398594 C 321722381     2011-10-14 16:41:57+00:00
61 61 398636 398636 A 360046916     2011-10-14 16:41:57+00:00
62 62 315831628 315831628 C 77969053   X 2017-04-18 01:00:30+00:00
63 63 398727 398727 C 79516886   X 2011-10-14 16:41:57+00:00
64 64 398768 398768 C 321720781     2011-10-14 16:41:57+00:00
65 65 398834 398834 C 79481610     2011-10-14 16:41:57+00:00
66 66 398925 398925 C 79481628     2011-10-14 16:41:57+00:00
67 67 398982 398982 A 360100333     2011-10-14 16:41:57+00:00
68 68 399006 399006 C 70047097     2011-10-14 16:41:57+00:00
69 69 399113 399113 I 16897712     2011-10-14 16:41:57+00:00
70 70 399345 399345 C 79481479     2011-10-14 16:41:57+00:00
71 71 399386 399386 A 360047112     2011-10-14 16:41:57+00:00
72 72 399428 399428 R 900045840     2011-10-14 16:41:57+00:00
73 73 399477 399477 C 79481503     2011-10-14 16:41:57+00:00
74 74 399923 399923 C 321720948     2011-10-14 16:41:57+00:00
75 75 399964 399964 A 360047864     2011-10-14 16:41:57+00:00
76 76 400002 400002 C 79516852     2011-10-14 16:41:57+00:00
77 77 400028 400028 C 79481701     2011-10-14 16:41:57+00:00
78 78 400044 400044 C 79516704     2011-10-14 16:41:57+00:00
79 79 400069 400069 C 79481479     2011-10-14 16:41:57+00:00
80 80 400085 400085 A 360048078     2011-10-14 16:41:57+00:00
81 81 315831933 315831933 A 102654688     2017-04-18 01:00:30+00:00
82 82 400259 400259 A 360047872     2011-10-14 16:41:57+00:00
83 83 400291 400291 A 360048078     2011-10-14 16:41:57+00:00
84 84 400325 400325 A 360047955     2011-10-14 16:41:57+00:00
85 85 400333 400333 A 360048037     2011-10-14 16:41:57+00:00
86 86 400499 400499 A 360047831     2011-10-14 16:41:57+00:00
87 87 400648 400648 C 321722076     2011-10-14 16:41:57+00:00
88 88 400663 400663 R 900045881     2011-10-14 16:41:57+00:00
89 89 400671 400671 C 79518965     2011-10-14 16:41:57+00:00
90 90 400697 400697 C 321720161     2011-10-14 16:41:57+00:00
91 91 400739 400739 A 360047997     2011-10-14 16:41:57+00:00
92 92 400747 400747 C 321722340     2011-10-14 16:41:57+00:00
93 93 402339 402339 R 909127979     2011-10-14 16:41:57+00:00
94 94 402743 402743 C 79483533     2011-10-14 16:41:57+00:00
95 95 402776 402776 R 900005448 X   2011-10-14 16:41:57+00:00
96 96 402784 402784 R 900005448 X   2011-10-14 16:41:57+00:00
97 97 403113 403113 R 909240954 X   2011-10-14 16:41:57+00:00
98 98 403162 403162 C 70037817     2011-10-14 16:41:57+00:00
99 99 403170 403170 R 900038019     2011-10-14 16:41:57+00:00
100 100 403188 403188 R 900038027     2011-10-14 16:41:57+00:00

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "related_activity" (
   [activity_nr] INTEGER REFERENCES [inspection]([activity_nr]),
   [rel_type] TEXT,
   [rel_act_nr] INTEGER,
   [rel_safety] TEXT,
   [rel_health] TEXT,
   [load_dt] TEXT
);