names

38 rows where place_id = 634596

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3819885 1964100 1964100 defendant Grele John yeoman 634596 634596 Grele, John, of Welby, yeoman 1
3948332 2006480 2006480 plaintiff Curdy or Curde William (legal representative) 634596 634596 Curdy or Curde, William, of Welby, executors of 0
3948336 2006481 2006481 plaintiff Curdye or Curde William (legal representative) 634596 634596 Curdye or Curde, William, of Welby, executors of 0
4135646 2073073 2073073 defendant Stanton Giles joiner 634596 634596 Stanton, Giles, of Welby, joiner 1
4279102 2122621 2122621 defendant Spraggen John laborer 634596 634596 Spraggen, John, of Welby, laborer 0
4426495 2173103 2173103 plaintiff Palmer Richard   634596 634596 Palmer, Richard, of Welby 0
4428671 2173769 2173769 defendant Basset Henry   634596 634596 Basset, Henry, of Welby, parson 0
4436843 2176264 2176264 defendant Basset Henry   634596 634596 Basset, Henry, of Welby, parson 0
4665772 2250770 2250770 defendant Lovel John quarrier 634596 634596 Lovel, John, of Welby, quarrier 0
4729760 2274513 2274513 defendant Pecke William husbandman 634596 634596 Pecke, William, of Welby, husbandman 0
4735484 2276245 2276245 defendant Sawer John husbandman 634596 634596 Sawer, John, of Welby, husbandman 0
4746812 2279568 2279568 defendant White John, junior   634596 634596 White, John, junior, of Welby, wright 0
4869512 2317431 2317431 defendant Levell or Lenell John husbandman 634596 634596 Levell or Lenell, John, of Welby, husbandman 0
4881891 2321234 2321234 defendant Lenell or Levell John husbandman 634596 634596 Lenell or Levell, John, of Welby, husbandman 0
4911762 2330178 2330178 defendant Croftys William husbandman 634596 634596 Croftys, William, of Welby, husbandman 0
4947304 2341150 2341150 plaintiff Lenell or Levell John   634596 634596 Lenell or Levell, John, of Welby 0
4999686 2356782 2356782 defendant Barker John husbandman 634596 634596 Barker, John, of Welby, husbandman 3
5023788 2363863 2363863 defendant Gunthorp Thomas yeoman 634596 634596 Gunthorp, Thomas, of Welby, yeoman 0
5078173 2379958 2379958 defendant Lenell or Levell Robert husbandman 634596 634596 Lenell or Levell, Robert, of Welby, husbandman 0
5088741 2383082 2383082 plaintiff Lanell or Lavell John   634596 634596 Lanell or Lavell, John, of Welby 0
5089322 2383244 2383244 plaintiff Lewelle John   634596 634596 Lewelle, John, of Welby 0
5104334 2387691 2387691 defendant Peres John husbandman 634596 634596 Peres, John, of Welby, husbandman 0
5160349 2404121 2404121 defendant Tolle Robert chaplain & clerk 634596 634596 Tolle, Robert, of Welby, chaplain & clerk 0
5175232 2408448 2408448 defendant Tolle Robert chaplain 634596 634596 Tolle, Robert, of Welby, chaplain 0
5196337 2414678 2414678 defendant Toille Robert chaplain 634596 634596 Toille, Robert, of Welby, chaplain 0
5197401 2414984 2414984 defendant Toll Robert   634596 634596 Toll, Robert, of Welby, parson of All Saints church 1
5275551 2437918 2437918 defendant Obyn William yeoman 634596 634596 Obyn, William, of Welby, yeoman 0
5283938 2440331 2440331 defendant Watson Richard husbandman 634596 634596 Watson, Richard, of Welby, husbandman 8
5343375 2458119 2458119 defendant Levyle Thomas husbandman 634596 634596 Levyle, Thomas, of Welby juxta Ancaster, husbandman 0
5361951 2463763 2463763 defendant Stokke John husbandman 634596 634596 Stokke, John, of Welby, husbandman 0
5420622 2481092 2481092 defendant Bredsale Robert husbandman 634596 634596 Bredsale, Robert, of Welby, husbandman 0
5429107 2483631 2483631 defendant Stok John husbandman 634596 634596 Stok, John, of Welby, husbandman 1
5454083 2491116 2491116 defendant Stok John   634596 634596 Stok, John, of Welby 1
5464896 2494414 2494414 defendant Bredsale Robert husbandman 634596 634596 Bredsale, Robert, of Welby, husbandman 0
5624741 2551672 2551672 plaintiff Prest John   634596 634596 Prest, John, of Welby 1
5624742 2551672 2551672 defendant Pek John husbandman 634596 634596 Pek, John, of Welby, husbandman 0
5625115 2551792 2551792 plaintiff Prest John   634596 634596 Prest, John, of Welby 1
5625116 2551792 2551792 defendant Pek John husbandman 634596 634596 Pek, John, of Welby, husbandman 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);