names

32 rows where place_id = 603647

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3655257 1911901 1911901 defendant Pykard John husbandman 603647 603647 Pykard, John, of Bargham, husbandman 0
3669644 1916443 1916443 defendant Pykard John husbandman 603647 603647 Pykard, John, of Bargham, husbandman 0
3703304 1927306 1927306 defendant Cave Thomas husbandman 603647 603647 Cave, Thomas, of Bargham, husbandman 2
3710446 1929585 1929585 defendant Wrenne Thomas husbandman 603647 603647 Wrenne, Thomas, of Bargham, husbandman 1
3725069 1934127 1934127 defendant Wrenne Thomas husbandman 603647 603647 Wrenne, Thomas, of Bargham, husbandman 1
3804333 1959291 1959291 defendant Wrenne Thomas husbandman 603647 603647 Wrenne, Thomas, of Bargham, husbandman 1
3813813 1962233 1962233 defendant Bylys John husbandman 603647 603647 Bylys, John, of Bargham, husbandman 2
3821803 1964707 1964707 defendant Wrenne Thomas husbandman 603647 603647 Wrenne, Thomas, of Bargham, husbandman 1
4589385 2228057 2228057 defendant Blake John   603647 603647 Blake, John, of Bargham 0
4728004 2274004 2274004 defendant Gobell Thomas husbandman 603647 603647 Gobell, Thomas, of Bargham, husbandman 0
5093328 2384446 2384446 defendant Hill Geoffrey husbandman 603647 603647 Hill, Geoffrey, of Bargham, husbandman 0
5268072 2435777 2435777 defendant Malby William   603647 603647 Malby, William, of Bargham, parson 0
5305546 2446663 2446663 defendant Hamonde William   603647 603647 Hamonde, William, of Bargham, parson 0
5409330 2477760 2477760 defendant Goffe John husbandman 603647 603647 Goffe, John, of Bargham, husbandman 3
5410595 2478112 2478112 defendant Faldyngton Robert husbandman 603647 603647 Faldyngton, Robert, of Bargham, husbandman 1
5418496 2480459 2480459 defendant Couper John husbandman 603647 603647 Couper, John, of Bargham, husbandman 0
5418497 2480459 2480459 defendant Faldyngton Robert husbandman 603647 603647 Faldyngton, Robert, of Bargham, husbandman 1
5418498 2480459 2480459 defendant Whyte William husbandman 603647 603647 Whyte, William, of Bargham, husbandman 2
5436440 2485833 2485833 defendant Couper John husbandman 603647 603647 Couper, John, of Bargham, husbandman 0
5436441 2485833 2485833 defendant Faldyngton Robert husbandman 603647 603647 Faldyngton, Robert, of Bargham, husbandman 1
5436442 2485833 2485833 defendant White William husbandman 603647 603647 White, William, of Bargham, husbandman 2
5436444 2485834 2485834 defendant Couper John husbandman 603647 603647 Couper, John, of Bargham, husbandman 0
5436445 2485834 2485834 defendant Faldyngton Robert husbandman 603647 603647 Faldyngton, Robert, of Bargham, husbandman 1
5436446 2485834 2485834 defendant Whyte William husbandman 603647 603647 Whyte, William, of Bargham, husbandman 2
5441324 2487322 2487322 defendant Faldyngton Robert   603647 603647 Faldyngton, Robert, of Bargham 0
5441329 2487323 2487323 defendant Faldyngton Robert husbandman 603647 603647 Faldyngton, Robert, of Bargham, husbandman 1
5451118 2490227 2490227 defendant Couper John husbandman 603647 603647 Couper, John, of Bargham, husbandman 0
5451119 2490227 2490227 defendant Faldyngton Robert husbandman 603647 603647 Faldyngton, Robert, of Bargham, husbandman 1
5451120 2490227 2490227 defendant White Willliam husbandman 603647 603647 White, Willliam, of Bargham, husbandman 2
5456032 2491717 2491717 defendant Faldyngton Robert husbandman 603647 603647 Faldyngton, Robert, of Bargham, husbandman 0
5497046 2504052 2504052 defendant Child Henry husbandman 603647 603647 Child, Henry, of Bargham, husbandman 2
5511909 2508582 2508582 defendant Chyld Henry husbandman 603647 603647 Chyld, Henry, of Bargham, husbandman 2

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);