names

13 rows where place_id = 592508

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3607909 1870123 1870123 defendant Baron John husbandman 592508 592508 Baron, John, of North Merston, Bucks, husbandman 1
3867597 1979397 1979397 defendant Carter Thomas yeoman 592508 592508 Carter, Thomas, of North Merston, Bucks, yeoman 0
4193879 2093421 2093421 defendant Carter John yeoman 592508 592508 Carter, John, of North Merston, Bucks, yeoman 2
5039745 2368529 2368529 defendant Boton alias Boweton John husbandman 592508 592508 Boton alias Boweton, John, of North Merston, Bucks, husbandman 0
5047173 2370776 2370776 defendant Boden John husbandman 592508 592508 Boden, John, of North Merston, Bucks, husbandman 0
5077745 2379839 2379839 defendant Boton or Boweton John husbandman 592508 592508 Boton or Boweton, John, of North Merston, Bucks, husbandman 0
5077751 2379840 2379840 defendant Boton or Boweton John husbandman 592508 592508 Boton or Boweton, John, of North Merston, Bucks, husbandman 0
5155630 2402803 2402803 defendant Cottebery Thomas   592508 592508 Cottebery, Thomas, of North Merston, Bucks, notary 1
5191356 2413209 2413209 defendant Cottebery Thomas   592508 592508 Cottebery, Thomas, of North Merston, Bucks, notary 1
5332886 2454903 2454903 defendant Kynnes William husbandman 592508 592508 Kynnes, William, of North Merston, Bucks, husbandman 0
5339766 2457012 2457012 defendant Haddisley William   592508 592508 Haddisley, William, of North Merston, Bucks, brooch maker 0
5339772 2457013 2457013 defendant Haddisley William   592508 592508 Haddisley, William, of North Merston, Bucks, brooch maker 0
5447856 2489242 2489242 defendant Cotterbery Thomas master & notary 592508 592508 Cotterbery, Thomas, of North Merston, Bucks, gent, master & notary 0

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