names

19 rows where place_id = 600531

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3641406 1907766 1907766 defendant Colyn John husbandman 600531 600531 Colyn, John, of Fenne, husbandman 0
4453368 2186059 2186059 plaintiff Laweson John   600531 600531 Laweson, John, of Fenne 0
4454200 2186328 2186328 defendant Cook Roger   600531 600531 Cook, Roger, of Fenne 1
4454203 2186329 2186329 defendant Cook Roger   600531 600531 Cook, Roger, of Fenne 1
4462941 2189107 2189107 plaintiff Cheston Thomas de   600531 600531 Cheston, Thomas de, of Fenne 1
4488864 2197234 2197234 plaintiff Symond John   600531 600531 Symond, John, of Fenne, on his own account 0
4540014 2212785 2212785 plaintiff Warwyk Alan   600531 600531 Warwyk, Alan, of Fenne 0
4549961 2215920 2215920 defendant Tyler William   600531 600531 Tyler, William, of Fenne 0
4565747 2220844 2220844 defendant Cressy Thomas   600531 600531 Cressy, Thomas, of Fenne 3
4567014 2221238 2221238 defendant Cressy Thomas   600531 600531 Cressy, Thomas, of Fenne 4
4611315 2234604 2234604 plaintiff Clerk Walter   600531 600531 Clerk, Walter, of Fenne 0
4646647 2245083 2245083 defendant Harnes Robert   600531 600531 Harnes, Robert, of Fenne 0
4671431 2256715 2256715 plaintiff Cartere Thomas   600531 600531 Cartere, Thomas, of Fenne 0
4671432 2256715 2256715 plaintiff Rayncok John   600531 600531 Rayncok, John, of Fenne 1
4688114 2261851 2261851 defendant Cressy Thomas husbandman 600531 600531 Cressy, Thomas, of Fenne, husbandman 2
4792653 2293791 2293791 defendant Hunt John husbandman 600531 600531 Hunt, John, of Fenne, husbandman 3
4825558 2304033 2304033 defendant Symson Thomas laborer 600531 600531 Symson, Thomas, of Fenne, laborer 8
4872911 2318480 2318480 defendant Baker Walter husbandman 600531 600531 Baker, Walter, of Fenne, husbandman 0
5518321 2510557 2510557 defendant Piers William husbandman 600531 600531 Piers, William, of Fenne, husbandman 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);