names

67 rows where place_id = 593327

✎ 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
3603571 1868787 1868787 defendant Barcum Edmund   593327 593327 Barcum, Edmund, of Horsford, tile burner 0
3611355 1871224 1871224 defendant Gerard Nicholas husbandman 593327 593327 Gerard, Nicholas, of Horsford, husbandman 0
3623838 1874985 1874985 defendant Myddelton Thomas gent 593327 593327 Myddelton, Thomas, of Horsford, gent 1
3623841 1874985 1874985 defendant Garrard Simon husbandman 593327 593327 Garrard, Simon, of Horsford, husbandman 4
3625532 1875524 1875524 defendant Woderove John husbandman 593327 593327 Woderove, John, of Horsford, husbandman 1
3654604 1911702 1911702 defendant Rowell Robert husbandman 593327 593327 Rowell, Robert, of Horsford, husbandman 1
3662194 1914091 1914091 defendant Wodehous John gent 593327 593327 Wodehous, John, of Horsford, gent 2
3709703 1929346 1929346 plaintiff Reve John husbandman 593327 593327 Reve, John, of Horsford, husbandman 0
3877183 1982609 1982609 defendant Baymont Robert butcher 593327 593327 Baymont, Robert, of Horsford, butcher 0
3893905 1988184 1988184 defendant Chapman Robert husbandman 593327 593327 Chapman, Robert, of Horsford, husbandman 0
3899430 1990023 1990023 defendant Rose John husbandman 593327 593327 Rose, John, of Horsford, husbandman 0
3908156 1993025 1993025 plaintiff Pye Nicholas   593327 593327 Pye, Nicholas, of Horsford 0
3966677 2012982 2012982 defendant Bulleyne John husbandman 593327 593327 Bulleyne, John, of Horsford, husbandman 0
3966679 2012982 2012982 defendant Rawlyng John (legal representative) 593327 593327 Rawlyng, John, of Horsford, husbandman, executor of 2
3977197 2016594 2016594 defendant Kyng Thomas husbandman 593327 593327 Kyng, Thomas, of Horsford, husbandman 0
4032010 2036117 2036117 plaintiff Fuller Richard yeoman 593327 593327 Fuller, Richard, of Horsford, yeoman 0
4032011 2036117 2036117 defendant Wilkinson Henry husbandman 593327 593327 Wilkinson, Henry, of Horsford, husbandman 0
4032013 2036118 2036118 defendant Wylkynson Henry husbandman 593327 593327 Wylkynson, Henry, of Horsford, husbandman 0
4046603 2041236 2041236 defendant Rybett Thomas husbandman 593327 593327 Rybett, Thomas, of Horsford, husbandman 2
4098709 2059870 2059870 defendant Baxter Richard yeoman 593327 593327 Baxter, Richard, of Horsford, yeoman 3
4098714 2059871 2059871 defendant Baxter Richard yeoman 593327 593327 Baxter, Richard, of Horsford, yeoman 3
4192243 2092850 2092850 defendant Wade John yeoman 593327 593327 Wade, John, of Horsford, yeoman 3
4209104 2098734 2098734 defendant Kempe James husbandman 593327 593327 Kempe, James, of Horsford, husbandman 2
4222308 2103293 2103293 defendant Brett Edward yeoman 593327 593327 Brett, Edward, of Horsford, yeoman 0
4230871 2106295 2106295 defendant Blenerhassett Thomas gent 593327 593327 Blenerhassett, Thomas, of Horsford, gent 0
4269779 2119481 2119481 defendant Powell John blacksmith 593327 593327 Powell, John, of Horsford, blacksmith 0
4281496 2123430 2123430 defendant Jarrett Thomas yeoman 593327 593327 Jarrett, Thomas, of Horsford, yeoman 1
4282416 2123749 2123749 defendant Morgayne John husbandman 593327 593327 Morgayne, John, of Horsford, husbandman 2
4334985 2141968 2141968 defendant Jeppes or Joppes Stephen   593327 593327 Jeppes or Joppes, Stephen, of Horsford, worsted weaver 0
4336984 2142662 2142662 defendant Elmeden Robert clerk 593327 593327 Elmeden, Robert, of Horsford, clerk 0
4362809 2151758 2151758 defendant Robertes William yeoman 593327 593327 Robertes, William, of Horsford, yeoman 0
4362811 2151759 2151759 defendant Robertes William yeoman 593327 593327 Robertes, William, of Horsford, yeoman 0
4446405 2183792 2183792 plaintiff del Kychyn John   593327 593327 del Kychyn, John, of Horsford 0
4446406 2183792 2183792 defendant Elsewyk Thomas de   593327 593327 Elsewyk, Thomas de, of Horsford 0
4464583 2189593 2189593 plaintiff Wayte Robert   593327 593327 Wayte, Robert, of Horsford 0
4563197 2220060 2220060 defendant Spynk William   593327 593327 Spynk, William, of Horsford 0
4723141 2272548 2272548 defendant Dousyng Robert husbandman 593327 593327 Dousyng, Robert, of Horsford, husbandman 0
4723142 2272548 2272548 defendant Skot Thomas husbandman 593327 593327 Skot, Thomas, of Horsford, husbandman 1
4790648 2293162 2293162 defendant Bate William husbandman 593327 593327 Bate, William, of Horsford, husbandman 1
4790881 2293238 2293238 defendant Bate William husbandman 593327 593327 Bate, William, of Horsford, husbandman 1
4814953 2300787 2300787 defendant del Brene Thomas gent 593327 593327 with del Brene, Thomas, of Horsford, gent 1
4815058 2300822 2300822 defendant del Grene Thomas gent 593327 593327 del Grene, Thomas, of Horsford, gent 0
4841653 2308920 2308920 defendant del Grene Thomas gent 593327 593327 del Grene, Thomas, of Horsford, gent 0
4854600 2312817 2312817 defendant Robert John husbandman 593327 593327 Robert, John, of Horsford, husbandman 2
4868978 2317271 2317271 defendant del Grene Thomas gent 593327 593327 del Grene, Thomas, of Horsford, gent 0
4904867 2328122 2328122 defendant del Grene Thomas gent 593327 593327 del Grene, Thomas, of Horsford, gent 0
5043085 2369548 2369548 defendant Skut John husbandman 593327 593327 Skut, John, of Horsford, husbandman 2
5063122 2375506 2375506 defendant Vynte John husbandman 593327 593327 Vynte, John, of Horsford, husbandman 0
5110003 2389353 2389353 defendant Colyngworth Richard husbandman 593327 593327 Colyngworth, Richard, of Horsford, husbandman 4
5121705 2392777 2392777 defendant Rous Stephen miller 593327 593327 Rous, Stephen, of Horsford, miller 0
5231201 2424725 2424725 defendant Adamson John husbandman 593327 593327 Adamson, John, of Horsford, husbandman 0
5325346 2452667 2452667 defendant Barker Henry loader 593327 593327 Barker, Henry, of Horsford, loader 2
5342006 2457689 2457689 defendant Fynte Robert husbandman 593327 593327 Fynte, Robert, of Horsford, husbandman 3
5352424 2460859 2460859 defendant Coweper William yeoman 593327 593327 Coweper, William, of Horsford, yeoman 0
5352426 2460860 2460860 defendant Coweper William yeoman 593327 593327 Coweper, William, of Horsford, yeoman 0
5363742 2464312 2464312 defendant Barker Henry husbandman 593327 593327 Barker, Henry, of Horsford, husbandman 4
5438725 2486513 2486513 defendant Fyncent Robert husbandman 593327 593327 Fyncent, Robert, of Horsford, husbandman 2
5450985 2490186 2490186 defendant Dorylot William warrener 593327 593327 Dorylot, William, of Horsford, warrener 0
5452628 2490670 2490670 defendant Fyncent Robert husbandman 593327 593327 Fyncent, Robert, of Horsford, husbandman 2
5474465 2497345 2497345 defendant Dorylet John warrener 593327 593327 Dorylet, John, of Horsford, warrener 0
5496518 2503869 2503869 defendant Fonte Robert husbandman 593327 593327 Fonte, Robert, of Horsford, husbandman 1
5531856 2514508 2514508 defendant Dolorec Simon husbandman 593327 593327 Dolorec, Simon, of Horsford, husbandman 1
5531857 2514508 2514508 defendant Flynt John husbandman 593327 593327 Flynt, John, of Horsford, husbandman 2
5531858 2514508 2514508 defendant Baker Robert husbandman 593327 593327 Baker, Robert, of Horsford, husbandman 3
5531859 2514508 2514508 defendant Chapman John husbandman 593327 593327 Chapman, John, of Horsford, husbandman 4
5555542 2521618 2521618 defendant Medelton Thomas gent 593327 593327 Medelton, Thomas, of Horsford, gent 3
5578213 2528257 2528257 defendant Broune Henry husbandman 593327 593327 Broune, Henry, of Horsford, 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);