names

60 rows where place_id = 589562

✎ 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
3598003 1866999 1866999 defendant Paton John yeoman 589562 589562 Paton, John, of Bromeham, yeoman 0
3626935 1903276 1903276 defendant Bayly John yeoman 589562 589562 Bayly, John, of Bromeham, yeoman 0
3666513 1915466 1915466 defendant Prater Robert husbandman 589562 589562 Prater, Robert, of Bromeham, husbandman 0
3689054 1922739 1922739 plaintiff Dyve John   589562 589562 Dyve, John, of Bromeham, knight 0
3722606 1933330 1933330 defendant Beste John husbandman 589562 589562 Beste, John, of Bromeham, husbandman 0
3756407 1943976 1943976 defendant Uffenham Richard gent 589562 589562 Uffenham, Richard, of Bromeham, gent 0
3756411 1943977 1943977 defendant Uffenham Richard gent 589562 589562 Uffenham, Richard, of Bromeham, gent 0
3764223 1946464 1946464 defendant Hunt John, junior husbandman 589562 589562 Hunt, John, junior, of Bromeham, husbandman 0
3774344 1949698 1949698 defendant Uffenham Richard gent 589562 589562 Uffenham, Richard, of Bromeham, gent 0
3851840 1974168 1974168 defendant Boswell Henry clerk 589562 589562 Boswell, Henry, of Bromeham, clerk 0
3851841 1974168 1974168 defendant Stokys Richard husbandman 589562 589562 Stokys, Richard, of Bromeham, husbandman 1
3851842 1974168 1974168 defendant Paton Henry husbandman 589562 589562 Paton, Henry, of Bromeham, husbandman 2
3851843 1974168 1974168 defendant Stokes Henry husbandman 589562 589562 Stokes, Henry, of Bromeham, husbandman 3
3851844 1974168 1974168 defendant Stokes Thomas laborer 589562 589562 Stokes, Thomas, of Bromeham, laborer 4
3896067 1988888 1988888 defendant Mender Thomas clerk 589562 589562 Mender, Thomas, of Bromeham, clerk 1
3966018 2012738 2012738 defendant Baynton Henry esq 589562 589562 Baynton, Henry, of Bromeham, esq 1
3989290 2020911 2020911 plaintiff Ballard Thomas husbandman 589562 589562 Ballard, Thomas, of Bromeham, husbandman 0
4029918 2035343 2035343 defendant Bayneton Henry esq 589562 589562 Bayneton, Henry, of Bromeham, esq 0
4040054 2038942 2038942 defendant Dalmer George yeoman 589562 589562 Dalmer, George, of Bromeham, yeoman 1
4077180 2052123 2052123 defendant Baynton Henry esq 589562 589562 Baynton, Henry, of Bromeham, esq 0
4186345 2090710 2090710 defendant Smythe Oliver husbandman 589562 589562 Smythe, Oliver, of Bromeham, husbandman 0
4278290 2122345 2122345 defendant Longe Edward yeoman 589562 589562 Longe, Edward, of Bromeham, yeoman 0
4278291 2122345 2122345 defendant Slade John yeoman 589562 589562 Slade, John, of Bromeham, yeoman 1
4278292 2122345 2122345 defendant Rawlyng Henry yeoman 589562 589562 Rawlyng, Henry, of Bromeham, yeoman 2
4280320 2123020 2123020 defendant Burde Oswald yeoman 589562 589562 Burde, Oswald, of Bromeham, yeoman 0
4370042 2154342 2154342 defendant Chaundelor John yeoman 589562 589562 Chaundelor, John, of Bromeham, yeoman 0
4377509 2157033 2157033 defendant Butler alias Rawlyns Henry weaver 589562 589562 Butler alias Rawlyns, Henry, of Bromeham, weaver 1
4604801 2232669 2232669 plaintiff Abraham Thomas   589562 589562 Abraham, Thomas, of Bromeham 0
4604802 2232669 2232669 defendant Pertenale John   589562 589562 Pertenale, John, of Bromeham 0
4635521 2241968 2241968 plaintiff Abraham Thomas   589562 589562 Abraham, Thomas, of Bromeham 0
4635522 2241968 2241968 defendant Pertenale John   589562 589562 Pertenale, John, of Bromeham 0
4636503 2242248 2242248 defendant Orberd Robert   589562 589562 Orberd, Robert, of Bromeham 5
4636505 2242249 2242249 plaintiff Webbe John   589562 589562 Webbe, John, of Bromeham 1
4669527 2256175 2256175 defendant atte Persones Richard farmer 589562 589562 atte Persones, Richard, of Bromeham, farmer 0
4669528 2256175 2256175 defendant Marche Thomas husbandman 589562 589562 Marche, Thomas, of Bromeham, husbandman 1
4674037 2257490 2257490 defendant Ussher Thomas milner 589562 589562 Ussher, Thomas, of Bromeham, milner 2
4804029 2297442 2297442 defendant Bailly John husbandman 589562 589562 Bailly, John, of Bromeham, husbandman 0
5102956 2387287 2387287 defendant Bryggys Joan widow 589562 589562 together with Bryggys, Joan, of Bromeham, widow 2
5140895 2398453 2398453 defendant Wyot John husbandman 589562 589562 Wyot, John, of Bromeham, husbandman 1
5228613 2423978 2423978 defendant Wyot John yeoman 589562 589562 Wyot, John, of Bromeham, yeoman 0
5228618 2423979 2423979 defendant Wyot John yeoman 589562 589562 Wyot, John, of Bromeham, yeoman 0
5258089 2432647 2432647 defendant Stokes Henry husbandman 589562 589562 together with Stokes, Henry, of Bromeham, husbandman 1
5258091 2432647 2432647 defendant Paton Thomas husbandman 589562 589562 Paton, Thomas, of Bromeham, husbandman 3
5258092 2432647 2432647 defendant Baron John husbandman 589562 589562 Baron, John, of Bromeham, husbandman 4
5258094 2432648 2432648 defendant Stokes Henry husbandman 589562 589562 Stokes, Henry, of Bromeham, husbandman 0
5258096 2432648 2432648 defendant Paton Thomas husbandman 589562 589562 Paton, Thomas, of Bromeham, husbandman 2
5258097 2432648 2432648 defendant Baron John husbandman 589562 589562 Baron, John, of Bromeham, husbandman 3
5377577 2468570 2468570 defendant Paton John yeoman 589562 589562 Paton, John, of Bromeham, yeoman 1
5378607 2468893 2468893 defendant Paton Thomas yeoman 589562 589562 Paton, Thomas, of Bromeham, yeoman 0
5480735 2499200 2499200 defendant Alyson William husbandman 589562 589562 Alyson, William, of Bromeham, husbandman 0
5480736 2499200 2499200 defendant Padon John yeoman 589562 589562 Padon, John, of Bromeham, yeoman 1
5496129 2503739 2503739 defendant Jorden John clerk 589562 589562 Jorden, John, of Bromeham, clerk 1
5509232 2507745 2507745 defendant Padon John husbandman 589562 589562 Padon, John, of Bromeham, husbandman 0
5509234 2507745 2507745 defendant Aleynson William husbandman 589562 589562 Aleynson, William, of Bromeham, husbandman 2
5529895 2513855 2513855 defendant Paton William yeoman 589562 589562 Paton, William, of Bromeham, yeoman 0
5529896 2513855 2513855 defendant Hyll Thomas husbandman 589562 589562 Hyll, Thomas, of Bromeham, husbandman 1
5529897 2513855 2513855 defendant Pertnale John huusbandman 589562 589562 Pertnale, John, of Bromeham, huusbandman 2
5550073 2520058 2520058 defendant Rudyate Thomas husbandman 589562 589562 Rudyate, Thomas, of Bromeham, husbandman 1
5550074 2520058 2520058 defendant Paton William yeoman 589562 589562 Paton, William, of Bromeham, yeoman 2
5567223 2524990 2524990 defendant Paton William yeoman 589562 589562 Paton, William, of Bromeham, yeoman 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);