names

30 rows where place_id = 592897

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3609305 1870569 1870569 defendant Olyver Richard maltman 592897 592897 Olyver, Richard, of Whatton, maltman 3
3679188 1919559 1919559 defendant Turnour William, junior   592897 592897 Turnour, William, junior, of Whatton, wool driver 0
3697709 1925508 1925508 defendant Kerchefer Henry husbandman 592897 592897 Kerchefer, Henry, of Whatton, husbandman 0
3703824 1927476 1927476 defendant Hus William husbandman 592897 592897 Hus, William, of Whatton, husbandman 0
3768186 1947690 1947690 defendant Gramell John husbandman 592897 592897 Gramell, John, of Whatton, husbandman 3
4506019 2202395 2202395 defendant Marchall William   592897 592897 Marchall, William, of Whatton 0
4566797 2221184 2221184 plaintiff Sutton Richard de   592897 592897 Sutton, Richard de, of Whatton, parson 0
4589190 2228000 2228000 defendant Dalcok Robert   592897 592897 Dalcok, Robert, of Whatton 0
4592067 2228874 2228874 defendant Marsshall John   592897 592897 Marsshall, John, of Whatton 2
4608345 2233721 2233721 defendant Lowe Edith   592897 592897 Lowe, Edith, of Whatton 6
4619431 2237069 2237069 defendant Marchall John   592897 592897 Marchall, John, of Whatton 0
4678131 2258771 2258771 defendant Corby William yeoman 592897 592897 Corby, William, of Whatton, yeoman 0
4756389 2282362 2282362 defendant Eme Thomas   592897 592897 Eme, Thomas, of Whatton 3
4767511 2285816 2285816 defendant Clerke Ralph husbandman 592897 592897 Clerke, Ralph, of Whatton, husbandman 0
4769201 2286345 2286345 plaintiff Palterton William   592897 592897 Palterton, William, of Whatton, vicar 0
4769202 2286345 2286345 defendant Clerk Ralph husbandman 592897 592897 Clerk, Ralph, of Whatton, husbandman 0
4769203 2286345 2286345 defendant Lowe John husbandman 592897 592897 Lowe, John, of Whatton, husbandman 1
4775209 2288240 2288240 defendant Donham Roger yeoman 592897 592897 Donham, Roger, of Whatton, yeoman 1
4800715 2296407 2296407 defendant Castelton John, senior yeoman 592897 592897 Castelton, John, senior, of Whatton, yeoman 0
4800717 2296408 2296408 defendant Castelton John, senior husbandman 592897 592897 Castelton, John, senior, of Whatton, husbandman 0
4805643 2297973 2297973 plaintiff Bumpe Thomas   592897 592897 Bumpe, Thomas, of Whatton 0
4938379 2338382 2338382 defendant Burton William butcher 592897 592897 Burton, William, of Whatton, butcher 0
4962706 2345751 2345751 defendant Whatton John, junior gent 592897 592897 Whatton, John, junior, of Whatton, gent 0
5064346 2375883 2375883 defendant Craumer or Cranmer John gent 592897 592897 Craumer or Cranmer, John, of Whatton, or of Aslokton, gent 0
5084485 2381874 2381874 defendant Kerchener John husbandman 592897 592897 Kerchener, John, of Whatton, husbandman 1
5300005 2444965 2444965 defendant Groynes Robert husbandman 592897 592897 Groynes, Robert, of Whatton, husbandman 1
5498361 2504471 2504471 defendant Wales Thomas husbandman 592897 592897 Wales, Thomas, of Whatton, husbandman 0
5498362 2504471 2504471 defendant Swalwod Thomas husbandman 592897 592897 Swalwod, Thomas, of Whatton, husbandman 1
5500585 2505112 2505112 defendant Smalewode William husbandman 592897 592897 Smalewode, William, of Whatton, husbandman 0
5500587 2505112 2505112 defendant Telme or Teline Robert husbandman 592897 592897 Telme or Teline, Robert, of Whatton, 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);