names

22 rows where place_id = 594683

✎ 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
3617156 1872989 1872989 defendant Alblaster Thomas gent 594683 594683 Alblaster, Thomas, of Tendryng, Essex, gent 0
3617504 1873095 1873095 defendant Arblaster Thomas gent 594683 594683 Arblaster, Thomas, of Tendryng, Essex, gent 0
3656792 1912379 1912379 defendant Roude John husbandman 594683 594683 Roude, John, of Tendryng, Essex, husbandman 0
3878732 1983136 1983136 defendant Awnger William yeoman 594683 594683 Awnger, William, of Tendryng, Essex, yeoman 0
3933889 2001630 2001630 defendant Arblaster Edmund esq 594683 594683 Arblaster, Edmund, of Tendryng, Essex, esq 1
4686000 2261208 2261208 defendant Buxhull Alan   594683 594683 Buxhull, Alan, of Tendryng, Essex, knight 1
4686007 2261211 2261211 defendant Buxhull Alan   594683 594683 Buxhull, Alan, of Tendryng, Essex, knight 0
4832185 2306097 2306097 defendant Flyspe Robert gent 594683 594683 Flyspe, Robert, of Tendryng, Essex, gent 0
4875611 2319329 2319329 defendant Flyspe or Flyppes Robert   594683 594683 Flyspe or Flyppes, Robert, of Tendryng, Essex, gemt 2
4924016 2333950 2333950 defendant Ralet Robert   594683 594683 Ralet, Robert, of Tendryng, Essex, parson 0
4924017 2333950 2333950 defendant Hillys John yeoman 594683 594683 Hillys, John, of Tendryng, Essex,yeoman 1
4933193 2336773 2336773 defendant Rabet Robert clerk 594683 594683 Rabet, Robert, of Tendryng, Essex, clerk 0
5069505 2377376 2377376 defendant Hanham John esq 594683 594683 Hanham, John, of Tendryng, Essex, esq 0
5069522 2377382 2377382 defendant Hanham John esq 594683 594683 Hanham, John, of Tendryng, Essex, esq 0
5094398 2384765 2384765 defendant Hill John gent 594683 594683 Hill, John, of Tendryng, Essex, gent 0
5094401 2384766 2384766 defendant Hill John gent 594683 594683 Hill, John, of Tendryng, Essex, gent 0
5214798 2420047 2420047 defendant Hanham John, junior gent 594683 594683 Hanham, John, junior, of Tendryng, Essex, gent 4
5291925 2442644 2442644 defendant Hanham John, junior gent 594683 594683 Hanham, John, junior, of Tendryng, Essex, gent 2
5295718 2443743 2443743 defendant Talworth William gent 594683 594683 Talworth, William, of Tendryng, Essex, gent 2
5295722 2443744 2443744 defendant Talworth William gent 594683 594683 Talworth, William, of Tendryng, Essex, gent 2
5454485 2491254 2491254 defendant Rothe John husbandman 594683 594683 Rothe, John, of Tendryng, Essex, husbandman 2
5466373 2494878 2494878 defendant Rothe John husbandman 594683 594683 Rothe, John, of Tendryng, Essex, 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);