names

29 rows where place_id = 592790

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3608929 1870451 1870451 defendant Halsted Robert   592790 592790 Halsted, Robert, of Elveden 1
3638272 1906789 1906789 defendant Fuller Andrew husbandman 592790 592790 Fuller, Andrew, of Elveden, husbandman 3
3662052 1914064 1914064 defendant Halsted William husbandman 592790 592790 Halsted, William, of Elveden, husbandman 8
3673135 1917609 1917609 defendant Downyng John husbandman 592790 592790 Downyng, John, of Elveden, husbandman 0
3702188 1926940 1926940 defendant Glendden or Elvenden Nicholas gent 592790 592790 Glendden or Elvenden, Nicholas, of Elveden, gent 0
4002682 2025726 2025726 defendant Wormeley John yeoman 592790 592790 Wormeley, John, of Elveden, yeoman 0
4305585 2132088 2132088 defendant Huniston or Humston Robert clerk 592790 592790 Huniston or Humston, Robert, of Elveden, clerk 0
4579950 2225216 2225216 plaintiff Crowe Thomas   592790 592790 Crowe, Thomas, of Elveden, parson 0
4581966 2225804 2225804 defendant Waller John   592790 592790 Waller, John, of Elveden 7
4581977 2225805 2225805 defendant Waller John   592790 592790 Waller, John, of Elveden 7
4581992 2225806 2225806 defendant Webber William   592790 592790 Webber, William, of Elveden 11
4582005 2225807 2225807 defendant Webber William   592790 592790 Webber, William, of Elveden 11
4627928 2239664 2239664 plaintiff Crowe Thomas   592790 592790 Crowe, Thomas, of Elveden, parson 1
4639820 2243153 2243153 plaintiff Crowe Thomas   592790 592790 Crowe, Thomas, of Elveden, parson 0
4674729 2257708 2257708 defendant Bray Roger husbandman 592790 592790 Bray, Roger, of Elveden, husbandman 0
4789739 2292860 2292860 defendant Denton William laborer 592790 592790 Denton, William, of Elveden, laborer 1
4789740 2292860 2292860 defendant Langeaunt Robert   592790 592790 Langeaunt, Robert, of Elveden, shepherd 2
4936696 2337859 2337859 defendant Halle John husbandman 592790 592790 Halle, John, of Elveden, husbandman 0
5013577 2360814 2360814 defendant Largente John husbandman 592790 592790 Largente, John, of Elveden, husbandman 0
5067359 2376744 2376744 defendant Largaunt Robert yeoman 592790 592790 Largaunt, Robert, of Elveden, yeoman 3
5250613 2430301 2430301 defendant Rabette Roger   592790 592790 Rabette, Roger, of Elveden, servant 0
5262347 2433972 2433972 defendant Fouler Geoffrey husbandman 592790 592790 Fouler, Geoffrey, of Elveden, husbandman 0
5281884 2439776 2439776 defendant Webbe John husbandman 592790 592790 Webbe, John, of Elveden, husbandman 0
5345259 2458689 2458689 plaintiff Webber John   592790 592790 Webber, John, of Elveden 0
5345261 2458690 2458690 plaintiff Webber Thomas (legal representative) 592790 592790 Webber, Thomas, of Elveden, executors of 0
5552111 2520660 2520660 defendant Breggeman Robert   592790 592790 Breggeman, Robert, of Elveden, shepherd 0
5570366 2525902 2525902 defendant Toller Reginald husbandman 592790 592790 Toller, Reginald, of Elveden, husbandman 0
5590142 2531891 2531891 defendant Fuller Andrew husbandman 592790 592790 Fuller, Andrew, of Elveden, husbandman 0
5590146 2531892 2531892 defendant Fuller Andrew husbandman 592790 592790 Fuller, Andrew, of Elveden, 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);