names

74 rows where place_id = 588937

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596056 1866394 1866394 defendant Godynough William husbandman 588937 588937 Godynough, William, of Aynesford, husbandman 2
3618370 1873377 1873377 defendant Atmere Roger smith 588937 588937 Atmere, Roger, of Aynesford, smith 0
3642241 1908022 1908022 defendant Wreyght John laborer 588937 588937 Wreyght, John, of Aynesford, laborer 0
3642242 1908022 1908022 defendant Wreyght William laborer 588937 588937 Wreyght, William, of Aynesford, laborer 1
3665975 1915292 1915292 defendant Sykell Thomas gent 588937 588937 Sykell, Thomas, of Aynesford, gent 0
3711426 1929879 1929879 defendant Jetour Nicholas husbandman 588937 588937 Jetour, Nicholas, of Aynesford, husbandman 0
3799192 1957658 1957658 defendant Sybbell Thomas esq 588937 588937 Sybbell, Thomas, of Aynesford, esq 0
3801283 1958326 1958326 defendant Burton William laborer 588937 588937 Burton, William, of Aynesford, laborer 0
3815216 1962676 1962676 defendant Lese Thomas yeoman 588937 588937 Lese, Thomas, of Aynesford, yeoman 0
3815219 1962676 1962676 defendant Gybson alias Tayllour Nicholas (legal representative) 588937 588937 Gybson alias Tayllour, Nicholas, of Aynesford, yeoman, executors of 3
3815220 1962676 1962676 defendant Stonehowse Robert yeoman of the guard 588937 588937 (Stonehowse, Robert, of Aynesford, yeoman of the guard 4
3819647 1964024 1964024 defendant Fayerman Walter husbandman 588937 588937 Fayerman, Walter, of Aynesford, husbandman 1
3850390 1973711 1973711 defendant Pymagowe Henry   588937 588937 Pymagowe, Henry, of Aynesford, knight 2
3887637 1986113 1986113 defendant Kyng William yeoman 588937 588937 Kyng, William, of Aynesford, yeoman 0
4613500 2235240 2235240 defendant Dawe John   588937 588937 Dawe, John, of Aynesford 0
4788714 2292525 2292525 defendant Parker Ralph husbandman 588937 588937 Parker, Ralph, of Aynesford, husbandman 1
4884213 2321971 2321971 defendant Cook John laborer 588937 588937 Cook, John, of Aynesford, laborer 0
4947526 2341220 2341220 defendant Grenewey John, senior husbandman 588937 588937 Grenewey, John, senior, of Aynesford, husbandman 0
4958524 2344517 2344517 defendant Holyndon Thomas   588937 588937 Holyndon, Thomas, of Aynesford laborer 4
5001548 2357346 2357346 defendant Holynden Thomas laborer 588937 588937 Holynden, Thomas, of aynesford, laborer 1
5003439 2357902 2357902 defendant Stenyng John laborer 588937 588937 Stenyng, John, of Aynesford, laborer 0
5052530 2372348 2372348 defendant Webbe John laborer 588937 588937 Webbe, John, of Aynesford, laborer 2
5052740 2372415 2372415 defendant Dobson Robert   588937 588937 Dobson, Robert, of Aynesford, Kehtm yeoman 1
5063991 2375761 2375761 defendant Dobson Robert husbandman 588937 588937 Dobson, Robert, of Aynesford, husbandman 0
5065810 2376295 2376295 defendant Wodeward Simon husbandman 588937 588937 Wodeward, Simon, of Aynesford, husbandman 2
5065822 2376298 2376298 defendant Wodeward Simon husbandman 588937 588937 Wodeward, Simon, of Aynesford, husbandman 1
5084323 2381820 2381820 defendant Stone John laborer 588937 588937 Stone, John, of Aynesford, laborer 0
5084324 2381820 2381820 defendant Vale James laborer 588937 588937 Vale, James, of Aynesford, laborer 1
5087701 2382790 2382790 defendant Couper John husbandman 588937 588937 Couper, John, of Aynesford, husbandman 0
5087825 2382820 2382820 defendant Couper John husbandman 588937 588937 Couper, John, of Aynesford, husbandman 0
5094328 2384747 2384747 defendant Mordeon William clerk 588937 588937 Mordeon, William, of Aynesford, clerk 1
5110456 2389463 2389463 defendant Parker Thomas, junior husbandman 588937 588937 Parker, Thomas, junior, of Aynesford, husbandman 0
5118589 2391867 2391867 defendant Heyton William pulter 588937 588937 Heyton, William, of Aynesford, pulter 3
5118604 2391872 2391872 defendant Couper John husbandman 588937 588937 Couper, John, of Aynesford, husbandman 4
5135684 2396947 2396947 defendant Holynden Thomas husbandman 588937 588937 Holynden, Thomas, of Aynesford, husbandman 0
5156363 2403013 2403013 defendant Sybbyng Robert husbandman 588937 588937 Sybbyng, Robert, of Aynesford, husbandman 0
5182894 2410746 2410746 defendant Cluk John husbandman 588937 588937 Cluk, John, of Aynesford, husbandman 0
5203627 2416815 2416815 defendant Cluk John husbandman 588937 588937 Cluk, John, of Aynesford, husbandman 0
5330544 2454224 2454224 defendant Crouche William baker 588937 588937 Crouche, William, of Aynesford, baker 1
5338072 2456478 2456478 defendant Gyldewyn Robert husbandman 588937 588937 Gyldewyn, Robert, of Aynesford, husbandman 1
5341015 2457391 2457391 defendant Hancok William chandler 588937 588937 Hancok, William, of Aynesford, chandler 0
5363089 2464108 2464108 defendant Singleton Christopher yeoman 588937 588937 Singleton, Christopher, of Aynesford, yeoman 0
5369443 2466034 2466034 defendant Moser John laborer 588937 588937 Moser, John, of Aynesford, laborer 2
5375130 2467807 2467807 defendant Hamlyn John husbandman 588937 588937 Hamlyn, John, of Aynesford, husbandman 3
5376756 2468327 2468327 defendant Marklaye Robert laborer 588937 588937 Marklaye, Robert, of Aynesford, laborer 3
5377753 2468625 2468625 defendant Byrd John collier 588937 588937 Byrd, John, of Aynesford, collier 0
5383921 2470487 2470487 defendant Rowse Thomas clerk 588937 588937 Rowse, Thomas, of Aynesford, clerk 0
5383923 2470488 2470488 defendant Rowse Thomas clerk 588937 588937 Rowse, Thomas, of Aynesford, clerk 0
5410438 2478069 2478069 defendant Sybyle John gent 588937 588937 Sybyle, John, of Aynesford, gent 1
5424304 2482235 2482235 defendant Sibile John gent 588937 588937 Sibile, John, of Aynesford, gent 1
5424307 2482236 2482236 defendant Sibyle John gent 588937 588937 Sibyle, John, of Aynesford, gent 1
5429348 2483712 2483712 defendant Horn Thomas laborer 588937 588937 Horn,Thomas, of Aynesford, laborer 0
5443182 2487874 2487874 defendant Sevyle John gent 588937 588937 Sevyle, John, of Aynesford, gent 1
5445469 2488543 2488543 defendant Moger John husbandman 588937 588937 Moger, John, of Aynesford, husbandman 0
5445536 2488561 2488561 defendant Notte William husbandman 588937 588937 Notte, William, of Aynesford, husbandman 2
5445537 2488561 2488561 defendant Sound Roger laborer 588937 588937 Sound, Roger, of Aynesford, laborer 3
5446398 2488817 2488817 defendant Horn Thomas   588937 588937 Horn, Thomas, of Aynesford 0
5454560 2491278 2491278 defendant Bernard John laborer 588937 588937 Bernard, John, of Aynesford, laborer 1
5458241 2492366 2492366 defendant Moger John husbandman 588937 588937 Moger, John, of Aynesford, husbandman 0
5458311 2492384 2492384 defendant Notte William husbandman 588937 588937 Notte, William, of Aynesford, husbandman 2
5458312 2492384 2492384 defendant Sound Roger laborer 588937 588937 Sound, Roger, of Aynesford, laborer 3
5459026 2492593 2492593 defendant Horn Thomas laborer 588937 588937 Horn, Thomas, of Aynesford, laborer 0
5459028 2492594 2492594 defendant Horton Thomas laborer 588937 588937 Horton, Thomas, of Aynesford, laborer 0
5466453 2494903 2494903 defendant Bernard John laborer 588937 588937 Bernard, John, of Aynesford, laborer 1
5470668 2496146 2496146 defendant Horn Thomas   588937 588937 Horn, Thomas, of Aynesford 0
5479068 2498763 2498763 defendant Sybyle John gent 588937 588937 Sybyle, John, of Aynesford, gent 1
5484493 2500279 2500279 defendant Yerton Humphrey husbandman 588937 588937 Yerton, Humphrey, of Aynesford, husbandman 4
5493916 2503087 2503087 defendant Coke William husbandman 588937 588937 Coke, William, of Aynesford, husbandman 2
5499235 2504715 2504715 defendant Oldyngton William   588937 588937 Oldyngton, William, of Aynesford 0
5502111 2505583 2505583 defendant Croche Robert yeoman 588937 588937 Croche, Robert, of Aynesford, yeoman 0
5514817 2509477 2509477 defendant Sybyll John esq 588937 588937 Sybyll, John, of Aynesford, esq 0
5516434 2509971 2509971 defendant Crouche Robert yeoman 588937 588937 Crouche, Robert, of Aynesford, yeoman 0
5521299 2511479 2511479 defendant Jetour Thomas yeoman 588937 588937 Jetour, Thomas, of Aynesford, yeoman 0
5532806 2514809 2514809 defendant A Broke Thomas husbandman 588937 588937 A Broke, Thomas, of Aynesford, 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);