names

72 rows where place_id = 649539

✎ 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
3602870 1868565 1868565 defendant Baysboll Robert (legal representative) 649539 649539 Baysboll, Robert, of Gosberkirke, husbandman, executors of 0
3907183 1992694 1992694 defendant Kirke John thatcher 649539 649539 Kirke, John, of Gosberkirke, thatcher 0
3907195 1992697 1992697 defendant Surflett John yeoman 649539 649539 Surflett, John, of Gosberkirke, yeoman 0
4274573 2121049 2121049 defendant Pell Anthony husbandman 649539 649539 Pell, Anthony, of Gosberkirke, husbandman 3
4276434 2121701 2121701 defendant Death Roger gent 649539 649539 Death, Roger, of Gosberkirke, gent 0
4368564 2153805 2153805 defendant Archer Thomas husbandman 649539 649539 Archer, Thomas, of Gosberkirke, husbandman 0
4368565 2153805 2153805 defendant Deacon Thomas husbandman 649539 649539 Deacon, Thomas, of Gosberkirke, husbandman 1
4374604 2155978 2155978 defendant Allen Robert yeoman 649539 649539 Allen, Robert, of Gosberkirke, yeoman 0
4374605 2155978 2155978 defendant Ged- Thomas laborer 649539 649539 Ged-, Thomas, of Gosberkirke, laborer 1
4375867 2156429 2156429 defendant Preston John yeoman 649539 649539 Preston, John, of Gosberkirke, or of Spaldinge, yeoman 2
4446695 2183884 2183884 plaintiff Dey William   649539 649539 Dey, William, of Gosberkirke 0
4449744 2184871 2184871 defendant Verdon John   649539 649539 Verdon, John, of Gosberkirke 0
4465644 2189929 2189929 defendant Smyth John   649539 649539 Smyth, John, of Gosberkirke, son of William 0
4470123 2191308 2191308 plaintiff Brayles William   649539 649539 Brayles, William, of Gosberkirke 0
4474338 2192628 2192628 plaintiff Dey William (legal representative) 649539 649539 Dey, William, of Gosberkirke, executors of 0
4488835 2197225 2197225 plaintiff Sybbarey Richard   649539 649539 Sybbarey, Richard, of Gosberkirke 0
4510696 2203803 2203803 defendant Echard John   649539 649539 Echard, John, of Gosberkirke 0
4514009 2204803 2204803 defendant Dey John   649539 649539 Dey, John, of Gosberkirke 0
4514016 2204805 2204805 defendant Smyth Thomas   649539 649539 Smyth, Thomas, of Gosberkirke 0
4526857 2208677 2208677 defendant Dey John   649539 649539 Dey, John, of Gosberkirke 0
4531731 2210187 2210187 defendant Deye John   649539 649539 Deye, John, of Gosberkirke 0
4539216 2212522 2212522 plaintiff Verdon Thomas   649539 649539 Verdon, Thomas, of Gosberkirke 0
4589008 2227938 2227938 plaintiff Launde Thomas de la   649539 649539 Launde, Thomas de la, of Gosberkirke 0
4599521 2231066 2231066 plaintiff Sutton Robert   649539 649539 Sutton, Robert, of Gosberkirke 0
4649980 2246011 2246011 defendant Alisaunder John (legal representative) 649539 649539 Alisaunder, John, of Gosberkirke, executor of 0
4659779 2248909 2248909 plaintiff de la Launde Thomas   649539 649539 de la Launde, Thomas, of Gosberkirke 0
4669516 2256171 2256171 defendant Peney Lambert   649539 649539 Peney, Lambert, of Gosberkirke, salt weller 0
4807044 2298400 2298400 defendant Spark Robert husbandman 649539 649539 Spark, Robert, of Gosberkirke, husbandman 0
4807045 2298400 2298400 defendant Spark William husbandman 649539 649539 Spark, William, of Gosberkirke, husbandman 1
4884663 2322114 2322114 defendant Whitebrede Richard yeoman 649539 649539 Whitebrede, Richard, of Gosberkirke, yeoman 0
4884664 2322114 2322114 defendant Verdon Thomas husbandman 649539 649539 Verdon, Thomas, of Gosberkirke, husbandman 1
4884665 2322114 2322114 defendant Honnyngham John husbandman 649539 649539 Honnyngham, John, of Gosberkirke, husbandman 2
4890415 2323768 2323768 defendant Swete William husbandman 649539 649539 Swete, William, of Gosberkirke, husbandman 0
4914716 2331118 2331118 defendant Robert John yeoman 649539 649539 Robert, John, of Gosberkirke, yeoman 0
4926352 2334667 2334667 defendant Flayn Walter husbandman 649539 649539 Flayn, Walter, of Gosberkirke, husbandman 2
4926353 2334667 2334667 defendant Bonde Thomas husbandman 649539 649539 Bonde, Thomas, of Gosberkirke, husbandman 3
4926360 2334668 2334668 defendant Dode William husbandman 649539 649539 Dode, William, of Gosberkirke, husbandman 0
4926362 2334668 2334668 defendant Basbull Gilbert husbandman 649539 649539 Basbull, Gilbert, of Gosberkirke, husbandman 2
4931105 2336118 2336118 defendant Warde Gillbert   649539 649539 Warde, Gillbert, of Gosberkirke 8
4931106 2336118 2336118 defendant Pynke John mercer 649539 649539 Pynke, John, of Gosberkirke, mercer 9
4931107 2336118 2336118 defendant Fraunceys Thomas   649539 649539 Fraunceys, Thomas, of Gosberkirke 10
4931108 2336118 2336118 defendant Sparke Robert   649539 649539 Sparke, Robert, of Gosberkirke 11
4931109 2336118 2336118 defendant Cobden Robert   649539 649539 Cobden, Robert, of Gosberkirke 12
4931110 2336118 2336118 defendant Magotson William   649539 649539 Magotson, William, of Gosberkirke 13
4931111 2336118 2336118 defendant German Thomas   649539 649539 German, Thomas, of Gosberkirke 14
4931112 2336118 2336118 defendant Flayne Walter   649539 649539 Flayne, Walter, of Gosberkirke 15
4931113 2336118 2336118 defendant Grene Robert   649539 649539 Grene, Robert, of Gosberkirke 16
4931114 2336118 2336118 defendant Leper Simon   649539 649539 Leper, Simon, of Gosberkirke 17
4931115 2336118 2336118 defendant Draper Richard   649539 649539 Draper, Richard, of Gosberkirke 18
4976035 2349797 2349797 defendant German Thomas husbandman 649539 649539 German, Thomas, of Gosberkirke, husbandman 9
4982937 2351812 2351812 defendant German Thomas husbandman 649539 649539 German, Thomas, of Gosberkirke, husbandman 0
4982938 2351812 2351812 defendant Spanby William husbandman 649539 649539 Spanby, William, of Gosberkirke, husbandman 1
5020526 2362892 2362892 defendant Rugwyne Robert husbandman 649539 649539 Rugwyne, Robert, of Gosberkirke, husbandman 0
5020527 2362892 2362892 defendant Cheyle William husbandman 649539 649539 Cheyle, William, of Gosberkirke, husbandman 1
5020528 2362892 2362892 defendant Floweter Thomas chaplain 649539 649539 Floweter, Thomas, of Gosberkirke, chaplain 2
5020530 2362892 2362892 defendant Floweter John husbandman 649539 649539 Floweter, John, of Gosberkirke, husbandman 4
5077641 2379809 2379809 defendant Alisaunder John husbandman 649539 649539 Alisaunder, John, of Gosberkirke, husbandman 0
5097402 2385671 2385671 plaintiff Thakker John (legal representative) 649539 649539 Thakker, John, of Gosberkirke, husbandman, executors of 0
5106256 2388267 2388267 defendant Grene Robert husbandman 649539 649539 Grene, Robert, of Gosberkirke, husbandman 1
5143378 2399203 2399203 plaintiff Alisaunder William   649539 649539 Alisaunder, William, of Gosberkirke, husbandman, administrators of 0
5143381 2399203 2399203 defendant Bocher John butcher 649539 649539 Bocher, John, of Gosberkirke, butcher 0
5177998 2409271 2409271 plaintiff Alisaunder William   649539 649539 Alisaunder, William, of Gosberkirke, husbandman, administrators of 0
5178001 2409271 2409271 defendant Bocher John butcher 649539 649539 Bocher, John, of Gosberkirke, butcher 0
5179819 2409835 2409835 defendant Sareson Gilbert husbandman 649539 649539 Sareson, Gilbert, of Gosberkirke, husbandman 0
5179820 2409835 2409835 defendant Grene Robert husbandman 649539 649539 Grene, Robert, of Gosberkirke, husbandman 1
5179821 2409835 2409835 defendant Drury Thomas husbandman 649539 649539 Drury, Thomas, of Gosberkirke, husbandman 2
5179822 2409835 2409835 defendant Bocher John butcher 649539 649539 Bocher, John, of Gosberkirke, butcher 3
5179823 2409835 2409835 defendant Philipot Thomas husbandman 649539 649539 Philipot, Thomas, of Gosberkirke, husbandman 4
5250531 2430274 2430274 defendant Heggehoke John   649539 649539 Heggehoke, John, of Gosberkirke, shepherd, 0
5377078 2468419 2468419 defendant Dousyng Simon husbandman 649539 649539 Dousyng, Simon, of Gosberkirke, husbandman 1
5410410 2478063 2478063 plaintiff Hompe Robert   649539 649539 Hompe, Robert, of Gosberkirke 2
5481183 2499325 2499325 defendant Anderton Thomas yeoman 649539 649539 Anderton, Thomas, of Gosberkirke, yeoman 1

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);