names

107 rows where place_id = 717501

✎ 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
4043064 2039986 2039986 defendant Allen William husbandman 717501 717501 Allen, William, of Sittingbourne, or of Borden, husbandman 0
4219942 2102477 2102477 defendant Effeld George yeoman 717501 717501 Effeld, George, of Sittingbourne, yeoman 0
4532492 2210430 2210430 defendant Trippe William shoemaker 717501 717501 Trippe, William, of Sittingbourne, shoemaker 1
4533237 2210655 2210655 defendant Nicholas John   717501 717501 Nicholas, John, of Sittingbourne 1
4548334 2215421 2215421 defendant Rook John   717501 717501 Rook, John, of Sittingbourne 8
4548335 2215421 2215421 defendant Tryppe Willaim   717501 717501 Tryppe, Willaim, of Sittingbourne 9
4548336 2215421 2215421 defendant Heghstede John   717501 717501 Heghstede, John, of Sittingbourne 10
4551967 2216564 2216564 defendant Taillour John   717501 717501 Taillour, John, of Sittingbourne 1
4552427 2216713 2216713 defendant Crouche William weaver 717501 717501 Crouche, William, of Sittingbourne, weaver 0
4581606 2225695 2225695 defendant Kyryel John   717501 717501 Kyryel, John, of Sittingbourne 0
4583988 2226410 2226410 defendant Wolleman James   717501 717501 Wolleman, James, of Sittingbourne 2
4585020 2226740 2226740 defendant Swyfft John   717501 717501 Swyfft, John, of Sittingbourne 3
4628574 2239861 2239861 defendant Roke John   717501 717501 Roke, John, of Sittingbourne 0
4642784 2244001 2244001 defendant Tryte John   717501 717501 Tryte, John, of Sittingbourne 0
4647844 2245435 2245435 defendant Heghstede Hugh   717501 717501 Heghstede, Hugh, of Sittingbourne 0
4649027 2245763 2245763 defendant Rook John   717501 717501 Rook, John, of Sittingbourne 0
4649029 2245764 2245764 defendant Rook John   717501 717501 Rook, John, of Sittingbourne 0
4700367 2265530 2265530 defendant Rook John yeoman 717501 717501 Rook, John, of Sittingbourne, yeoman 0
4729136 2274340 2274340 defendant Denys John   717501 717501 Denys, John, of Sittingbourne 0
4729470 2274428 2274428 defendant Rook John hosteller 717501 717501 Rook, John, of Sittingbourne, hosteller 3
4763318 2284514 2284514 defendant Heyward William gent 717501 717501 Heyward, William, of Sittingbourne, gent 0
4772392 2287331 2287331 defendant Tyrell Stephen husbandman 717501 717501 Tyrell, Stephen, of Sittingbourne, husbandman 0
4773815 2287788 2287788 defendant Moer Richard weaver 717501 717501 Moer, Richard, of Sittingbourne, weaver 0
4774278 2287937 2287937 defendant Goldsmith Thomas husbandman 717501 717501 Goldsmith, Thomas, of Sittingbourne, husbandman 1
4806309 2298182 2298182 defendant Kyppyng Robert   717501 717501 Kyppyng, Robert, of Sittingbourne 0
4818868 2301984 2301984 defendant Groveherst Richard husbandman 717501 717501 (Groveherst, Richard, of Sittingbourne, husbandman 1
4839921 2308398 2308398 defendant Getyn William laborer 717501 717501 Getyn, William, of Sittingbourne, laborer 0
4840337 2308523 2308523 defendant Latter Henry carpenter 717501 717501 Latter, Henry, of Sittingbourne, carpenter 3
4848385 2310965 2310965 defendant Barker John husbandman 717501 717501 Barker, John, of Sittingbourne, husbandman 0
4849245 2311240 2311240 plaintiff Symkyn John   717501 717501 Symkyn, John, of Sittingbourne 1
4851383 2311878 2311878 defendant Bever Thomas laborer 717501 717501 Bever, Thomas, of Sittingbourne, laborer 1
4912228 2330325 2330325 defendant Gerard Philip yeoman 717501 717501 Gerard, Philip, of Sittingbourne, yeoman 0
4916518 2331672 2331672 defendant Faunt Thomas baker 717501 717501 Faunt, Thomas, of Sittingbourne, baker 1
4997558 2356122 2356122 defendant Munde William   717501 717501 Munde, William, of Sittingbourne, bailiff 1
5005225 2358425 2358425 defendant Role William gent 717501 717501 Role, William, of Sittingbourne, gent 0
5047997 2371022 2371022 defendant Bernard John laborer 717501 717501 Bernard, John, of Sittingbourne, laborer 0
5050317 2371719 2371719 defendant Kayme William gent 717501 717501 Kayme, William, of Sittingbourne, gent 0
5125341 2393894 2393894 defendant Kyng John hosteler 717501 717501 Kyng, John, of Sittingbourne, hosteler 0
5125342 2393894 2393894 defendant Scot Reginald husbandman 717501 717501 Scot, Reginald, of Sittingbourne, husbandman 1
5131704 2395756 2395756 defendant Stotte Reginald husbandman 717501 717501 Stotte, Reginald, of Sittingbourne, husbandman 0
5133579 2396314 2396314 defendant Cotyng John husbandman 717501 717501 Cotyng, John, of Sittingbourne, husbandman 0
5133580 2396314 2396314 defendant Noke John husbandman 717501 717501 Noke, John, of Sittingbourne, husbandman 1
5137179 2397387 2397387 defendant Crouche William tanner 717501 717501 Crouche, William, of Sittingbourne, tanner 0
5148478 2400682 2400682 defendant Barker William yeoman 717501 717501 Barker, William, of Sittingbourne, yeoman 2
5148479 2400682 2400682 defendant Barker Roger yeoman 717501 717501 Barker, Roger, of Sittingbourne, yeoman 3
5150060 2401153 2401153 defendant Andrewe Richard yeoman 717501 717501 Andrewe, Richard, of Sittingbourne, yeoman 0
5151230 2401504 2401504 defendant Scotte Reginald husbandman 717501 717501 Scotte, Reginald, of Sittingbourne, husbandman 0
5151482 2401583 2401583 defendant Lovell Laurence   717501 717501 Lovell, Laurence, of Sittingbourne, stainer, administrators of 0
5157858 2403424 2403424 defendant Crouche William tanner 717501 717501 Crouche, William, of Sittingbourne, tanner 0
5158096 2403491 2403491 plaintiff Polyver John (legal representative) 717501 717501 Polyver, John, of Sittingbourne, executors of 0
5158100 2403491 2403491 defendant Burbroke Nicholas husbandman 717501 717501 Burbroke, Nicholas, of Sittingbourne, husbandman 0
5164960 2405488 2405488 defendant Scot Reginald husbandman 717501 717501 Scot, Reginald, of Sittingbourne, husbandman 0
5166050 2405814 2405814 defendant Husee John esq 717501 717501 Husee, John, of Sittingbourne, esq 0
5167757 2406284 2406284 defendant Mathewe John   717501 717501 Mathewe, John, of Sittingbourne, cook 1
5167762 2406285 2406285 defendant Umfrey John   717501 717501 Umfrey, John, of Sittingbourne, franklin 1
5167763 2406285 2406285 defendant Mayhewe Thomas husbandman 717501 717501 Mayhewe, Thomas, of Sittingbourne, husbandman 2
5167766 2406286 2406286 defendant Umfrey John   717501 717501 Umfrey, John, of Sittingbourne, franklin 1
5167767 2406286 2406286 defendant Mayhewe Thomas husbandman 717501 717501 Mayhewe, Thomas, of Sittingbourne, husbandman 2
5168754 2406590 2406590 defendant Andrewe Richard yeoman 717501 717501 Andrewe, Richard, of Sittingbourne, yeoman 0
5173083 2407837 2407837 defendant Hagley Thomas chapman 717501 717501 Hagley, Thomas, of Sittingbourne, chapman 1
5173084 2407837 2407837 defendant Drory Roger chapman 717501 717501 Drory, Roger, of Sittingbourne, chapman 2
5173616 2407983 2407983 defendant Crouche William tanner 717501 717501 Crouche, William, of Sittingbourne, tanner 0
5174168 2408145 2408145 defendant Sprynget William yeoman 717501 717501 Sprynget, William, of Sittingbourne, yeoman 4
5174169 2408145 2408145 defendant Trippelowe James yeoman 717501 717501 Trippelowe, James, of Sittingbourne, yeoman 5
5174170 2408145 2408145 defendant Kyng John yeoman 717501 717501 Kyng, John, of Sittingbourne, yeoman 6
5174171 2408145 2408145 defendant Donewey William yeoman 717501 717501 Donewey, William, of Sittingbourne, yeoman 7
5178654 2409471 2409471 defendant Kyng John husbandman 717501 717501 Kyng, John, of Sittingbourne, husbandman 0
5183350 2410870 2410870 defendant Barker Roger yeoman 717501 717501 Barker, Roger, of Sittingbourne, yeoman 3
5192529 2413548 2413548 defendant Ripse Thomas tailor 717501 717501 Ripse, Thomas, of Sittingbourne, tailor 0
5192531 2413548 2413548 defendant Depdale John laborer 717501 717501 Depdale, John, of Sittingbourne, laborer 2
5203836 2416874 2416874 defendant Barker William yeoman 717501 717501 Barker, William, of Sittingbourne, yeoman 0
5203842 2416875 2416875 defendant Umfrey John   717501 717501 Umfrey, John, of Sittingbourne, franklin 1
5203843 2416875 2416875 defendant Mayhewe Thomas husbandman 717501 717501 Mayhewe, Thomas, of Sittingbourne, husbandman 2
5207757 2418008 2418008 defendant Rypse Thomas tailor 717501 717501 Rypse, Thomas, of Sittingbourne, tailor 0
5207759 2418008 2418008 defendant Depdale John laborer 717501 717501 Depdale, John, of Sittingbourne, laborer 2
5270823 2436561 2436561 defendant Kayn John husbandman 717501 717501 Kayn, John, of Sittingbourne, husbandman 2
5308800 2447671 2447671 defendant Mylys John   717501 717501 Mylys, John, of Sittingbourne 0
5308885 2447699 2447699 defendant Braylys William smith 717501 717501 Braylys, William, of Sittingbourne, smith 2
5309972 2448017 2448017 defendant Tounesende William sadler 717501 717501 Tounesende, William, of Sittingbourne, sadler 0
5375872 2468046 2468046 defendant Humfrey Thomas hubandman 717501 717501 Humfrey, Thomas, of Sittingbourne, hubandman 0
5396859 2474186 2474186 defendant Boll John laborer 717501 717501 Boll, John, of Sittingbourne, laborer 2
5398110 2474526 2474526 defendant Noke John butcher 717501 717501 Noke, John, of Sittingbourne, butcher 0
5402842 2475891 2475891 plaintiff Lopham Edmund tailor 717501 717501 Lopham, Edmund, of Sittingbourne, tailor 0
5403170 2475990 2475990 defendant Rogger John butcher 717501 717501 Rogger, John, of Sittingbourne, butcher 4
5410083 2477976 2477976 defendant Bell John   717501 717501 Bell, John, of Sittingbourne 2
5411309 2478341 2478341 defendant Kayme William yeoman 717501 717501 Kayme, William, of Sittingbourne, yeoman 0
5411995 2478539 2478539 defendant Roger John butcher 717501 717501 Roger, John, of Sittingbourne, butcher 2
5412007 2478545 2478545 defendant Philpot Nicholas husbandman 717501 717501 Philpot, Nicholas, of Sittingbourne, husbandman 0
5412009 2478546 2478546 defendant Philpot Nicholas husbandman 717501 717501 Philpot, Nicholas, of Sittingbourne, husbandman 0
5416270 2479793 2479793 defendant Rogger John shoemaker 717501 717501 Rogger, John, of Sittingbourne, shoemaker 0
5419811 2480841 2480841 plaintiff Symnet Thomas   717501 717501 Symnet, Thomas, of Sittingbourne 0
5423780 2482075 2482075 defendant Boll John laborer 717501 717501 Boll, John, of Sittingbourne, laborer 2
5432243 2484612 2484612 plaintiff Lopham Edmund tailor 717501 717501 Lopham, Edmund, of Sittingbourne, tailor 0
5437981 2486297 2486297 defendant Loopham Edmund tailor 717501 717501 Loopham, Edmund, of Sittingbourne, tailor 1
5439006 2486586 2486586 defendant Hert William   717501 717501 Hert, William, of Sittingbourne 4
5440635 2487106 2487106 defendant Blakley John baker 717501 717501 Blakley, John, of Sittingbourne, baker 0
5440644 2487110 2487110 defendant Blakkey John baker 717501 717501 Blakkey, John, of Sittingbourne, baker 1
5455704 2491609 2491609 defendant Hert William yeoman 717501 717501 Hert, William, of Sittingbourne, yeoman 1
5455899 2491672 2491672 defendant Raynford Richard esq 717501 717501 Raynford, Richard, of Sittingbourne, esq 0
5460751 2493162 2493162 plaintiff Lopham Edmund tailor 717501 717501 Lopham, Edmund, of Sittingbourne, tailor 0

Next page

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