names

68 rows where place_id = 605374

✎ 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
3661404 1913840 1913840 defendant Colley Richard yeoman 605374 605374 Colley, Richard, of Brynton, yeoman 1
3711070 1929773 1929773 defendant Colley Richard yeoman 605374 605374 Colley, Richard, of Brynton, yeoman 0
3716768 1931536 1931536 defendant Colley Richard yeoman 605374 605374 Colley, Richard, of Brynton, yeoman 0
3728843 1935268 1935268 defendant Turner Thomas husbandman 605374 605374 Turner, Thomas, of Brynton, husbandman 0
3728844 1935268 1935268 defendant Bradhurste William husbandman 605374 605374 Bradhurste, William, of Brynton, husbandman 1
3728845 1935268 1935268 defendant Turner John, senior husbandman 605374 605374 Turner, John, senior, of Brynton, husbandman 2
3752114 1942584 1942584 plaintiff Pleyford Robert yeoman 605374 605374 Pleyford, Robert, of Brynton, yeoman 0
3835385 1969006 1969006 plaintiff Playford Robert (legal representative) 605374 605374 Playford, Robert, of Brynton, executors of 0
3851793 1974150 1974150 plaintiff Playforth John   605374 605374 Playforth, John, of Brynton 0
3858796 1976428 1976428 defendant Humfrey William clerk 605374 605374 Humfrey, William, of Brynton, clerk 0
3880372 1983690 1983690 plaintiff Playford Robert (legal representative) 605374 605374 Playford, Robert, of Brynton, executor of 0
3893607 1988088 1988088 plaintiff Pleyford John yeoman 605374 605374 Pleyford, John, of Brynton, yeoman 0
3916562 1995915 1995915 defendant Umfrey William clerk 605374 605374 Umfrey, William, of Brynton, clerk 0
3918639 1996559 1996559 defendant Humfrey Joan widow 605374 605374 Humfrey, Joan, of Brynton, widow 0
3918640 1996559 1996559 defendant Humfrey William clerk 605374 605374 Humfrey, William, of Brynton, clerk 1
4078480 2052602 2052602 defendant Cowper George husbandman 605374 605374 Cowper, George, of Brynton, husbandman 1
4100239 2060419 2060419 defendant Burder Margaret widow 605374 605374 Burder, Margaret, of Brynton, widow 0
4100240 2060419 2060419 defendant Burder John husbandman 605374 605374 Burder, John, of Brynton, husbandman 1
4180833 2088775 2088775 defendant Heyward John grocer 605374 605374 Heyward, John, of Brynton, grocer 0
4180834 2088775 2088775 defendant Heyward Thomas yeoman 605374 605374 Heyward, Thomas, of Brynton, yeoman 1
4385390 2159805 2159805 defendant Berryffe Edmund yeoman 605374 605374 Berryffe, Edmund, of Brynton, yeoman 0
4385391 2159805 2159805 defendant Beryffe Thomas yeoman 605374 605374 Beryffe, Thomas, of Brynton, yeoman 1
4390868 2161559 2161559 defendant Cotton Thomas husbandman 605374 605374 Cotton, Thomas, of Brynton, husbandman 0
4394469 2162747 2162747 defendant Beryffe Edmund yeoman 605374 605374 Beryffe, Edmund, of Brynton, yeoman 1
4612449 2234959 2234959 defendant Skye John tanner 605374 605374 Skye, John, of Brynton, tanner 0
4630691 2240500 2240500 defendant Sadeler Thomas   605374 605374 Sadeler, Thomas, of Brynton 13
4733874 2275778 2275778 defendant Colledyche William butcher 605374 605374 Colledyche, William, of Brynton, butcher 0
4783160 2290749 2290749 defendant Morell Robert baker 605374 605374 Morell, Robert, of Brynton, baker 0
4783163 2290750 2290750 defendant Morell Isabel   605374 605374 Morell, Isabel, of Brynton, servant 1
4844906 2309925 2309925 defendant Payce William   605374 605374 Payce, William, of Brynton, parson 4
4911855 2330211 2330211 defendant Bound Robert fuller 605374 605374 Bound, Robert, of Brynton, fuller 1
4949873 2341941 2341941 defendant Palle Robert husbandman 605374 605374 Palle, Robert, of Brynton, husbandman 7
4974652 2349385 2349385 defendant Turnour Richard husbandman 605374 605374 Turnour, Richard, of Brynton, husbandman 5
4974653 2349385 2349385 defendant Tournour Thomas husbandman 605374 605374 Tournour, Thomas, of Brynton, husbandman 6
4974654 2349385 2349385 defendant de Coweley Ralph gent 605374 605374 de Coweley, Ralph, of Brynton, gent 7
4974655 2349385 2349385 defendant Brynton Hugh husbandman 605374 605374 Brynton, Hugh, of Brynton, husbandman 8
5043203 2369587 2369587 defendant Repon John yeoman 605374 605374 Repon, John, of Brynton, yeoman 0
5043212 2369590 2369590 defendant Repon John yeoman 605374 605374 Repon, John, of Brynton, yeoman 0
5056023 2373373 2373373 plaintiff Repon John, junior husbandman 605374 605374 Repon, John, junior, of Brynton, husbandman 1
5096418 2385386 2385386 defendant Webster John husbandman 605374 605374 Webster, John, of Brynton, husbandman 0
5138815 2397852 2397852 defendant Sparowe William clerk 605374 605374 Sparowe, William, of Brynton, clerk 3
5154883 2402588 2402588 defendant Sparwe William clerk & rector 605374 605374 Sparwe, William, of Brynton, clerk & rector 0
5157796 2403406 2403406 defendant Mason John husbandman 605374 605374 Mason, John, of Brynton, husbandman 0
5173562 2407969 2407969 defendant Mason John husbandman 605374 605374 Mason, John, of Brynton, husbandman 0
5174932 2408364 2408364 defendant Sparowe William clerk 605374 605374 Sparowe, William, of Brynton, clerk 3
5208302 2418157 2418157 defendant Mason John husbandman 605374 605374 Mason, John, of Brynton, husbandman 0
5260973 2433551 2433551 defendant Sprotte Thomas husbandman 605374 605374 Sprotte, Thomas, of Brynton, husbandman 2
5269294 2436120 2436120 defendant Blofeld Robert husbandman 605374 605374 Blofeld, Robert, of Brynton, husbandman 0
5276718 2438273 2438273 defendant Wylles Peter   605374 605374 Wylles, Peter, of Brynton 1
5277489 2438496 2438496 plaintiff Ardern John clerk 605374 605374 Ardern, John, of Brynton, clerk 0
5277491 2438497 2438497 plaintiff Ardern John clerk 605374 605374 Ardern, John, of Brynton, clerk 0
5278630 2438860 2438860 defendant Lekke John husbandman 605374 605374 Lekke, John, of Brynton, husbandman 11
5282146 2439847 2439847 defendant Blofeld Robert laborer 605374 605374 Blofeld, Robert, of Brynton, laborer 8
5282158 2439848 2439848 defendant Blofeld Robert laborer 605374 605374 Blofeld, Robert, of Brynton, laborer 9
5296783 2444047 2444047 defendant Wyllys Peter husbandman 605374 605374 Wyllys, Peter, of Brynton, husbandman 2
5351210 2460472 2460472 defendant Lynstede Robert husbandman 605374 605374 Lynstede, Robert, of Brynton, husbandman 5
5352388 2460846 2460846 defendant Leyke John yeoman 605374 605374 Leyke, John, of Brynton, yeoman 1
5352389 2460846 2460846 defendant Sprotte Thomas yeoman 605374 605374 Sprotte, Thomas, of Brynton, yeoman 2
5354190 2461375 2461375 plaintiff Hardern John chaplain 605374 605374 Hardern, John, of Brynton, chaplain 0
5354194 2461376 2461376 plaintiff Hardern John chaplain 605374 605374 Hardern, John, of Brynton, chaplain 0
5413999 2479123 2479123 defendant Ardern John   605374 605374 Ardern, John, of Brynton 0
5477096 2498157 2498157 defendant Ardern John clerk & rector 605374 605374 Ardern, John, of Brynton, clerk & rector 0
5504325 2506267 2506267 defendant Butte William yeoman 605374 605374 Butte, William, of Brynton, yeoman 0
5564037 2524096 2524096 defendant Oculschawe John chaplain 605374 605374 Oculschawe, John, of Brynton, chaplain 0
5597556 2534135 2534135 defendant Whyte Roger courser 605374 605374 Whyte, Roger, of Brynton, courser 1
5617054 2549151 2549151 defendant Heryng John clerk 605374 605374 Heryng, John, of Brynton, clerk 0
5619176 2549846 2549846 defendant Heryng John clerk 605374 605374 Heryng, John, of Brynton, clerk 0
5619178 2549846 2549846 defendant Kenell William   605374 605374 Kenell, William, of Brynton 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);