names

56 rows where place_id = 599192

✎ 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
3635665 1905955 1905955 defendant Faldyngworth John husbandman 599192 599192 Faldyngworth, John, of Stykford, husbandman 0
3854385 1975010 1975010 defendant Wright John yeoman 599192 599192 Wright, John, of Stykford, yeoman 0
3906611 1992504 1992504 defendant Kyme John gent 599192 599192 Kyme, John, of Stykford, gent 3
3920379 1997158 1997158 defendant Kyme John gent 599192 599192 Kyme, John, of Stykford, gent 1
4484200 2195757 2195757 defendant Mose John   599192 599192 Mose, John, of Stykford 0
4485677 2196227 2196227 defendant Godson Thomas   599192 599192 Godson, Thomas, of Stykford, son of John 0
4538761 2212395 2212395 defendant Turnour John   599192 599192 Turnour, John, of Stykford 0
4543137 2213732 2213732 defendant Baly Robert   599192 599192 Baly, Robert, of stykford 2
4692631 2263211 2263211 defendant atte Marre John fishmonger 599192 599192 atte Marre, John, of Stykford, fishmonger 4
4702009 2266038 2266038 defendant Bikyr John laborer 599192 599192 Bikyr, John, of Stykford, laborer 0
4702517 2266200 2266200 plaintiff Hall Thomas   599192 599192 Hall, Thomas, of Stykford 0
4719683 2271504 2271504 plaintiff Boleyn William   599192 599192 Boleyn, William, of Stykford 0
4743672 2278678 2278678 plaintiff Hall Thomas   599192 599192 Hall, Thomas, of Stykford 2
4768241 2286038 2286038 defendant See William de gent 599192 599192 See, William de, of Stykford, gent 0
4772067 2287240 2287240 defendant Donyngton Richard   599192 599192 Donyngton, Richard, of Stykford, servant 0
4782869 2290662 2290662 defendant Crosseby Thomas husbandman 599192 599192 Crosseby, Thomas, of Stykford, husbandman 0
4792789 2293833 2293833 defendant de See William gent 599192 599192 de See, William, of Stykford, gent 0
4806951 2298378 2298378 defendant Mare John husbandman 599192 599192 Mare, John, of Stykford, husbandman 1
4806966 2298380 2298380 defendant atte Mare John husbandman 599192 599192 atte Mare, John, of Stykford, husbandman 1
4810773 2299493 2299493 defendant Browne Beatrice widow 599192 599192 Browne, Beatrice, of Stykford, widow 0
4821871 2302915 2302915 defendant Lark William fisher 599192 599192 Lark, William, of Stykford, fisher 0
4821910 2302926 2302926 defendant del See William (legal representative) 599192 599192 del See, William, of Stykford, gent, executors of 0
4890405 2323766 2323766 plaintiff Crosseby Thomas   599192 599192 Crosseby, Thomas, of Stykford 0
4890406 2323766 2323766 defendant Irreby Thomas   599192 599192 Irreby, Thomas, of Stykford, administrators of 0
4890407 2323766 2323766 defendant Berege Benedict fisher 599192 599192 (Berege, Benedict, of Stykford, fisher 1
4890408 2323766 2323766 defendant Irreby Joan widow 599192 599192 Irreby, Joan, of Stykford, widow 2
4955306 2343544 2343544 defendant Waynflete John fisher 599192 599192 Waynflete, John, of Stykford, fisher 0
4955307 2343544 2343544 defendant Drope William husbandman 599192 599192 Drope, William, of Stykford, husbandman 1
5012165 2360405 2360405 defendant Bamburgh John husbandman 599192 599192 Bamburgh, John, of Stykford, husbandman 2
5012166 2360405 2360405 defendant Larke John fishmonger 599192 599192 Larke, John, of Stykford, fishmonger 3
5012881 2360600 2360600 defendant Walker John fisher 599192 599192 Walker, John, of Stykford, fisher 0
5143727 2399297 2399297 plaintiff at Mare John   599192 599192 at Mare, John, of Stykford 0
5224096 2422727 2422727 defendant Smyth John husbandman 599192 599192 Smyth, John, of Stykford, husbandman 0
5224097 2422727 2422727 defendant Smyth Robert smith 599192 599192 Smyth, Robert, of Stykford, smith 1
5224867 2422944 2422944 defendant Croft John fisher 599192 599192 Croft, John, of Stykford, fisher 1
5227418 2423648 2423648 defendant Croft John fisher 599192 599192 Croft, John, of Stykford, fisher 2
5229228 2424158 2424158 defendant Fyn Richard fisher 599192 599192 Fyn, Richard, of Stykford, fisher 0
5239846 2427229 2427229 defendant Grebby Lawrence fisher 599192 599192 Grebby, Lawrence, of Stykford, fisher 0
5251147 2430463 2430463 plaintiff Wylliamson John (legal representative) 599192 599192 Wylliamson, John, of Stykford, gent, executors of 0
5277637 2438539 2438539 defendant Gregby William husbandman 599192 599192 Gregby, William, of Stykford, husbandman 0
5283439 2440211 2440211 defendant Lamson Robert husandman 599192 599192 Lamson, Robert, of Stykford, husandman 1
5288538 2441663 2441663 defendant Gregby William husbandman 599192 599192 Gregby, William, of Stykford, husbandman 0
5335257 2455613 2455613 defendant Grebby Lawrence husbandman 599192 599192 Grebby, Lawrence, of Stykford, husbandman 0
5344842 2458548 2458548 defendant Greggeby William yeoman 599192 599192 Greggeby, William, of Stykford, yeoman 0
5344843 2458548 2458548 defendant Greggeby Lawrence yeoman 599192 599192 Greggeby, Lawrence, of Stykford, yeoman 1
5353407 2461145 2461145 defendant Crane Thomas fisher 599192 599192 Crane, Thomas, of Stykford, fisher 0
5353876 2461280 2461280 defendant Fyn Thomas fisher 599192 599192 Fyn, Thomas, of Stykford, fisher 0
5353877 2461280 2461280 defendant Rynggotte Roger fisher 599192 599192 Rynggotte, Roger, of Stykford, fisher 1
5487069 2501030 2501030 defendant Jewetson John husbandman 599192 599192 Jewetson, John, of Stykford, husbandman 0
5487070 2501030 2501030 defendant Burton William husbandman 599192 599192 Burton, William, of Stykford, husbandman 1
5487071 2501030 2501030 defendant Lounde Henry husbandman 599192 599192 Lounde, Henry, of Stykford, husbandman 2
5537415 2516196 2516196 defendant Cley Robert clerk 599192 599192 Cley, Robert, of Stykford, clerk 0
5537416 2516196 2516196 defendant Cley John husbandman 599192 599192 Cley, John, of Stykford, husbandman 1
5537417 2516196 2516196 defendant Hewetson William fisher 599192 599192 Hewetson, William, of Stykford, fisher 2
5537418 2516196 2516196 defendant Byle Thomas fisher 599192 599192 Byle, Thomas, of Stykford, fisher 3
5576591 2527728 2527728 defendant Deryng Richard gent 599192 599192 Deryng, Richard, of Stykford, gent 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);