names

68 rows where place_id = 598624

✎ 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
3607981 1870148 1870148 defendant Justed John   598624 598624 Justed, John, of Bramford, wheel wright 0
3633345 1905243 1905243 defendant Sekylmer John husbandman 598624 598624 Sekylmer, John, of Bramford, husbandman 4
3646569 1909328 1909328 defendant Wade Thomas husbandman 598624 598624 Wade, Thomas, of Bramford, husbandman 0
3690526 1923202 1923202 defendant Cowper Robert yeoman 598624 598624 Cowper, Robert, of Bramford, yeoman 0
3730578 1935799 1935799 defendant Bantofte John husbandman 598624 598624 Bantofte, John, of Bramford, husbandman 0
3730579 1935799 1935799 defendant Bettys William husbandman 598624 598624 Bettys, William, of Bramford, husbandman 1
3730580 1935799 1935799 defendant Cok Edward husbandman 598624 598624 Cok, Edward, of Bramford, husbandman 2
3752310 1942647 1942647 defendant Goslyn Thomas miller 598624 598624 Goslyn, Thomas, of Bramford, miller 1
3787783 1953968 1953968 defendant Gostlyn Thomas miller 598624 598624 Gostlyn, Thomas, of Bramford, miller 1
3885664 1985463 1985463 plaintiff Bettys William husbandman 598624 598624 Bettys, William, of Bramford, husbandman 0
3906262 1992383 1992383 defendant Cooke Edward yeoman 598624 598624 Cooke, Edward, of Bramford, yeoman 1
3906263 1992383 1992383 defendant Gostlyn Thomas yeoman 598624 598624 Gostlyn, Thomas, of Bramford, yeoman 2
3923217 1998075 1998075 defendant Broke John husbandman 598624 598624 Broke, John, of Bramford, husbandman 4
3951801 2007690 2007690 defendant Barker Thomas yeoman 598624 598624 Barker, Thomas, of Bramford, yeoman 0
3953311 2008228 2008228 defendant Barker Thomas yeoman 598624 598624 Barker, Thomas, of Bramford, yeoman 0
3959770 2010510 2010510 defendant Barker Thomas yeoman 598624 598624 Barker, Thomas, of Bramford, yeoman 0
3981162 2018021 2018021 plaintiff Purpett John   598624 598624 Purpett, John, of Bramford 0
3988616 2020672 2020672 defendant Brooke John yeoman 598624 598624 Brooke, John, of Bramford, yeoman 1
4085203 2054992 2054992 defendant Baldrye Robert yeoman 598624 598624 Baldrye, Robert, of Bramford, yeoman 0
4110609 2064052 2064052 defendant Nycoll Erasmus gent 598624 598624 Nycoll, Erasmus, of Bramford, gent 1
4129738 2070946 2070946 defendant Barker Thomas yeoman 598624 598624 Barker, Thomas, of Bramford, yeoman 0
4215248 2100828 2100828 defendant Gardner John husbandman 598624 598624 Gardner, John, of Bramford, husbandman 0
4215250 2100829 2100829 defendant Gardner William husbandman 598624 598624 Gardner, William, of Bramford, husbandman 0
4222796 2103464 2103464 defendant Gardner William husbandman 598624 598624 Gardner, William, of Bramford, husbandman 0
4222797 2103464 2103464 defendant Gardner John husbandman 598624 598624 Gardner, John, of Bramford, husbandman 1
4247711 2112215 2112215 defendant Gardiner John yeoman 598624 598624 Gardiner, John, of Bramford, yeoman 0
4247712 2112215 2112215 defendant Gardiner William yeoman 598624 598624 Gardiner, William, of Bramford, yeoman 1
4275206 2121269 2121269 defendant Brooke Joohn, senior yeoman 598624 598624 Brooke, Joohn, senior, of Bramford, yeoman 0
4282433 2123756 2123756 defendant Gardyner John yeoman 598624 598624 Gardyner, John, of Bramford, yeoman 0
4282993 2123954 2123954 defendant Gardiner John husbandman 598624 598624 Gardiner, John, of Bramford, husbandman 0
4304375 2131667 2131667 defendant Colman Edward   598624 598624 Colman, Edward, of Bramford, "poldams" weaver 0
4307638 2132810 2132810 defendant Nicolls Philip Suff, gent 598624 598624 Nicolls Philip, of Bramford, Suff, gent 1
4385118 2159710 2159710 defendant Currant or Currance Richard joiner 598624 598624 Currant or Currance, Richard, of Bramford, or of Warneham, Sussex, joiner 0
4385119 2159710 2159710 defendant Pygen Robert joiner 598624 598624 Pygen, Robert, of Bramford, or of Cleybrooke, Leics, joiner 1
4444213 2183171 2183171 defendant Weme John   598624 598624 Weme, John, of Bramford 0
4455609 2186764 2186764 defendant Scot Richard   598624 598624 Scot, Richard, of Bramford 0
4457794 2187451 2187451 plaintiff Pod William   598624 598624 Pod, William, of Bramford 0
4465938 2190011 2190011 defendant Weyland John   598624 598624 Weyland, John, of Bramford 1
4704541 2266796 2266796 defendant Lolt William butcher 598624 598624 Lolt, William, of Bramford, butcher 0
4859335 2314300 2314300 defendant Brook William   598624 598624 Brook, William, of Bramford, mason 0
4910549 2329810 2329810 defendant Vyncent Thomas yeoman 598624 598624 Vyncent, Thomas, of Bramford, yeoman 0
4910550 2329810 2329810 defendant Walle Stephen husbandman 598624 598624 Walle, Stephen, of Bramford, husbandman 1
4917802 2332080 2332080 defendant Sterlyng John butcher 598624 598624 Sterlyng, John, of Bramford, butcher 1
5092094 2384063 2384063 defendant Bolton John gent 598624 598624 Bolton, John, of Bramford, gent 0
5101348 2386806 2386806 plaintiff atte Wode Thomas   598624 598624 atte Wode, Thomas, of Bramford 0
5245689 2428899 2428899 defendant Gegge Robert carpenter 598624 598624 Gegge, Robert, of Bramford, carpenter 0
5277387 2438465 2438465 defendant Byles William husbandman 598624 598624 Byles, William, of Bramford, husbandman 0
5340657 2457278 2457278 defendant Wareyn John yeoman 598624 598624 Wareyn, John, of Bramford, yeoman 2
5352688 2460931 2460931 defendant Utley John yeoman 598624 598624 Utley, John, of Bramford, yeoman 0
5357407 2462384 2462384 defendant Deye alias Fuller John husbandman 598624 598624 Deye alias Fuller, John, of Bramford, husbandman 0
5424794 2482374 2482374 defendant Byles William yeoman 598624 598624 Byles, William, of Bramford, yeoman 0
5433516 2484986 2484986 defendant Boure Thomas husbandman 598624 598624 Boure, Thomas, of Bramford, husbandman 1
5433519 2484987 2484987 defendant Boure Thomas husbandman 598624 598624 Boure, Thomas, of Bramford, husbandman 1
5433524 2484989 2484989 defendant Boure Thomas husbandman 598624 598624 Boure, Thomas, of Bramford, husbandman 1
5474227 2497266 2497266 defendant Rolston John husbandman 598624 598624 Rolston, John, of Bramford, husbandman 0
5475474 2497664 2497664 defendant Batayll Simon fuller 598624 598624 Batayll, Simon, of Bramford, fuller 0
5489073 2501612 2501612 defendant Wode John butcher 598624 598624 Wode, John, of Bramford, butcher 0
5494139 2503151 2503151 defendant Utley William ironmonger 598624 598624 Utley, William, of Bramford, yeoman, or of London, ironmonger 0
5495848 2503654 2503654 defendant Wode John butcher 598624 598624 Wode, John, of Bramford, butcher 0
5541919 2517591 2517591 defendant Byles William husbandman 598624 598624 Byles, William, of Bramford, husbandman 0
5549312 2519847 2519847 defendant Bacon John husbandman 598624 598624 Bacon, John, of Bramford, husbandman 0
5549314 2519848 2519848 defendant Bacon Thomas husbandman 598624 598624 Bacon, Thomas, of Bramford, husbandman 0
5555260 2521543 2521543 defendant Sekilmere John, junior husbandman 598624 598624 Sekilmere, John, junior, of Bramford, husbandman 0
5564882 2524314 2524314 defendant Melle John gent 598624 598624 Melle, John, of Bramford, gent 0
5581057 2529149 2529149 defendant Norreys Thomas butcher 598624 598624 Norreys, Thomas, of Bramford, butcher 0
5581058 2529149 2529149 defendant Norreys Robert laborer 598624 598624 Norreys, Robert, of Bramford, laborer 1
5597347 2534075 2534075 defendant Brenne Robert yeoman 598624 598624 Brenne, Robert, of Bramford, yeoman 0
5607157 2537127 2537127 defendant Parker Thomas husbandman 598624 598624 Parker, Thomas, of Bramford, 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);