names

52 rows where place_id = 615449

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3708947 1929090 1929090 defendant Drury Robert gent 615449 615449 Drury, Robert, of Waterden, gent 3
3728953 1935302 1935302 defendant Mabbys Geoffrey husbandman 615449 615449 Mabbys, Geoffrey, of Waterden, husbandman 1
3739395 1938529 1938529 defendant Drury Robert gent 615449 615449 Drury, Robert, of Waterden, gent 1
3747829 1941243 1941243 defendant Mabbys Geoffrey yeoman 615449 615449 Mabbys, Geoffrey, of Waterden, yeoman 0
3780971 1951781 1951781 defendant Andrewe alias Williamson Thomas   615449 615449 Andrewe alias Williamson, Thomas, of Waterden, shepherd 1
3784188 1952840 1952840 defendant Flete Thomas gent 615449 615449 Flete, Thomas, of Waterden, gent 0
3787923 1954015 1954015 plaintiff Seffull Giles gent 615449 615449 Seffull, Giles, of Waterden, gent 0
3984295 2019146 2019146 defendant Seffould Thomas esq 615449 615449 Seffould, Thomas, of Waterden, esq 0
3993122 2022289 2022289 plaintiff Carlell Robert warrener 615449 615449 Carlell, Robert, of Waterden, warrener 0
4155234 2079924 2079924 defendant Seffould Thomas esq 615449 615449 Seffould, Thomas, of Waterden, esq 0
4155235 2079924 2079924 defendant Malby John yeoman 615449 615449 Malby, John, of Waterden, yeoman 1
4158697 2081115 2081115 defendant Seaffold Thomas esq 615449 615449 Seaffold, Thomas, of Waterden, esq 0
4214868 2100700 2100700 defendant Seffould Brigit widow 615449 615449 Seffould, Brigit, of Waterden, widow 0
4241243 2110056 2110056 defendant Seffould Brigit widow 615449 615449 Seffould, Brigit, of Waterden, widow 1
4336808 2142602 2142602 defendant Seffoule Brigit esq 615449 615449 Seffoule, Brigit, of Waterden, widow of Thomas Seafoule, of Waterden, esq 0
4344070 2145203 2145203 defendant Seafoule Nicholas esq 615449 615449 Seafoule, Nicholas, of Waterden, esq 0
4344072 2145204 2145204 defendant Seafule Brigit gentlewoman 615449 615449 Seafule, Brigit, of Waterden, widow, gentlewoman 0
4353563 2148470 2148470 defendant Seafoulde Brigit widow 615449 615449 Seafoulde, Brigit, of Waterden, widow 0
4353565 2148470 2148470 defendant Seafoulde Nicholas gent 615449 615449 Seafoulde, Nicholas, of Waterden, gent 2
4354800 2148900 2148900 defendant Seffoule Brigit widow 615449 615449 Seffoule, Brigit, of Waterden, widow 0
4385311 2159777 2159777 defendant Seffoule Brigit widow 615449 615449 Seffoule, Brigit, of Waterden, widow 0
4394099 2162628 2162628 defendant Seafoule Brigit widow 615449 615449 Seafoule, Brigit, of Waterden, widow 1
4401486 2165092 2165092 defendant Seffoule Brigit widow 615449 615449 Seffoule, Brigit, of Waterden, widow 0
4405682 2166469 2166469 defendant Sefoule or Seffould Brigit widow 615449 615449 Sefoule or Seffould, Brigit, of Waterden, widow 0
4409188 2167672 2167672 defendant Seffould or Seffowle Thomas gent 615449 615449 Seffould or Seffowle, Thomas, of Waterden, gent 2
4680431 2259494 2259494 defendant Rawelyn Adam gent 615449 615449 Rawelyn, Adam, of Waterden, gent 0
4680440 2259496 2259496 defendant Raulyns Adam gent 615449 615449 Raulyns, Adam, of Waterden, gent 0
4680828 2259625 2259625 defendant Raulyns Adam gent 615449 615449 Raulyns, Adam, of Waterden, gent 0
4698345 2264962 2264962 defendant Peyntour John yeoman 615449 615449 Peyntour, John, of Waterden, yeoman 0
4705879 2267215 2267215 defendant Harleston John   615449 615449 Harleston, John, of Waterden, parson 0
4705880 2267215 2267215 defendant Peyntout John husbandman 615449 615449 Peyntout, John, of Waterden, husbandman 1
4705881 2267215 2267215 defendant Adekenys Thomas yeoman 615449 615449 Adekenys, Thomas, of Waterden, yeoman 2
4734129 2275857 2275857 defendant Herleston John clerk 615449 615449 Herleston, John, of Waterden, clerk 2
4753328 2281418 2281418 defendant Kerchenere John   615449 615449 Kerchenere, John, of Waterden, parson 3
4787904 2292284 2292284 defendant Deen Loveta or Loneta widow 615449 615449 Deen, Loveta or Loneta, of Waterden, widow 0
4862615 2315294 2315294 plaintiff Deen Loneta or Loveta widow 615449 615449 Deen, Loneta or Loveta, of Waterden, widow 0
4862616 2315294 2315294 plaintiff Deen William chaplain 615449 615449 Deen, William, of Waterden, chaplain 1
5101952 2386992 2386992 defendant Borter or Bordyour Richard husbandman 615449 615449 Borter or Bordyour, Richard, of Waterden, husbandman 0
5125623 2393984 2393984 defendant Borter alias Bordyour Richard husbandman 615449 615449 Borter alias Bordyour, Richard, of Waterden, husbandman 0
5256752 2432233 2432233 defendant Pedder John husbandman 615449 615449 Pedder, John, of Waterden, husbandman 0
5394687 2473541 2473541 defendant Pedder John woolman 615449 615449 Pedder, John, of Waterden, woolman 14
5440325 2487005 2487005 defendant Pedder John woolman 615449 615449 Pedder, John, of Waterden, woolman 13
5463663 2494047 2494047 defendant (not given) Thomas rector of Crane 615449 615449 Crane, Thomas, of Waterden, rector of the church 4
5488753 2501513 2501513 defendant Pedder John husbandman 615449 615449 Pedder, John, of Waterden, husbandman 3
5495117 2503437 2503437 defendant Warner John yeoman 615449 615449 Warner, John, of Waterden, yeoman 1
5496902 2504004 2504004 defendant Pedder John husbandman 615449 615449 Pedder, John, of Waterden, husbandman 0
5536603 2515935 2515935 defendant Seffoule Thomas esq 615449 615449 Seffoule, Thomas, of Waterden, esq 0
5544802 2518485 2518485 defendant Sefoul Thomas gent 615449 615449 Sefoul, Thomas, of Waterden, gent 1
5558475 2522423 2522423 defendant Sesoul Thomas gent 615449 615449 Sesoul, Thomas, of Waterden, gent 0
5590651 2532046 2532046 defendant Sefoull Thomas gent 615449 615449 Sefoull, Thomas, of Waterden, gent 0
5598562 2534436 2534436 defendant Seffoull Thomas gent 615449 615449 Seffoull, Thomas, of Waterden, gent 0
5605457 2536587 2536587 defendant Seseull Thomas gent 615449 615449 Seseull, Thomas, of Waterden, gent 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);