names

25 rows where place_id = 629415

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3788186 1954102 1954102 defendant Brader Thomas yeoman 629415 629415 Brader, Thomas, of North Cotes, yeoman 1
3788187 1954102 1954102 defendant Brader William chaplain 629415 629415 Brader, William, of North Cotes, chaplain 2
5042103 2369244 2369244 defendant Cave Thomas shipman 629415 629415 Cave, Thomas, of North Cotes, shipman 5
5081348 2380925 2380925 defendant Cave or Cane Thomas shipman 629415 629415 Cave or Cane, Thomas,of North Cotes, shipman 4
5176322 2408763 2408763 defendant Howelot Thomas butcher 629415 629415 Howelot, Thomas, of North Cotes, butcher 2
5198319 2415257 2415257 defendant Howelot Thomas butcher 629415 629415 Howelot, Thomas, of North Cotes, butcher 2
5238956 2426983 2426983 defendant Holo Thomas saltweller 629415 629415 Holo, Thomas, of North Cotes, saltweller 0
5302899 2445853 2445853 defendant Hebon John husbandman 629415 629415 Hebon, John, of North Cotes, husbandman 2
5302900 2445853 2445853 defendant Howelotte Thomas husbandman 629415 629415 Howelotte, Thomas, of North Cotes, husbandman 3
5304932 2446477 2446477 defendant Howelot Thomas husbandman 629415 629415 Howelot, Thomas, of North Cotes, husbandman 12
5304933 2446477 2446477 defendant Deen John chaplain 629415 629415 Deen, John, of North Cotes, chaplain 13
5307605 2447290 2447290 defendant Totehill William mariner 629415 629415 Totehill, William, of North Cotes, mariner 1
5311641 2448504 2448504 defendant Howelotte Thomas butcher 629415 629415 Howelotte, Thomas, of North Cotes, butcher 0
5355559 2461809 2461809 defendant Arnold Robert husbandman 629415 629415 Arnold, Robert, of North Cotes, husbandman 2
5449241 2489661 2489661 defendant Croftes Richard clerk 629415 629415 Croftes, Richard, of North Cotes, clerk 0
5470699 2496157 2496157 defendant Croftes Richard clerk 629415 629415 Croftes, Richard, of North Cotes, clerk 1
5496842 2503984 2503984 defendant Milnes William husbandman 629415 629415 Milnes, William, of North Cotes, husbandman 0
5496843 2503984 2503984 defendant raynold William husbandman 629415 629415 raynold, William, of North Cotes, husbandman 1
5496844 2503984 2503984 defendant Ingelby Thomas husbandman 629415 629415 Ingelby, Thomas, of North Cotes, husbandman 2
5496845 2503984 2503984 defendant Westorne John husbandman 629415 629415 Westorne, John, of North Cotes, husbandman 3
5496846 2503984 2503984 defendant Howelot Robert husbandman 629415 629415 Howelot, Robert, of North Cotes, husbandman 4
5603212 2535890 2535890 defendant Humfrey Richard husbandman 629415 629415 Humfrey, Richard, of North Cotes, husbandman 0
5603213 2535890 2535890 defendant Glover Walter husbandman 629415 629415 Glover, Walter, of North Cotes, husbandman 1
5603214 2535890 2535890 defendant Hart Robert husbandman 629415 629415 Hart, Robert, of North Cotes, husbandman 2
5603215 2535890 2535890 defendant There Walter husbandman 629415 629415 There, Walter, of North Cotes, husbandman 3

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